Hello,
I would like to separate this Vendor field into two columns: Vendor ID and Vendor Name
The ID and name is separated by " : " so I'm trying to grab only the digits on the left side of the colon into a new Vendor ID column. And grab only the string on the right side of the colon into a new Vendor Name column.
For this example, the output I'm looking for would be:
Vendor ID | Vendor Name |
90000075 | EAGLE PRESS INC |
Thank you in advance for your help!
Solved! Go to Solution.
@jxkcho
maybe something like this?
Hi @jxkcho
Here is how you can do it. You can use below regex in regex tool parse mode.
Workflow:
1. Here i am using regex (\d+) : (.+). Where (\d+) captures vendor ID(number) and (.+) captures vendor name after :
2. And you set the rename for the new columns in the output columns section.
Hope this helps 🙂
@atcodedog05 @Qui
Thank you both!!