GELÖST
Text to column and then delete all between two characters
Optionen
- RSS-Feed abonnieren
- Thema als neu kennzeichnen
- Thema als gelesen kennzeichnen
- Diesen Thema für aktuellen Benutzer floaten
- Lesezeichen
- Abonnieren
- Stummschalten
- Drucker-Anzeigeseite
saivig68
Meteor
07-23-2018
01:43 PM
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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.
Gelöst! Gehe zu Lösung.
2 ANTWORTEN 2
danrh
Pulsar
07-23-2018
01:58 PM
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
rpacheco020
Atom
03-04-2022
09:15 PM
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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