String parsing based on different lengths

Hi,

Is there any way to parse a string based on different, but known-in-advance lengths?

For example:

I have the string "0123456789" and I want to extract 3 substrings of lengths 3, 5, and 2.

This would result in the following 3 strings after parsing: "012", "34567", and "89".

Is there any way to do this in Alteryx?

Parse

Accepted answers

Does this work well for you?

Cheers,

Don't split up the parsing groups with a space.

Everything needs to stick together

(.{3})(.{5})(.{2})

Cheers,

All comments

Does this work well for you?

Cheers,

If you want any character, you can replace "\d" by "."

Cheers,

Hi Thableaus,

Thanks for the quick response. Unfortunately I am not getting the desired behavior from using your recommendation. As you can see in the attached screenshot, I am getting null values where the parsed strings should be. Let me know what you see here. Thanks!

Alteryx String Parse by Length.PNG

Alteryx String Parse by Length.PNG

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335