I hope I’m not overlooking the obvious.
I’d like to use columns like name, address 1, address 2, address 3, city, state, and zip.
From that, I’d like to make a column with embedded newlines, formatted as a standard address.
Is this a job for JavaScript?
Admin
July 8, 2021, 9:11pm
2
It would be easier with Substitute . See attached.
substiute.transform (1.8 KB)
1 Like
Admin
July 8, 2021, 9:45pm
3
And to remove blank lines:
1 Like
Cool - many thanks!
There are many things like this that wouldn’t take long to implement with a short Python script, but Easy Data Transform is quick and allows for exploration.
Very nice tool!
1 Like