Split column which contains a string name and number

Question

Hi everyone,

If i have a column of name

Mary7065

Mary6594

Sue7545

and want two columns outputs

Mary   7065

Mary   6594

Sue     7545

I try to use the parse tool but won't get the output.!!

The regular expression in the parse tool i was using

(.*)(\d*)

and get two outputs RegExout1 and RegExout2 but

RegExout1

Mary7065

Mary6594

Sue7545

and RegExout2 comes out NOTHING.

What am i doing wrong.?

jdunkerley79 · Accepted Answer

Hi,

The expression you were using needs only a minor change to make it work:

(.*?)(\d*)

The question mark makes the first term non-greedy and so the \d will get the numbers.

Alternatively, you could use:

(\D*)(\d*)

Which will explicitly match non digit characters in the first part.

mxledesma · Accepted Answer

Hi  jdunkerley79

(.*?)(\d*)

This did Not work but, your second expression did the job.

(\D*)(\d*)

Thanks,

so much. '

Michael