Regex to Only show data before a certain character

Reply
Highlighted
White Belt

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


Accepted Solutions
Highlighted
Red Belt

Re: Regex to Only show data before a certain character

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)

All Replies
Highlighted
Red Belt

Re: Regex to Only show data before a certain character

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)
Highlighted
White Belt

Re: Regex to Only show data before a certain character

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

Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!