Hi, I need to split a column into two columns by separating a leading Number from some Entries from the text. I tried it with “Split Column” and this regex “^(\d+)\s+(.*)$”
Text is like this (with columns bevor and after):
12413224 Some Text With Nonsense
Another Line with text without leading number
63677474 And again a leading number with following text
…
But the result ist only one column with the text on the rows where no number is present.
What am I doing wrong?
Thank you very much,
Oliver
I think the split column will not solve your topic completely, as even if it works you will have split the first and the 3rd row into two columns, but th second one would stay in first column.
I recommend a copy column followed by replace, in the first column you cut out only the numbers in the second the text part. But for the regex, you need an expert, this is not my area of knowledge.
