Record Delimiter
Moderators: chulett, rschirm, roy
Record Delimiter
How do I use hex 1e as the record delimiter reading a sequential file? I assume I use the final delimiter string, but how do I tell it to use a hex character?
Not sure how to specify a hex character as a delimiter in the sequential file stage. But probably you can change the character to a coma or any other character using unix command in external source stage. See if this post helps.
viewtopic.php?t=113640
viewtopic.php?t=113640
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you mean, by "record delimiter":
- (a) the character that marks the end of the record (the record delimiter)?
(b) a character that appears between the final field and the record delimiter (the final delimiter)?
(c) the character that separates fields within the record (the field delimiter)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The record delimiter field in the sequential file window only allows the input of the 2 default values, nothing or 1-character so in this particular instance you cannot use the 0x1E type of representation. This should be noted as a bug, in my opinion.
Wasn't there a Windows keyboard shortcut to create characters from their ASCII numeric value? Perhaps a cut-and-paste might work there as well. If not, there are still several alternatives - I would opt for using the UNIX "tr" preprocessing command to convert 0x1E in the source to a real LF (assuming LF does not occur in the file in other places).
Wasn't there a Windows keyboard shortcut to create characters from their ASCII numeric value? Perhaps a cut-and-paste might work there as well. If not, there are still several alternatives - I would opt for using the UNIX "tr" preprocessing command to convert 0x1E in the source to a real LF (assuming LF does not occur in the file in other places).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: