IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything after char # 3, but up to the last Numerical DIgit. Column 3, LADD DISTRIBUTION LLC - Everything after the Numerical value.
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of August 11, 2017.