Regular Expression help-Regex

[rlgandu]

11052493P00012CBD | Legacy Private Line
11052493S00038989 Metro LAN Service 1 Gbps 1 700.00 700.00--------->Metro LAN Service

11052493P00012CBC | Legacy Private Line
11052493S00038987 Ethernet------------------->Ethernet

11052493P0001F4F8 50Mb - Intracity Ethernet LAN Extension
11052493S00060634 A Endpoint 1 125.00 125.00----------------->A Endpoint

11052493P00014186 Legacy Private Line
11052493S0003BAC7 A Endpoint 1 200.00 200.00----------------->A Endpoint

11052493S000389C7 Ethernet------------------->Ethernet

[B_H_Akshatha_Pai]

Regards

[rlgandu]

@B_H_Akshatha_Pai

I need to all other expressions also

[B_H_Akshatha_Pai]

yes am sending it one by one
kindly check the above thread

[rlgandu]

I need to extract all the expressions one at a time

[Quenton_Wayne_Rebello]

Try this, (?<=\d{8}S\d{8}|\d{8}S\d{4}\w{3}\d)[A-Za-z\s]{2,}

[Yoichi]

Hi,

Can you try the following sample?

mc = System.Text.RegularExpressions.Regex.Matches(strData,"(?<=\n\w+\s+)[A-Za-z ]+(?=.*\r?\n\r?\n|\r?\n$|$)")

Sample20230821-5L.zip (2.6 KB)

Regards,

[tazunnisa.badavide (Taj)]

Hey! @rlgandu Can u try using this regex pattern:
(?<=\d{8}(S)(\d{8}|\d{4}[A-Z]+\d{1}|\d{6}[A-Z]\d{1})\s+)([A-Za-z\s]+)

[B_H_Akshatha_Pai]

REGEX : (?<=\d{8}S\d{8}\s|\d{8}S\d{4}\w{3}\d\s)[A-Za-z\s]+(?=\s)

Regards,

[Brian_Mathew_Maben]

Hey @rlgandu ,

Try using this: (?<=\d{8}S\w{8} )[A-Za-z\s]+

[vrdabberu (Varunraj)]

Hi @rlgandu

Please try the below regex expression

(?<=\w{17,}.*\s+\w{17,}\s).*[a-z]+

Hope it helps!!

[vrdabberu (Varunraj)]

Thank You @rlgandu

Happy Automation !!