Special characters in a TXT data file
Hi,
In one of our data sets, we have the names of people that contain special characters (like: á, é, ó) and they get translated to multiple character values that skew the data in that row. For example:
Value in the .TXT file contains: László
Value when added to Monarch is: László
And the fields afterwards get pushed over by 2 spaces and that record is ignored. I cannot figure out a trap that will work to include this value.
Is there a setting that can be adjusted or a way to fix this problem?
Find more posts tagged with
Altair EmployeeHi Denise,
Have you tried to change the character set encoding, for example to UTF-8 encoding?
Monarch Classic: Home -> Options -> Input -> Text FilesData Prep Studio: Settings (on Report Design view) -> Input
The default is to use ANSI encoding. Using @Lasse suggestion to change the encoding type to UTF-8 should resolve your issue.
Hi Lasse,
I kept working on this problem after posting and found that if I saved the TXT file from UTF-8 to ANSI worked, so I was very happy. Now I just tried your suggestion and that's even better since I won't be the one using this workspace daily. I'm new to Monarch so I really appreciate your quick help, genius!
Regards, Denise
Altair EmployeeHi Lasse,
I kept working on this problem after posting and found that if I saved the TXT file from UTF-8 to ANSI worked, so I was very happy. Now I just tried your suggestion and that's even better since I won't be the one using this workspace daily. I'm new to Monarch so I really appreciate your quick help, genius!
Regards, Denise
Hi Denise,
Are you working with reports from Ellucian Banner or Colleague? Or another ERP system?
We're building a library of pre-built templates for those systems and others in our Monarch Model Library.
If you don't see a system you work with on that list let us know and we'll add it to the list.
Hi Denise,
Have you tried to change the character set encoding, for example to UTF-8 encoding?
Monarch Classic: Home -> Options -> Input -> Text Files
Data Prep Studio: Settings (on Report Design view) -> Input
Hi Denise,
Have you tried to change the character set encoding, for example to UTF-8 encoding?
Monarch Classic: Home -> Options -> Input -> Text Files
Data Prep Studio: Settings (on Report Design view) -> Input