Lingo does not recognise German characters such as ü ö ä

[Mohinda]

I imported a CSV file containing German translation into Lingo Termbase that I created on the local drive. I noticed that characters such as ü ö ä were not recognised in Lingo Termbase. Theses were replaced with the question mark symbols.
Has anyone seen this behaviour and know how to fix this?
Thanks

[kwag_myers]

I've had this issue importing files into Flare and have a Visual Basic Script to replace the characters with XML syntax. Unfortunately, I can't seem to get it to work for your characters. I was able to use NotePad's Find and Replace:

Replace ä with ä
Replace ö with ö
Replace ü with ü

Make a copy of the CVS file so you have a backup. If you need to replace more characters, you can look them up here and use the numbers in parentheses (third column).

[Mohinda]

Thank you for your help. It worked.
MadCap Support suggested to save the file as workbook in Excel and then import it. It worked too.