Pulling out multiple pieces of data from multiple combinations of strings

Hi,

I am trying to pull the underlined data in multiple columns from the string in the non underlined field (not including the - )

There are more than these combinations, but could anyone help me set up a formula to pull these pieces of information out of the string combinations below?

HAT2TOPL34Rental 16ft Box TruckP - 10 Characters at the beginning, Rental, 16ft Box Truck, P

HAT2TOPL35Branded 24ft Box Truck (Element - Leased)P - 10 Characters at the beginning, Branded, 24ft Box Truck, Element, Leased, P

HPX3CL34Rental VanP - 6 Characters at the beginning, Rental, Van, P

HBF4ALPC32Owned VanP - 10 Characters at the beginning, Owned, Van, P

Thanks,

Regex

Output

Parse

Expression

Text Mining

Accepted answers

All comments

davidskaife

Hi @JonaV90

This Regex should give you what you need, if i understand what you're looking for correctly!

([[:alpha:]]+\d+[[:alpha:]]+\d+)(.+?)\s(.*)(P)$

Regex.yxmd

binu_acs

@JonaV90 One way of doing this

Regex_1005.yxmd

gyang3

hey @JonaV90

See attached the workflow. I've added an additional tool to parse out those in parentheses.

Let me know if this works and please mark as solved if so.

Regex.yxmd

JonaV90

Hi,

Thanks so much for this.

This is close to where I'm trying to get to.

What I am missing is that I also want to isolate the vehicle type, so in the screenshot you shared I want to have an additional column that only says 24ft Box Truck (without including the additional text), 16ft Box Truck, Van, etc.

Can you help isolate that?

Thanks,

Ok, this is great.

It would be better if all of this could be simplified into one regex tool

One more thing, I have 3 more additional instances in the data that I need to pull the key info from. See below:

I would appreciate anyone's help adding this to the regex tool

Additional:

HAT2CSTG34Owned Van incl. New PSD Insurance PaymentP - 10 Characters at the beginning, Owned, Van, New PSD insurance Payment, P
HAT2CSTG34Rental 16ft Box Truck incl. New PSD Insurance PaymentP - 10 Characters at the beginning, Rental, 16ft Box Truck, NEW PSD insurance Payment, P

HVP1MEM335Rental VanP - 10 Characters at the beginning (3 numbers at the end), Rental, Van, P

Original:

HAT2TOPL34Rental 16ft Box TruckP - 10 Characters at the beginning, Rental, 16ft Box Truck, P

HAT2TOPL35Branded 24ft Box Truck (Element - Leased)P - 10 Characters at the beginning, Branded, 24ft Box Truck, Element, Leased, P

HPX3CL34Rental VanP - 6 Characters at the beginning, Rental, Van, P

HBF4ALPC32Owned VanP - 10 Characters at the beginning, Owned, Van, P

Thanks,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703