The input file is a fixed width '.dat' file and we read the file using a 'Sequential file' stage and we segregate the columns based on the position as the input file is fixed width. The issue arises when we started receiving the multi-byte characters in name and address field.
Since the multi-byte characters occupy more than one character, sequential file stage reads it wrongly. I even changed the NLS setting to UTF-8, but it didn't work. Please advise how to resolve this issue.
Issue with reading the fixed width multi-byte characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Fri Mar 04, 2016 4:37 am
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore