changing the comma

[Kinetic_analytics]

Hello great people:

Hope you are doing great. How can I change 414,966 V-String type data into 41466.00? 

Appreciate your help.

[binu_acs · Accepted solution]

@Kinetic_analytics One way of doing this

[Kinetic_analytics]

@binu_acs Thank you. 

[BS_THE_ANALYST]

Hi! @Kinetic_analytics  

Just confirm, did you intend to miss the '9' out? 414,966 -> 41466.00 

[Kinetic_analytics]

Sorry. Unintentional error.  correct number is 414966.00

[BS_THE_ANALYST · Accepted solution]

Given that was a typo, one way to do this:

Step 1: Replace the comma:

Step 2: Change the datatype to a 'double' or a 'float'. Double has more precision. 

[Kinetic_analytics]

Thank you :) Appreciate your time and help @BS_THE_ANALYST 

[BS_THE_ANALYST]

@Kinetic_analytics You're welcome! Have a great weekend.