String Number Solution

[#1]

Hi everyone,

I have created a macro to allow users you to solve any fields that have a number but represented as a string.(normally when you import a .csv)

For example there are dollar signs $ or commas in the data, or if the negative - sign is on the wrong side or if you want to change it from a euro format for example the comma and decimal point is swapped.

Examples of numbers that can not be converted by changing from string to double using a select tool:

• $1234.56
• 1,234.56
• 1234.56-
• €1.234,56

Please let me know if this helps anyone.

Thanks

Anayet

[TheAero]

Hi,

works perfectly for me, thanks!

KR,

Kevin