changing the comma

Hello great people:

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

Appreciate your help.

Regex

Accepted answers

@Kinetic_analytics One way of doing this

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 One way of doing this

@binu_acs Thank you.

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

Sorry. Unintentional error. correct number is 414966.00

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.

Thank you Appreciate your time and help @BS_THE_ANALYST

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