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

Text to Columns - Splitting Numbers without Delimiters

bdoni001
8 - Asteroid

Hello everyone!

 

Here is the detail of what I want to achieve.

 

I want to make something like in the picture below:

Number Splits.png

 

Is it possible to achieve the above by using the text to columns tool only? Or are there any additional steps that I have to do?

 

Really appreciate the assistance here.

 

Thank you!

4 REPLIES 4
flying008
13 - Pulsar

Hi, @bdoni001 

 

FYI.

 

录制_2023_11_06_13_52_07_818.gif

bdoni001
8 - Asteroid

Hello!

Thank you for the response!

 

This is definitely what I need. However, can you share the Regex configuration?

flying008
13 - Pulsar

Hi, @bdoni001 

 

If your text contain number and string char, maybe you can use expression '(.)

 

录制_2023_11_06_14_41_21_584.gif

 

******

If can help you get your want, please mark it as a solution and give a like for more share.

bdoni001
8 - Asteroid

Once again, thank you very much!

Labels