I posted a question to get the text out of a string without special characters included. I got the answer but upon looking at what I actually needed its not that simple. I had an example that looked something like the following
'~(|_|*|football)~' and I wanted football returned and I am able to do that
I then look at the data in the field and it has the following
blablablablablablabla '~(|_|*|football)~' and then more text blablablablabla
so the part of the string with the special characters is only a portion of the text in the field
I would need the following returned
blablablablablablabla football and then more text blablablablabla
I tried figuring it out but the ticks(') are really screwing me up and whenever I run it the variable screen comes up..