extracting E or W from a street name

[jobillborf]

Hi, I have a field called xfstreet. This field is a street name. For examble if the streetname starts with a direction E or W I would like to extract it.

So E 96th ST would give me a value of E.

Thank you

 

[princessinthetower]

Try this:

Create a formula @Direction

if left({address.xfstreet},1) in ['N','S','E','W']
and instr({address.xfstreet},' ') = 2
then left({address.xfstreet},1)

 

[jobillborf]

Hi, I have a field called Addrqual which is a CHARACTER
FIELD. The Field lenfth is 254. For this problem I would like to insert a formula field called @address after the word APEX. On the first line there could be the words "FRONT OF" "OPPOSITE" "ON".


APEX
0 FROM COMMONWEALTH AV
COMMONWEALTH AV/ROSEDALE AV

 

[jobillborf]

PLEASE DISREGARD. THANK YOU