on 11-04-2022 9:51 AM
Hello,
I am copying values from an excel sheet into another program using the "Get Cells (Values)" action from the excel package. For some reason it changes commas into point for decimal values.
I.e. 150,02 becomes 150.02.
Thats a problem because the program I am pasting the values does not accept decimal values with a point, besides that this change isn't intentional.
Best regards,
Philipp
Hi geigerp,
Not sure about why Get Cell Values is behaving as such. Is it possible to store values in excel without comma format. Alternatively another quick workaround would be to suppress point/period "." values before they get picked up by the program
Can use below JavaScript code (within Custom Script Activity)
// in general
string.replace('characterToReplace', '');
// to delete period value
string.replace('.', '');
Regards,
Vishal Rathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.