Regex Parse Text based on length

[janety0127]

Hi,

I have a template where I need to parse company name to 2 fields: Company Name Line 1 and Company Name Line 2. I can only fit 35 characters in each cell. How do I configure the regex to parse a name so that it takes the first 36 characters into field 1 and the remaining into field 2? Thanks in advance.

[AngelosPachis]

Hi @janety0127 ,

To do what you are looking for, your regex should be:

(.{36})(.*)

That means that the first capture group, I want to be any character 36 times, and the second group everything past those 36 characters.

Cheers

Angelos

[SeanAdams]

Hey @janety0127 ,

As @AngelosPachis says - you can use the {35} control.

Here are some regex resources to make your life easier:

• I find http://regex101.com very helpful to get the actual regex syntax right - it can be tricky.   
• Training here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...
• There is a ton of info on regex on the internet more broadly
• multiple weekly challenges that you can solve with regex if you want to practice https://community.alteryx.com/t5/*/bd-p/weeklychallenge