Regex to Only show data before a certain character

DMJerry

Hello,

 

I have data that looks like this:

line_items_name	Goal
Banks Short | Navy Camo - Navy Camo / S	Banks Shorts
The Rise The Shine Tee | Charcoal - Charcoal / L	The Rise The Shine Tees
Classic Vuori Tee | Heather Grey - Heather Grey / S	Classic Vuori Tees

 

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

 

Thank you,

 

DMJerry

MarkSnodgrass

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.