problem with decimals when reading PDF

oyarzabalyago

Forums

Hi
Thanks in advance Brian for your help.
My problem is that because of my regional convention (Argentina), we use the period "." as the thousandth separator and the comma "," as the decimal separator.
When I try to read a format that the decimal separator is a point ".", The numerical reading generates an error and leaves its value at zero.
How can I cast or modify the code so that this reading is correct for my regional configuration?
 
 
 

Images

oyarzabalyago Wed, 09/16/2020 - 11:56

.

klmi Thu, 09/17/2020 - 01:38

You can set decimals and thousands seperator in Report Reader under File > Properties or by just pressing CTRL+Y.

oyarzabalyago Thu, 09/17/2020 - 09:41

thanks for the answer, it would be fine.
but in my case I am recording a macro that reads PDF.
I think I cannot make the macro change the separator settings depending on the PDF to read ...

since most of the PDF to read has the data as I have it established now

Images

klmi Tue, 09/22/2020 - 02:54

I guess your macro imports the PDF and therefore uses a predefined *.jpm file. When creating that *.jpm file you have to make the mentioned settings and  it will be saved in the file.