Extracting words using regex

BILL FROM:
TCS
Mrlinnium Busiess park ghansoli
Navi Mumbai, MH, 400701
i want to extract the address using regex how to do it please help

Hi @alan.prakash

Could you share the output with us

Regards
Gokul

Hi @alan.prakash

How about this expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?s)BILL\sFROM:\n(.*?\d+)").Groups(1)

image

Regards
Gokul

Hello @alan.prakash
Try this
(?<=BILL FROM:\n)[a-zA-Z0-9\w\W\n\s\S]+(?>\S\d\n)

System.Text.RegularExpresion.regex.match(YourString,"(?<=BILL FROM:\n)[a-zA-Z0-9\w\W\n\s\S]+(?>\S\d\n)").toString.trim

image