LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  UTF-8 data export issue

    Employee
    Posted 05-24-2017 12:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: islandz

    I have imported some data...with some records having accented characters. Through the entire workflow, the accented characters are maintained, however, when I export, the accented characters are converted to what looks like escape codes. For example Orl�ans becomes Orl\xe9ans.

    I am exporting using the Output Fixed node.

    Is there a setting in there that I need to use to export to UTF-8?

    Thank you


  • 2.  RE: UTF-8 data export issue

    Employee
    Posted 05-24-2017 13:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    Is the field unicode? Can you convert the field to string and then output?


  • 3.  RE: UTF-8 data export issue

    Employee
    Posted 05-24-2017 13:38

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: islandz

    Okay - it seems that converting to string has corrected the accent conversion issue.

    Now, is there a way to specify the encoding of the output file to be UTF-8? This is a requirement of the mainframe job that will be using this file to import data.


  • 4.  RE: UTF-8 data export issue

    Employee
    Posted 05-25-2017 07:22

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    Here's a couple of unsupported nodes but might help you write out as unicode.

    input.txt
    utf8_out.brg
    Attachments:
    utf8_out.brg


  • 5.  RE: UTF-8 data export issue

    Employee
    Posted 08-08-2017 13:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: islandz

    Thank you for this node. Is there a way to have this as fixed width, rather than delimited?