topic Re: Text to Columns - Splitting Numbers without Delimiters in Alteryx Designer Desktop Discussions

Text to Columns - Splitting Numbers without Delimiters

bdoni001 — Mon, 06 Nov 2023 05:15:12 GMT

Hello everyone!

Here is the detail of what I want to achieve.

I want to make something like in the picture below:

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!

flying008 — Mon, 06 Nov 2023 05:53:15 GMT

FYI.

bdoni001 — Mon, 06 Nov 2023 06:33:02 GMT

Hello!

Thank you for the response!

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

flying008 — Mon, 06 Nov 2023 06:45:59 GMT

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

******

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

bdoni001 — Mon, 06 Nov 2023 06:43:15 GMT

Once again, thank you very much!