Parse out the first 3 characters

[wonka1234]

Hi,

I am trying to parse out the first 3 charcters of a string.

ie NBA100 , NBA48B, NBA50, should now be 100 and 48B, 50.

[DataNath · Accepted solution]

How does this look @wonka1234? This will be fully dynamic, in case your strings don't always begin with 'NBA'.

REGEX_Replace([Full], '.{3}(.*)', '$1')

[messi007]

@wonka1234,

Please see below :

Attached the workflow,

Regards,

[binu_acs]

@wonka1234 one way of doing this

TrimLeft([Field],'NBA')

[binu_acs]

@wonka1234 also you can use the below formula

Substring([Field],3,Length([Field]))

[dlesny · Accepted solution]

Hi All

None of the answers quite matched my case so here is another way that suited me for parsing:

RegEx tool - Regular Expression - 

^(.{3})\s*