Hi,
Hope some can help me with below conversion. I have tried to search for a soultion but I couldn't find it.
This amount will come from the source 1.250,60 and I need to transform it to 1250.60
Please advice me how or where to look for this to help me further.
Thanks
Tlam
Decimal Conversion
Moderators: chulett, rschirm, roy
There are probably other ways, but I'd bring it in as a string, remove all the 'punctionation' and then divide by 100:
Code: Select all
Convert(",.","",LinkName.FieldName) / 100
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:There are probably other ways, but I'd bring it in as a string, remove all the 'punctionation' and then divide by 100:
Code: Select all
Convert(",.","",LinkName.FieldName) / 100[/c ...[/quote] I will try if this helps. Thanks for the advice.
chulett wrote:There are probably other ways, but I'd bring it in as a string, remove all the 'punctionation' and then divide by 100:
Code: Select all
Convert(",.","",LinkName.FieldName) / 100[/c ...[/quote] Chulett, thanks for the advice, it worked.