Hello dear community,
I am working on a workflow where I am looking to separate the information in a .txt file by columns. However, inside the file there are names that can be composed from 1 word to many, and as each part of the name is separated by a space, the Text to Columns tool seems not to be the best option.
Attached you will find an example of the .txt file I am working on.
What I want to achieve is to extract the name with some pattern using the Regex Tool, and that name is in a new column.
Example
New Name Column
BRUNO DIAZ
STATE BANK S.A.
CARLOS'S BAKERY S. A.
HEALTHCARE INSTITURE LTDA
After that, I want to replace in the Field_1 column what is within the New Name Column Field by "", that way I can easily separate the information using the Text to Columns Tool.
I would appreciate any help, as I have not been able to find any other way.
Thank you very much!
