SOLVED
Text to column and then delete all between two characters
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
saivig68
7 - Meteor
‎07-23-2018
01:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All ,
I have the following text field
E.G : $0-$100 (1)|$101-$250 (17)|$251-$500 (17)|Men's (35)|Yellow Gold (35)|20.00 Inch (35)
I am trying to achieve the following
- Parse everything after |
- Delete everything that starts with '(' and ends with ')'
I tried the following :
- Text to column - delimiter is | - WORKS
- Multi Field Formula and apply Regex (.*)\(.* - DOES NOT WORK
- RegEx Tool with expression (.*)\(.* - WORKS ONLY ON THE LAST - Eg Only removed (35) from above example
Can someone point me in the right direction.
Solved! Go to Solution.
2 REPLIES 2
danrh
13 - Pulsar
‎07-23-2018
01:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rpacheco020
5 - Atom
‎03-04-2022
09:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had the same situation but all the information was between the symbols < and > and it wasn't working.
I had to first replace all < by ( and > by )
After that, your expresion worked perfectly. Thank you very much
