Convert text to number

I have an output file that is returning a few columns, one with numbers in them. The problem I am encountering is that the column with numbers is coming out as text. Is there an option to have the output file have the column with numbers return numbers instead of text format?

Workflow

Designer Cloud

Output

Accepted answers

Jay-RDC

Yes. Try to change it to int or fixed decimal. You can also parse 2022-05 YTD using text to column to separate the string and use auto field tool or select tool to change the data type.

whubbard88

Thank you! I don't think I did exactly what you did, but I changed the type to Double instead of V_string and it seemed to have fixed the problem.

What a great help you were !!

All comments

binu_acs

@whubbard88 The value of the cell D2 is string type(2022-05 YTD (RC), I think that's why you are getting the string data type for this field

Jay-RDC

You can simply use a select tool and change the data type

whubbard88

Hi and thank you for responding! This is what I have right now selected, is there a different type that I should have?

Jay-RDC

Yes. Try to change it to int or fixed decimal. You can also parse 2022-05 YTD using text to column to separate the string and use auto field tool or select tool to change the data type.

whubbard88

Thank you! I don't think I did exactly what you did, but I changed the type to Double instead of V_string and it seemed to have fixed the problem.

What a great help you were !!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703