how to trim left of a specific word

[barb_mooney]

I have a column of data that looks like this

DIESEL TRUCKDISTRICT 1

TRAILERDISTRICT 10

TRIPAC BATTERYDISTRICT 11

TRIPAC DIESELDISTRICT 2

VP TRUCKDISTRICT 4

I want to remove everything to the left of the word "District"

for the life of me I cant figure out how to do this

Help please!

[ChrisTX]

Try the RegEx tool.

Regular Expression:

(.*)(DISTRICT)(.*)

Output Method: Parse

[ChrisTX · Accepted solution]

Or Regular Expression

(.*)(DISTRICT.*)

which gives this output:

[jsi]

My Excel brain told me to use the formula tool and below formula into a new field:

Right([Field1], Length([Field1])-(FindString([Field1], "DISTRICT")))

where field 1 contains your data

For RegEx mentioned by @ChrisTX it also worked using this : (.*)(DISTRICT.*) but I am still a bit unfamiliar with RegEx myself.

[barb_mooney]

this worked perfectly

thank you!