Help with Parsing Text within Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! I am trying to parse words/numbers into two columns.
Example below
Shirt White 5,000 Pants Yellow 10,000 --> Need to separate into 2 columns 1) Shirt White 5,000 and 2) Pants Yellow 10,000
Pants Black 2,000 Shirt Purple 200,000 --> Need to separate into 2 columns 1) Pants Black 2,000 and 2) Shirt Purple 200,000
Shirt Red 1,000 Pants Green 13,000 --> Need to separate into 2 columns 2) Shirt Red 1,000 and 2)Pants Green 13,000
So Shirt and Pants are always present in a single column. And they are essentially separators for the two columns.
Any ideas are much appreciated!
Thank you so much!!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @kkkim RegEx is your friend here:
This RegEx makes column 1 out of everything before the first space after a number, and column 2 out of everything after that space up to (and including) the final number
Hope that helps,
Ollie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked perfectly!!! Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kkkim glad I could help 🙂