Extract data from the text
- 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 community,
I have set of data as below and would like to seek for assistance how to extract the data below and presneted in the desired output.
Many thanks in advance
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SH_94
Since the single space before the identifier is not always present, this is not possible with a Text to Column tool and possibly do-able with regex but by someone with more skill than I have. A fairly simple, round-about way to do focus on the words immediately before the IDs, "for", "after", "remaining", etc. Add a Record ID to your data and put the word list in a table. Use a Find Replace tool to replace the words from the list with a pipe "|". Split on the pipe and remove the leading space from the ID if needed. Join this back to your input data on RecordID and use a formula too to replace the separated ID fields in the input text with an empty string ("")
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Excellent job @BS_THE_ANALYST.
Regex is all about pattern matching and I missed the pattern. Kudos to you.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator