Originally posted by: mikedb

I have some data that looks like this....kinda:

"01:7122902358:F119:F210:991000::00",

Every field is a packed decimal and I've shown you the HEX representation. However, the quote, comma, and colon are ascii characters. So, looking at this in complete HEX would look like this:

22013A71229023583AF1193AF2103A9910003A3A00222C

This record has been defined as having a quote for the initiator and terminator. The comma at the end is a delimeter between records in a larger group. In the second field '71 22 90 23 58' there is a HEX '22', the same as my terminator. This creates a validation error. I've tried creating different types of groups with no luck. It sees the second byte in that packed decimal and thinks the record ends. Any suggestions?

Thanks!
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I'd define the quotes as one character fields (i.e. don't define them as initiators/terminators) - as the packed fields are fixed length you don't need the quotes to identify where the data starts or ends.

Olly.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: mikedb

I was able to resolve this. Thanks!
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender