Numbers with XMpie uDirect

[hybrex]

Hi all!

We got an excell file from our customer. He wanted us to add a 1000 seperator to the amounts, we use . here in Iceland (100.000).

When we add the xls file the seperator from Excell disappears. We apply FormatNumber in rules but we can only add a , "comma" (###,###, 100,000). How can I let Xmpie put a . "point" instead of a , "comma" in the seperator?

We then saved the file as a text file. Then the . comes along but then all the numbers ending with a 0 (zero) after the . dont show the last zero, for instance 63.480 shows as 63.48 in Indesign.

Anyone?

Thanks
Birgir

 

[NickB]

Format the column as comma delimited number:
Number
123,456,580
55,460
987,650
16,588
1,365,400
50,100

Save the file as csv.

In the ADOR object use the function FindAndReplace

FindAndReplace(|->[Number], ",", ".")

Hi all!

We got an excell file from our customer. He wanted us to add a 1000 seperator to the amounts, we use . here in Iceland (100.000).

When we add the xls file the seperator from Excell disappears. We apply FormatNumber in rules but we can only add a , "comma" (###,###, 100,000). How can I let Xmpie put a . "point" instead of a , "comma" in the seperator?

We then saved the file as a text file. Then the . comes along but then all the numbers ending with a 0 (zero) after the . dont show the last zero, for instance 63.480 shows as 63.48 in Indesign.

Anyone?

Thanks
Birgir