I am trying to use Do Case to update fields in a very large file. I'm having trouble with the exact structure of the code.
i.e. - existing field value = "ARABIC"
new value = "A"
existing field value = "ASIAN"
new value = "B"
I have a data file of 100k+ records. After concatonating the address into 1 field, some addresses have multiple spaces (3-5) resulting from individual fields in the " parsed" address being blank.
here is my code for the concatonate:
set address = allt(stno) + " " +...
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.