Parsing numbers and alphanumeric values from blocks of text

[wonka1234]

Hi,

how can i parse or text to columns this dataset so i can extract numbers ie "1" and Alphanumeric ie "2b" out of this?

Thanks.

[Felipe_Ribeir0]

Hi @wonka1234 

Try 

regex_replace([Data], '^(.*?)\s{2,}.*', '$1')

[Felipe_Ribeir0 · Accepted solution]

@wonka1234 

If by extract you mean keep just the rest of the text: