Skip to main content
Question

How can i set the character set for an Input CAT (txt) file.


jan
Contributor
Forum|alt.badge.img+1
  • Contributor
Hi, How can i set the character set for an Input CAT (txt) file. It seems it is not possible and when writing to a database (UTF-8) the scandic characters get messed up. Shold FME be able to recognize the character set from the file?

 

 

2 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • May 20, 2013
Hi,

 

I dont have much experience with the CAT reader, but, according to the documentation it does not seems to be possible....

sigtill
Supporter
Forum|alt.badge.img+24
  • Supporter
  • May 21, 2013
Hi!

 

 

After reading the file, can you then use a TextDecoder or TextEncoder to properly convert to UTF-8?

 

 

Another option woule be to use the Textfile reader instead of the CAT - reader, and specify the Character encoding. And afterwards one SubstringExtractor for each column to get. Does not work with Generic Readers - however if you always have the same formatted input-file it will work.

 

 

Also you can request safe to include the Character Encoding option on ALL NON-BINARY files READ and WRITE, not sure if that is already a PR.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings