Regex Manipulation- Help

[Iswarya_P1 (Iswarya P)]

Hi Team,

I want regex expression for the below text

 ""ClientCode"": ""C10009"",     ""SiteCode"": ""ALLENTOWN DEMO"",     ""OrdeRequestVendorCode"": ""Signant Health"",

From the text, I have to extract the C10009 from the string.

Pls guide me to extract the data over regex.

Cheers!

[lrtetala (Lakshman Reddy)]

Hi @Iswarya_P1

Try this

[rlgandu (Rajyalakshmi Gandu)]

Hi,

Try this
[A-Z]+\d{5}

I hope it helps

[Anil_G (Anil Gorthi)]

@Iswarya_P1

Is this a json string that you are getting?

If so use desirialize json and then use
Jobj("ClientCode").ToString

Or if you need regex only then try this

System.Text.RegularExpressions.Regex.Match(str,"(?<=ClientCode"""": """")[A-Za-z0-9]*").Value

Cheers

[vrdabberu (Varunraj Dabberu)]

@Iswarya_P1

Try this

Regards

[Iswarya_P1 (Iswarya P)]

The client code data may vary. It will not have the same character and number of digit counts. I want to extract the client code information from the string

Cheers!

[vrdabberu (Varunraj Dabberu)]

@Iswarya_P1

you can use the below mentioned regex expression so what ever the client id it will extract the data

Regards

[rlgandu (Rajyalakshmi Gandu)]

So try this
[A-Z]+\d+

[pravallikapaluri]

Hi @Iswarya_P1
““ClientCode””:\s*“”(.?)“”.

[Iswarya_P1 (Iswarya P)]

Sorry, It will work but the regex matched for two more data in my string. So Will you pls give me, How to extract the client code after the colon? It will be very helpful for me.

Cheers!

[lrtetala (Lakshman Reddy)]

@Iswarya_P1

Try this

(?<=ClientCode\"": "").*([A-Z]\d+)

[vrdabberu (Varunraj Dabberu)]

@Iswarya_P1

Can you share the properties of that activity.

regards

[rlgandu (Rajyalakshmi Gandu)]

(?<=ClientCode"“:\s+”")[A-Z]+\d+

Try this hope it works

[Anil_G (Anil Gorthi)]

@Anil_G

System.Text.RegularExpressions.Regex.Match(str,“(?<=ClientCode”“”“: “””“)[A-Za-z0-9]*”).Value

@Iswarya_P1

Please check the above

Cheers

[vrdabberu (Varunraj Dabberu)]

@Iswarya_P1

try this and let me know

regards