Originally posted by: bchin74

I am new to WTE...so I am still running..
I have a pipe delimiter file, but the data includes a comma...
Here is the error I am getting...

(Level 2: Offset 7, len 0, comp 4 of 14, #1, DI 00000004:)
Data at offset 7 ('DAMS,ELLA|ADAMS,...') does not match DELIMITER ''
of TYPE X'0004' (01_RECORD RECORD_TYPES Root).
Is there a easy way to fix this??
Thanks!!!
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: FormerBuckeye

IIRC, I went into the type tree and modified the list of accepted delimiters.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: bchin74

can you give more information on what change you make in the type tree to make it not see the comma ","??
I did have the following set already and it still errors out when it see the ",".

Format - Explicit
Track - Places
Component Syntax - Delimited
Delimiter - Literal
Value - |
Ignore Case - No

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

Originally posted by: FormerBuckeye

In your type tree, review the include lists under an item named "Delimiter" (or something similar) and its sub-items with a sub-class "Syntax". Remove the "," from those lists. I believe that's how I did it some years ago. Then again, like I said, it was years ago.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: bchin74

I can not find what you suggested..
What am I missing...
can anyone help me out here..please..
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: bchin74

here is a screen shot on my type tree set up..
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer1

Your problem is so basic, I'm not even sure what you are asking. Why do you think a comma in the data is going to effect anything, unless you set the comma up as a delimiter or something? You probably want to read the all the documentation for type tree.

I would suggest opening a simple map with an input of one record and try getting the input to validate. Make sure the data has the terminators and everything, then run it. The trace file, while complicated sometimes, ALWAYS tell you what is wrong. Post more of it and maybe I can see what it is. Make your input file tiny so the trace is tiny.

-------------------------------------------------------------------------------------------------------------------------------------------------There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender