Parsing Data

[olehr]

Hi there. 

I have some data that is slightly difficult to work with. A sample is pictured below. 

This is how the data is currently, and what I want is to parse out the car brand, model and year in separate fields, such as the example below. 

This seems to require regex-skills that i do not have 😛 

Could someone help me with this? 🙂

[OllieClarke · Accepted solution]

HI @olehr Using a regex tool with the following formula you get what you want:

(\S+)(.*?)(\d{4})(.*)

Then a multi-field formula to remove any leading or trailing spaces.

However, this is based on the logic that car brands are single words. Otherwise it is very difficult to tell the difference between a car brand and a model - e.g. 'Volkswagen New Beetle' and 'Alfa Romeo Spider'.  If you had a lookup table of car makes, then that would probably be a better way of doing this

I've attached both workflows below

[olehr]

Thank you @OllieClarke, this helped 🙂