String parsing based on different lengths

[kmshannon]

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?

[Thableaus · Accepted solution]

Hi @kmshannon 

Does this work well for you?

Cheers,

[Thableaus]

@kmshannon 

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

Cheers,

[kmshannon]

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!

[Thableaus · Accepted solution]

@kmshannon 

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

Everything needs to stick together

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

Cheers,

[MarqueeCrew]

(\d{3})(\d{5})(\d{2})

If you use this for your regular expression, all should be better.

cheers,

Mark

[kmshannon]

Ah good catch. That worked. Thank you so much!!!!