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.

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

8 - Asteroid

Hello Trixians,

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

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:



Any help Or suggestion! 

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:


Hope this helps,



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.




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.

12 - Quasar

You're most welcome @subhajits11