We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

subhajits11
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! 

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

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.



Bulien

RobertOdera
13 - Pulsar

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

 

subhajits11
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.

RobertOdera
13 - Pulsar

You're most welcome @subhajits11 

Labels