Converting a V-WString to Numeric

[jlfromm]

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. 

[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 · Accepted solution]

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