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.
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