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!
Solved! Go to Solution.
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?
Great!
You could try the same thing, except with the regular expression,
[[:punct:]\d]
to replace all punctuation and digits with an empty string.
Alternatively, using the Parse method you could use,
([\u\s]+)
To extract alpha characters and spaces.
If you only want to replace characters before the "apple pies" (and leave everything after) then you can use,
^[[:punct:]\d]+
If you end up with leading or trailing spaces, you can just use the Data Cleansing Tool.