Hi there,
I have several V-Strings that I am wanting to trim. The data comes in as seen below.
550-Apples
600-Oranges
780-Bananas
I want the output to read
Apples
Oranges
Bananas.
Any help on this is much appreciated.
Thank you!
Hi @nwatzlaf
The easiest way is to use the Regex Tool set to replace with pattern,
\U
See attached
Philip
That worked thanks!!
I have a quick follow up question.. if I have something like 880-Apple Pies it spits out ApplePies. Is there a way to fix this spacing so it reads Apple Pies. There are a bunch of two/three word combinations with variable spacings. Is there a way to account for this?
