Where does SEK come from?
Is this an example how the text is, or is it identically.
If you give us more information, I would use some GREP to change it.
The text is in a table/cells like this:
SWEDEN_SEK | DENMARK_DKK | USA_USD
And I need to change it to:
SEK | DKK | USD
This should work:
find in GREP (\w+)_(\L\L\L)
Hi Peter Spier,
your Grep is right for all three cases, but in my eyes to much »or’s«
if you (perhaps) need an universal Grep than you can try something like this:
nothing (empty field)
Please try and give us information if you have wrong positiv or wrong negativ match (always with the »string« respective)
If no space in the name of countries, just:
Search: [^ ]+_
Replace: by nothing
I like that one...
Alas! won't work with "Christmas Island"!
… but this does: [^|]+_
Christmas Island (of course!)
Democratic Republic of the Congo (Kinshasa)
États-Unis [in French]
Only one thing: insert a grep style to simulate the space after | (disappears with the regex) or launch a second regex: search "|" and replace by "| "
Sorry! Nobody is perfect!
… We always think to search what we don't want to keep ! but sometimes it's easier to find what we want to keep !
For that, I use a grep style (what I want to keep!), 2 conditions (Invisible [what I don't want to keep!] ; Visible [what I want to keep!]) applied with 2 simple research.
Then, just click in the Conditions panel! [I recognize it's a way that can be more complex but useful. So don't forget Conditions!]
[ After that, if you really want to delete the "invisible" text, just search the condition and replace by nothing ! DONE! ]