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) + " " + allt(stpre) + " " + allt(stname) + " " + allt(sttype) + " " + allt(stpost) + " " + allt(apttype) + " " + allt(aptno)
for those addresses that don't have all these elements, it creates multiple spaces. I'm looking for one line of code that can reduce those spaces down to a single space regardless of how many blanks are there, 2, 3, or 5. right now we use a line of code for each "blank" scenario.
Thanks!
here is my code for the concatonate:
set address = allt(stno) + " " + allt(stpre) + " " + allt(stname) + " " + allt(sttype) + " " + allt(stpost) + " " + allt(apttype) + " " + allt(aptno)
for those addresses that don't have all these elements, it creates multiple spaces. I'm looking for one line of code that can reduce those spaces down to a single space regardless of how many blanks are there, 2, 3, or 5. right now we use a line of code for each "blank" scenario.
Thanks!