Need help with extracting values from Json Data

Help Studio
, ,
1

Hi,

Can anyone help me to extract Contract Number, Result from below Json Data.

image
image448×613 22.9 KB

Regards,
Satheesh

2

Hi,

Can you share your data as a text file?

Regards,

3

HI,

It might unable to upload file as you’re new user.
I wrote a simple sample as the following. Hope this helps you.

image
image729×657 20.2 KB

Sample20220915-6.zip (2.9 KB)

Regards,

4

HI @g8135

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=contactNumber”:\s“)\d+").Tostring

Regards
Gokul

5

Hello @g8135
Kindly try the Regex method

System.Text.RegularExpressions.Regex.Match(YourString,"(?<="contractNumber"\s:\s)["\d]+(?=,)").Tostring.Trim

image