Utilizing RegEx

[kimberlyka]

I am trying to split

"106108Banking Crisis" into "106108" and "Banking Crisis" into 2 separate columns.

I currently have the following set up and it is splitting it into "106108" and "Banking"

Could someone please help me troubleshoot as to how I can solve this.

Thank you!

[Maskell_Rascal]

Hi @kimberlyka 

Is there more data you are parsing from the field before/after this? Based on your screenshot that appears to be the case, and I would need to know the rest of what you're parsing in order to write the code. 

Cheers!

Phil

[kimberlyka]

Hi Phil!

The dataset is just more of the same...

"106106IHC Base"

"106108Prolonged Covid"

[Maskell_Rascal · Accepted solution]

@kimberlyka If that's the case, then you can use the following RegEx code. 

(\d{1,})?([a-z].*)

Note that the question mark isn't really needed if your data is all similar. I put it in to account for a random space that may occur between the digits and letters in your field. 

[mceleavey]

Hi @kimberlyka ,

nice and simple, just used the following:

(\d{6})([^\d]+)

And set the tool to Parse:

Hope this helps,

M.