parse decimal and hypen

[JenTe]

Hi, need some help in parsing this string data into number. Thanks.

[Field]=84.56-94.67

Output1:84.56

Output2:94.67

[Yoshiro_Fujimori]

You may use Text To Columns tool with "-" as delimiter.

You may also check this interactive lesson.

https://community.alteryx.com/t5/Interactive-Lessons/Separating-Data-into-Columns-and-Rows/ta-p/8018...

Good luck.

[flying008]

Hi, @JenTe 

FYI.