Pulling out multiple pieces of data from multiple combinations of strings

[JonaV90]

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,

[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)$

[binuacs]

@JonaV90 One way of doing this

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

[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,

[binuacs]

@JonaV90 

[JonaV90]

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,