I have below text and I need to get address after @ . This is my expression (?<=@).+ which is giving the entire line. I need to get it till ON. ON is constant for 99 percent of cases.
Text:
P0 # 23751181 Req #1 Ref # Due Date: 06/18/2020
RT INSPECTION @ 2465 HURONTARIO ST. SUDBEERY, ON WE MAY 8/2020 - DAVID.D/J.SHAW ** SHELL
CONTACT MIKE MARKER **
Desired Output as below:
2465 HURONTARIO ST. SUDBEERY, ON
need regex help for below text:
ATT: Accounts Payable-Vivek Patel, Jacqueline Clark
Approval: David Smith, Michael Frank REFERENCE: WO# 23865196
REGION QTY PRICE TOTAL
CIVIC ADDRESS
20 50 Sky Harbour Dr -
Brampton, Ontario