Splitting column

[Anonymous]

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

[Ritaf1983 · Accepted solution]

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 · Accepted solution]

Text.BeforeDelimiter(
    [Adress], "," 
      ,RelativePosition.FromStart)

[Ritaf1983 · Accepted solution]

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.