Parsing strings

[JGHOLLAND]

I have a string like "XYZ123456".  I need to parse it into "XYZ" and "1" and "23456".  Is this a regex solution?  

[ScottLewis]

Depends on what other forms the string can take. If it's always 3 characters, 1 character, 5 (or the remainder) then I would do it with substring formulas because they're easier to read and maintain. If it's something like Any number of letters, 1 Number, any number of numbers then probably easier to Regex. 

[usmanbashir · Accepted solution]

@JGHOLLAND 

Are your three sections always as below? 

- 1st three characters

- 4th character

- 5th-9th character

If so use substring function. 

 

[flying008]

Hi, @JGHOLLAND 

FYI.

([a-z]{3,})\s?(\d{1})(\d{5,})

[JGHOLLAND]

Thanks to everyone for the help!