Error ID: AkEMVkNPdEOMPsUQ
Can someone assist with the RegEx expression that would remove the Error ID: so my output would be AkEMVkNPdEOMPsUQ
Thank you
Solved! Go to Solution.
@bh1789 ,
This string has 3 words. I'd simply use GetWord() and find it with:
GetWord([Field1], 2)
or simply:
Replace([Field1], "Error ID: ", '')
Cheers,
Mark
p.s.
REGEX_Replace([Field1], ".*\s(.*)", '$1')
Hi @bh1789,
This one doesn't really need to be RegEx, which can be a bit more computationally expensive than string functions. In this case, I'd use TrimLeft will work just as well with the formula: TrimLeft([Field1],'Error ID: ')
Hi @bh1789
One way to achieve this is also using Regex tool
Use the Regular expression below
:\s(.*)
Use the output method Parse and you get your output.
Many thanks
Shanker V
Thank you very much James for the simple solution. Question, how would you trim the following (TrimLeft doesn't seem to work with some characters):
IVID/+UuYbjoifvOy to just UuYboifvOy
'DcA3OFVM to just DcA3OFVM (without the single quote in the front)
Hey @bh1789, no problem. Trimleft should work for all characters, I'm assuming the reason it's getting confused here is because the formula is ending when you're entering the ' you want to be trimmed, because Alteryx is thinking that's you closing the quotations. It can be bypassed in this scenario by wrapping the ' in double quotation marks instead.