Spilt column on Upper case

[jochendecraene]

Hi

Is there a way I can split a column on an upper case? I got a dataset with multiple values but no delimittor?

Here's the problem; I want to seperate first and last names.

[BA_Pete · Accepted solution]

Hi @jochendecraene ,

In PQ, select your [Name] column, then go to Transform tab > Split Column (dropdown) > 'By Lower Case to Upper Case'.

You can change new column names by editing values in the formula bar here:

Pete

[jochendecraene]

Thank you so much for the quick response!