Converting a V-WString to Numeric

I have a work flow that I have brought in different spreadsheets information in and they are all V_Wstring, I need to do some calculations but I am not sure how to convert then to numeric

I want to add a formula do I can take my days *Different rates.

Developer Tools

Accepted answers

IraWatt

Hey @jlfromm,

Looks like you want to change to the Double data type as your data has decimals. Also the data looks like it has ',' in it. Here is an example workflow to convert text to numeric data:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

All comments

IraWatt

Hey @jlfromm,

You can use the select tool to change the data type to an integer or double (both number types) like this:

Can you give an example of some of the data. You may need to adjust it so that it converts properly by for instance removing text data from the column.

Any questions or issues please ask
HTH!
Ira

jlfromm

When I switch it to Int64 then I loose that data.

This is what it looked like as a V_WString

After I switched to Int64

jlfromm

When I switch it to Int64 then I loose that data.

This is what it looked like as a V_WString

After I switched to Int64

IraWatt

Hey @jlfromm,

Looks like you want to change to the Double data type as your data has decimals. Also the data looks like it has ',' in it. Here is an example workflow to convert text to numeric data:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703