Parse number and string combination

[LEXQ2005]

After JSON Parse, I get the attached data. The data of the JSON_Name field is a combination of data and string. I want to parse it, separate the number and string, and then convert strings to column headers.

The attached file includes the source data sheet (the data need to work on) and the target sheet (to explain the target view I want to get).

[Qiu · Accepted solution]

@LEXQ2005 

Hope this is what you need.

[LEXQ2005]

@Qiu Thanks. Would you please explain the Regular Expression used?

[Qiu]

@LEXQ2005 
I assume your JSON_Name is starting with numbers then following by a "." and the rest would be the Column Headers.

so (\d+) means one ore more numbers.

(.+) means one ore more any characters.

in between use \ to escape . stands for a literal ".".

I always use this site.

https://regex101.com/