G
Guest
The splitting function responses I've read explain how to split text if
there is a separator. I have a phone number field on my form that includes
the 10 digit telephone number. What I would like to do is take the first
three characters off this line, and place this in a new text field (area
code). Then I want to do a lookup on this field with a table I have that
includes all area codes in the US with the state in the second column. I
already have a lot of entries in my table so I don't want to just create a
field for my employee to input the area code separately. Does this make
sense? Any help would be greatly appreciated.
there is a separator. I have a phone number field on my form that includes
the 10 digit telephone number. What I would like to do is take the first
three characters off this line, and place this in a new text field (area
code). Then I want to do a lookup on this field with a table I have that
includes all area codes in the US with the state in the second column. I
already have a lot of entries in my table so I don't want to just create a
field for my employee to input the area code separately. Does this make
sense? Any help would be greatly appreciated.