Remove text based on pattern
#1 : 05/08-19 20:28 Joao Roldi
Posts: 1
|
Hello there!
I'm in need to remove some texts based on a pattern. I didn't find an answer that matches what I need to do. So, I'm asking here I have a bunch of files that have a pattern like this: SOLD - US - 01.JAN - JOHN SMITH - 01TJLCA - YUHMCH SOLD - DE - 02.FEB - ANGELA STRAUSS - 88HCNANLASKC BGHT - MX - 04.APR - HERNANDES FERNANDES - K55 BGHT - SA - 06.JUN - SHEIK ALIBABA - 10000000KBMJ_JCA I want to remove everything after the name, but due to the lack of pattern in the number of characters, I'm having a bit of trouble doing that. Can someone help me? Please! |
#2 : 05/08-19 22:24 David Lee
Posts: 1125
|
I'm sure that a more elegant solution should be possible but the following should work...
Remove Pattern: ([^-]*-){3}( \w*){2}\K.* Using Regular expressions |
|
#3 : 06/08-19 11:55 David Lee
Posts: 1125
|
Reply to #2:
([^-]*-){3} .*?\K-.* will cope with spaces in the name field (ie more than two forenames). The meta-character \K is an instruction not to save the preceding match (not included in the summary in the user guide). |