The rules:
1.) Street Names will be concatenated (all one word)
2.) An address will always have a Direction N,S,E,W,NE,etc.)
example: "1700 GeorgeMason Boulevard N
I need to take a full address that is in (1) field and parse that string into House #, Street Name, Street Type, and Direction and place the new strings into blank fields in the spreadsheet.
I have two tables... Work Requests and Work Orders... They both have their respective data entry forms... my problem is that I want to pull the data into the create Work Orders form from the Work Requests table... then the user can modify the record and write it to the Work Orders table... this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.