Regex help 11.26.22

[lynnsong986]

Hello, the sample text:

“Transmission Network Charge 188.784 kW @ $674.68 2022.”

there can be anything after 674.68, not necessarily 2022 (and there will be other text after 2022 as well)

I need to capture 674.68
the existing expression
(?<=Transmission Network Charge)(?:.* $?)([\d,.]+)
captures 2022 instead. can someone please help?

[Yoichi]

Hi,

How about the following?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Transmission Network Charge.*?\$)[\d,.]+").Value

Regards,

[Anil_G]

@lynnsong986

(?<=Transmission Network Charge)(?:.* $?)([\d,.]+)

Hi @lynnsong986

Try this

(?<=Transmission Network Charge)(?:.*)(\$\d+.\d+)

Happy Automation

Cheers

[lynnsong986]

@Yoichi

(?<=Transmission Network Charge.*?\$)[\d,.]+

thanks both, this works perfectly!
Lynn