Extraction via Regular Expression

[mosa_sleeman (Mousa Suleiman)]

Dears,

I Have the below text file, and it will be always fixed, how can i extract the details via Regular expression?

Contract Duration=2 years
Minimum Acceptable Technical Scoring=70%
Is there previous contract=NO
Contract Number=
Project Name in Arabic=??? ??? ??? ??? ???
Proposed Start Date (DD-MON-YYYY)=01/01/2023
Proposed End Date (DD-MON-YYYY)=31/12/2024
Payment terms=Others
Feasibility Study if Above 1M AED=NO

[THIRU_NANI (NaNi)]

Hey!

What do you wants to extract from the above mentioned text?

Regards,
NaNi

[mosa_sleeman (Mousa Suleiman)]

Hi @THIRU_NANI All data after =

[THIRU_NANI (NaNi)]

Hey!

Try this:

Assign strContractDuration = System.Text.RegularExpressions.RegEx.Match(strInputVariable,"(?<=Contract Duration=).+").ToSTRING

Just change the Contract Duration You’ll get the each item.

Reference:

regex101: build, test, and debug regex

I used separator (Pipeline).

Regards,
NaNi

[rohith.prabhu]

Hello @mosa_sleeman

To get the info you can use the below Regex :
System.Text.RegularExpressions.RegEx.Match(strInputVariable,(?<=\=)(.*)).Value.ToString

Regards,
Rohith

[THIRU_NANI (NaNi)]

Or we can use Split as well

Try like this:

Assign strData1 = strInputVariable.Split("=",C)(1)

The above expression will give you the first data

Regards,
NaNi

[ppr (Peter Preuss)]

you can setup a generic retrival (assumption = is always present) like

And refer to the groups:

group1 ~ key / info
group2 ~ value

[mosa_sleeman (Mousa Suleiman)]

Thanks all