var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: extracting text before a space
I need to extract the first characters of a post code for a set of records i.e.
to show in a combo box as N1, SW12 etc
What function can i use to get these results?
Re: extracting text before a space
Typing this as an expression in a query returns the character number of a space:
FindSpace: InStr([your field]," ")
Once you have the location of the space you can use the MID function to do the rest:
To return the first part of the post code:
To return the latter part:
mid([your field],[FindSpace],len([your field])
Regards - Andy