AnsweredAssumed Answered

Scandinavian characters problem

Question asked by Jonna on Oct 22, 2011
Latest reply on Oct 26, 2011 by Jonna


Scandinavian characters problem


I receive daily a text file from a server, which I then import into Filemaker to be processed. Before importing into FM, I have to clean the text file with a text processor for two reasons:

1.  the Scandinavian characters are wrong (the text reads: B‰ckstrˆm, when it should be: Bäckström)

2.  the field delimiters are for MS Access (semicolons instead of commas)

I understand the first problem is a Unicode thing, created by the server from which the files come, and the second is because they expect me to use MS Access, which I won't.

I've tried to make Filemaker correct the Scandinavian characters but for some reason it cannot find all the odd characters at once; I have to do it over and over again, which is strange, and not very practical.

To clean the file I open it in MS Word: open in Unicode -> Western (Windows Latin 1). The Scandinavian characters open correctly. Then I replace the semicolons with commas, and save the file: Other Encoding -> Western (Mac OS Roman). Then I import the file into FM.

This is, of course, not how the process should go, but so far I haven't found any other way to do this daily routine. I would appreciate any help to solve these two problems.

Thank you