var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do you display characters in a field before space
In the address field 1000 My Way, I only want to display "1000".
Cant use the Trim function because the street number could be anywhere from 2 to 5 characters depending on the address.
I appreciate any help.
What you want to do is find where the first space is in the string.
If memory serves correctly you want the InStr() function which goes a little something like this;
Which gives you...
InStr(<StartPos>, <StringToSearch>, <StringToFind>)
This will return an integer value for the first occurrence of a space character (" ").
Instr(1, AddressField, " ")
You can then use the Left() function to trim the string up to this value
So if we combine the two;
I've added the minus 1 because you probably want to return "100" instead of "100 " (note the space).
Left(AddressField, Instr(1, AddressField, " ") - 1)
Hope this helps!