Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

One dot and delimiter joined and want to separate text from right side.

Highlighted
8 - Asteroid

Hello Trixians,

i have a Colm1 and want colm2 and colm3 (Requirement)

Colm1colm2colm3
Peace comes from within. Do not seek it without.,BuddhaPeace comes from within. Do not seek it withoutBuddha
What you give is what you get.,Byron PulsiferWhat you give is what you getByron Pulsifer
We can only learn to love by loving.,Iris MurdochWe can only learn to love by lovingIris Murdoch
Life is change. Growth, is optional. Choose wisely.,Karen ClarkLife is change. Growth, is optional. Choose wiselyKaren Clark

 

 

but the result I am getting with the configuration in below:
Capturesd.PNG

 

 

Any help Or suggestion! 

Highlighted
Alteryx Certified Partner

Hi @subhajits11 ,

 

this is a case of text to columns using multiple delimiters.

Try this thread, there are many different methods there:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Text-to-Columns-multiple-delimiters/td...

 

Hope this helps,

 

M.

Highlighted
12 - Quasar

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.

 

RNO2_0-1591308112356.png

 

Highlighted
8 - Asteroid

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.

Highlighted
12 - Quasar

You're most welcome @subhajits11 

Labels