Extracting lengths and units of measurement from a string

[eleee3]

Hi there,

I have data about road segments from which I want to extract a unit of measurement (UOM) from. An example of the raw data is as follows:

Road Segment	Road Start	Road End	UOM
Main Rd Segment 10	39.05	47.08	km
Main Rd Segment 11	47081	55670	m
Main Rd Segment 12 55.671-64.3km	0	0
Main Rd Segment 13 64301-69050m	0	0
Pedestrian Bridge Up 35.04 Down 35.70km	0	0
Pedestrian Bridge Up 53000 Down 53400m	0	0

I want Alteryx to look through the "Road Segment" column and extract the start, end and UOM, so that the end result would appear as follows:

Road Segment	Road Start	Road End	UOM
Main Rd Segment 10	39.05	47.08	km
Main Rd Segment 11	47081	55670	m
Main Rd Segment 12 55.671-64.3km	55.671	64.3	km
Main Rd Segment 13 64301-69050m	64301	69050	m
Pedestrian Bridge Up 35.04 Down 35.70km	35.04	35.70	km
Pedestrian Bridge Up 53000 Down 53400m	53000	53400	m

Could someone please explain how to do this in Alteryx?

Thanks in advance!

[grazitti_sapna · Accepted solution]

Hey @eleee3 , This issue seems quite similar to one I provided in your another post. Anyway based on your this data set I have created the solution. Please accept it if it solved your problem.

[eleee3]

Thank you for such a quick and detailed solution, @grazitti_sapna ! 

I'm receiving an error message when I try to use this formula in my file. It says:

The field "" is missing. Compare the tool configuration with the input stream.

Do you know what this error message is about?

[binuacs]

@eleee3 The above error is because of you are missing one of the formula tool column names

[eleee3]

Oh yep that's fixed it, thanks @binuacs !