Parse

[bh1789]

Error ID: AkEMVkNPdEOMPsUQ

Can someone assist with the RegEx expression that would remove the Error ID: so my output would be AkEMVkNPdEOMPsUQ

Thank you

[MarqueeCrew]

@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')

[JamesCharnley · Accepted solution]

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: ')

[Felipe_Ribeir0]

Hi @bh1789 

One way of doing this with regex

(?<=\:\s)(.*?)$

[KrishnaChithrathil]

@bh1789 

You can try this. 

[ShankerV]

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

[bh1789]

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)

[JamesCharnley · Accepted solution]

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.