Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Splitting column

Hello

 

I have a column called"ADDRESS"which has street,city,pincode.Now I want only street in another column.

ex: HOUSE 1234 Manchester Rd, Knoxville, TN,12345-6789 01234

 

Thanks in advance

Pavani

General Comment
Need Help
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi Anonymous 
    You can achieve it with PQ  by following these steps:
    1. Click right-click on your address column and choose the "split column" option << "by delimiter

    2. Select comma as delimiter

    3 . Modify split at 

    Result : (From here just change column names)

    Link to Sample File 

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Ahmedx's avatar
    Ahmedx
    3 years ago
    Text.BeforeDelimiter(
    [Adress], "," 
      ,RelativePosition.FromStart)

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hi Anonymous 
    You can achieve it with PQ  by following these steps:
    1. Click right-click on your address column and choose the "split column" option << "by delimiter

    2. Select comma as delimiter

    3 . Modify split at 

    Result : (From here just change column names)

    Link to Sample File 

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago
    Text.BeforeDelimiter(
    [Adress], "," 
      ,RelativePosition.FromStart)