Extracting quantities from a string into another field

[eleee3]

Hi there,

I have a database which contains information about road segment lengths and locations along the road. The raw data is inconsistent and looks something like this:

Road Segment	Segment Start (km)	Segment End (km)
Main St Segment 9 35.03-49.678km
Supermarket (22.09km)
Main St Segment 10	49.679	58.42
School	57.63	57.63
Pedestrian Bridge - Up 29.032 Down 29.040

I want Alteryx to look through the Road Segment column and extract the start and end lengths for road segments, and the data regarding how far along the road a location is. Using the above example, the output from this workflow would look something like this:

Road Segment	Segment Start (km)	Segment End (km)
Main St Segment 9 35.03-49.678km	35.03	49.678
Supermarket (22.09km)	22.09	22.09
Main St Segment 10	49.679	58.42
School	57.63	57.63
Pedestrian Bridge - Up 29.032 Down 29.040	29.032	29.040

How can I do this in Alteryx?

Thanks in advance!

[grazitti_sapna · Accepted solution]

Hi @eleee3 , Here is my solution. Please let me know if it was helpful to you:

[eleee3]

Hi @grazitti_sapna, that's perfect, thank you!