problem with decimals when reading PDF

5 posts / 0 new
Last post
oyarzabalyago
Offline
Joined: 12/27/2019 - 11:41
problem with decimals when reading PDF

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
Offline
Joined: 12/27/2019 - 11:41

.

klmi
Offline
Joined: 02/13/2019 - 08:41

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

oyarzabalyago
Offline
Joined: 12/27/2019 - 11: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
Offline
Joined: 02/13/2019 - 08:41

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.