Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

convert a character field with decimal and thousand in a integer

former_member473547
Participant

‎10-08-2010 7:19 AM

0 Kudos

Hi chaps,

very simple?

I have to convert a character field for ex. '1,254.36 ' into a integer filed, make a calculation and give it back in the same format for screen display or any thing else. (it is in a user-exit => no choice)

Careful for a EUropean user the fields is '1,254.36' BUT the exit may be called by a US citizen and then you have '1.254,36'

Oh, yes, I forgot after the calculation, the fields has to be returned back in the same format

Do you have any ready to use function or any help?

Regards Vincent

1 REPLY 1

former_member195402
Active Contributor

‎10-08-2010 7:28 AM

0 Kudos

Hi,

write your character field to a currency field, mke your calculation, and write the currency field back to your character firld using format options (e.g. CURRENCY)

Regards,

Klaus