How to use regular expression inside Assign VB expression

[aleksandra_sekulovsk (Aleks)]

How can i use regular expression inside Assign activity VB expression? I’m trying to use something like this but it’s not working : arrayText(8).Split({“,”},StringSplitOptions.None)(1).Split({“^\d{5}$”},StringSplitOptions.None)(0)
I’m trying to split the State from Zip Code.

[Pradeep_Shiv]

you want to extract TN 372803??
@aleksandra_sekulovsk

[Yoichi]

Hi,

Hope the following expression helps you.

System.Text.RegularExpressions.Regex.Match(strData,"(?<=[A-Z]{2}\s+)\d{5}").Value

Regards,

[alin.c.mihalea]

Hey @aleksandra_sekulovsk

Try using:
System.Text.RegularExpressions.Regex.Split(your_string, pattern)

[aleksandra_sekulovsk (Aleks)]

I want to extract only TN.

[Yoichi]

Hi,

@aleksandra_sekulovsk

I want to extract only TN.

Can you try the following?

System.Text.RegularExpressions.Regex.Match(strData,"[A-Z]{2}(?=\s+\d{5})").Value

regards,

[aleksandra_sekulovsk (Aleks)]

Thank you very much your solution helped me.