Extract a text from a string

[Sahil_Garg1]

Hi Forum members,

I have a text {Custom=SCH100207;}

I wanted to extract only SCH100207 from this string.

Any leads will be appreciated .

Regards,
Sahil Garg

[prasath_S]

Hi @Sahil_Garg1

Is this always like this starting with custom and ending with a semicolon…

Then we can write a regex

(?<={Custom=)\w*(?=;})

Thanks

[Sahil_Garg1]

Hi ,

Yes it is always

[prasath_S]

@Sahil_Garg1 then please try the above regex it will work…

Curly bracket will come right?

If it comes it will work else we need to remove the Curly bracket from.the regex pattern also

Thanks

[Shiwangi_Mishra]

@Sahil_Garg1

{Custom= SCH100207; }

You can use Substring to get that. Something like this:

variable1 is the main string here.

variable1.Substring(variable1.IndexOf(“=”) +1, variable1.IndexOf(“;”) - variable1.IndexOf(“=”)-1)

[Sahil_Garg1]

Hi Prasath, Hi Shiwangi,

Thanks to both, both solutions are working fine.

@prasath_S , can you please tell me how you made this regex, i want to learn it .

[prasath_S]

@Sahil_Garg1

I learnt from this website,

The regex will search for particular match before and after the pattern we want to capture.

Lookahead and lookbehind

Thanks