Avatar of Chris Jones
Chris Jones
Flag for United States of America asked on

REGEX help

I need some help with a bit of REGEX

i need to find the first occurrence of Location in my string

and the last occurrence of total in my string
And pull the Address from the test
and the phone number from the text
what i tried to use to find all of this info while changing out the word to look for.
^(.*?)(\bLocation\b)(.*)$

Open in new window


here is my sample text


Remit To: TEST, Inc |nvoice 031115 065
$386 PO. BOX 1999 invoice DaIe 08/17/16
a o MIDLAND, TX 29345  Due Date 09/16/16
Emmy Services TELEPHONE: (432) 682-1991 Ticket 002151
Bill T0: BLACK MOUNTA'N Please a this amount: 2 076 6
500 MAIN ST. SUITE 500 P y s ’ ' 8
FT. WORTH, TX 76102
Unit Price Tax
Description Qty UM Price Total Amount Total
Work Completed Date: 11l13/2015
Job Number: 15.40.11.0065
Location: 11031112130:wa
Work Description: CHANGED 10HP MOTOR ON PUMP JACK AMPS 7.3-7.1-6.9.
ELECTRICIAN APPRENTICE: GARCIA, MIGUEL ANGEL 8.00 R/l’ 31.00 248.00 13.64 251.64
ELECTRICIAN APPRENTICE; GARCIA. MIGUEL ANGEL 2.00 OIT 46.50 93.00 5.12 9312
JOURNEYMAN ELECTRICIAN; VAN LEER, LARRY WAYNE 8.00 R/T 39.00 312.00 17 16 329.15
JOURNEYMAN ELECTRlCIAN; VAN LEER. LARRY WAYNE 2.00 O/T 58.50 117.00 6.44 123.44
LABOR Subtotal —770.oo _ 4—2‘0‘5 m
8531; 4WD SERVICE TRUCK 1000 HR 3200 320.00 17.60 337.50
EQUIPMENT Subtotal 320.00 17 60 337 60
BOLT 6.00 EA 1.17090 7.03 0.39 7 42
NUT 13.00 EA 0.42782 2.57 0.14 2.71
NUT LOCK STEEL 114 600 EA 0.73500 4.41 0.24 455
TAPE PIPE 1 00 EA 0.91950 9.92 0.55 10.47
TAPE VINYL 3/5 1.00 EA 22.77000 22.77 1 25 2402
NEW 10MOTORNEW1OHP1200RPM 256T—FRAME 1 00 EA 31040000 818.40 45.01 863.41
LUBE PULL PENETRATlNG SPRAY 1.00 EA 13.30500 1331 0 73 14.04
MATERIAL Subtotal 878.41 48,31 925,72
LOCATION Subtotal 1,968.41 108.27 2,076.68
Terms: NET 30
Subtotal 1.968.41
Tax (NMLE) 108.27
Total 2,076.6
Page 1 of 1

Open in new window

.NET ProgrammingRegular Expressions

Avatar of undefined
Last Comment
Chris Jones

8/22/2022 - Mon
Chris Jones

ASKER
Think i figured out location

\W*((?i)Location: \d+(?-i))\W*
SOLUTION
Terry Woods

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Terry Woods

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Terry Woods

How are you going with this?
Chris Jones

ASKER
sorry i thought i completed this
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy