How to replace comma with dot

HCL Domino Domino Forum
1

Hi All,

My application is lotus notes and SAP integration.lotus notes will send hours to book costs in SAP.here my problem is in US normally they use dot(.) example 2.5,7.5 etc when it ocmes to europe users they use comma(,) example 2,5 or 7,5. when the hours have comma then they are struck in submitting status. Here i need to format the hours to dot(.). when the user enters comma(,) in hours i need to chnage dynamically to dot(.). any idea would be appreciated.

regards

Suman

2

Subject: How to replace comma with dot

3

Subject: RE: How to replace comma with dot

Thanks for your response Willy. It is a text field and now i cant change the whole process. I want to do it at field level instead of changing the script. Field event input translation.Example:

@If(@Contains(Train_Day1_1;“,”);@ReplaceSubstring(Train_Day1_1;“,”;“.”);Train_Day1_1)

Is my approach correct? please guide me if i am wrong…

Regards

Suman

4

Subject: RE: How to replace comma with dot

Yes, that should work, but you don’t need the @If – just use @ReplaceSubstring.