Hi Guys,
I'm creating an address file which I then need to format into columns based on number of characters. However, I am first trying to replace words within the address string to common abbreviations to cut down some of the length.
I have an address string on a file (work.addresses) like so:
123 maple court avenue, anycity, anystate
I have a separate list (work.abbrev) which gives me the abbreviations, it has 2 columns Word and Abbreviation:
Court | Ct
Avenue | Av
I want to know how I can do a tranwrd loop or something similar which will look at the words from the address string against the words on the abbreviations list and on the ones that match replace the matching word with the abbreviation.
final result would be: 123 maple Ct Av, anycity, anystate
I'm not quite sure how to build the syntax..there was a similar topic on here however, it didn't really cover how to loop through a separate list of words to match
Any help would be much appreciated!
... View more