Spreadsheet data to iseries file - character conversion

We received a spreadsheet (excel) with product descriptions in various languages and with numerous special characters depending on the quaint and curious apostrophes - rings - dots hooks and whatever is required for the language in question.

Current working on getting the data from this spreadsheet into the product files and task at hand is Latvian and Lithuanian.

The problem is that whatever way I try I get stuck with some character conversion that does not work properly. Least unsuccessful attempt was copying a CSV version of the spreadsheet to the IFS and then using tools in the Navigator to get data from there to a database file where the text field was defined as CCSID 1200 (Unicode). But even that was nowhere near good enough.

Any ideas warmly welcomed


Med vänlig hälsning / Best regards

Åke H Olsson
[Description: cid:image001.png@01CA1FE6.387A03A0]
Box 433 SE 551 16 Jönköping Sweden visit: Brunnsgatan 11
phone: +46 (0)36 342976 mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29
ake.olsson@xxxxxx<mailto:ake.olsson@xxxxxx> www.pdb.se




This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.