Extracting specific data from a string

[AndreBln]

Hi, 

i am trying to extract certain data from a string field. The issue is that the data to be extracted come in different formats:

texttext text, text 123km text, text text 10.0km

text 26.5km text texttext

text text 47.77km

texttexttext 39.87 km text

text 12 km, text

text,text 56.1 km

and so on.

Any idea how to extract the km lengths from the string fields and convert them into a numeric data type?

Thanks in advance

Andre

[Emil_Kos]

Hi @AndreBln,

I believe you need to change the data type to double:

The output:

If this was something helpful please mark as an answer!

[atcodedog05]

Hi @AndreBln 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AndreBln]

thanks for your support. I didn't specify the problem well enough, so i updated the problem description.

[atcodedog05]

Hi @AndreBln 

Here is a workflow for the task.

Output: you can

Workflow:

You can split on rows to by changing option like below in Regex tool

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

Hi @AndreBln 

Here is a workflow for the task giving numeric info. If there is multiple km its split into rows.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AndreBln]

Great stuff! Thanks a lot

[atcodedog05]

If it solved your task please mark the posts as solution.

Happy to help 🙂 @AndreBln 

Cheers and Happy Analyzing 😀