Forum Discussion
Solved
Spilt column on Upper case
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.
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
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
Thank you so much for the quick response!