Regex to Only show data before a certain character

Hello,

 

I have data that looks like this:

line_items_nameGoal
Banks Short | Navy Camo - Navy Camo / SBanks Shorts
The Rise The Shine Tee | Charcoal - Charcoal / LThe Rise The Shine Tees
Classic Vuori Tee | Heather Grey - Heather Grey / SClassic Vuori Tees

 

I want just the items to the left of the | to show.  How can I achieve this.

 

Thank you,

 

DMJerry

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    Accepted Answer

    You can actually do this really easily with the Split Columns tile in the Magic ETL. In the Split Columns options:

    1. Choose your column

    2. Select Custom and add the |

    3. You can leave the checkbox unchecked since you don't care about the rest of the data.

    4. Give your new column a name

     

    Hope this helps.

Answers

  • Sorry for the late reply as I was sick for a while but this worked!! Thank you so much my friend.