One dot and delimiter joined and want to separate text from right side.
- 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
Hello Trixians,
i have a Colm1 and want colm2 and colm3 (Requirement)
Colm1 | colm2 | colm3 |
Peace comes from within. Do not seek it without.,Buddha | Peace comes from within. Do not seek it without | Buddha |
What you give is what you get.,Byron Pulsifer | What you give is what you get | Byron Pulsifer |
We can only learn to love by loving.,Iris Murdoch | We can only learn to love by loving | Iris Murdoch |
Life is change. Growth, is optional. Choose wisely.,Karen Clark | Life is change. Growth, is optional. Choose wisely | Karen Clark |
but the result I am getting with the configuration in below:
Any help Or suggestion!
Solved! Go to Solution.
- Labels:
- Parse
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @subhajits11 ,
this is a case of text to columns using multiple delimiters.
Try this thread, there are many different methods there:
Hope this helps,
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @subhajits11
Try this.
step1. seed tag, where tag = Replace([Colm 1], '.,', '*')
step2. parse, text to columns, on the tag (which is * in this instance)
step3. select tool
Please mark as an acceptable solution + like, if it works for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @RobertOdera ,
Perfect and thanks, the main trick was lying here.
Replace([Colm 1], '.,', '*')
and other visitors interested in the text to columns tools, do not miss out on @mceleavey 's comment, that link has very useful and helpful information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're most welcome @subhajits11