Forum Discussion

jochendecraene's avatar
jochendecraene
Helper V
4 years ago
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.

Need Help
Show and Tell
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    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