Originally posted by: Rav666

Could you please tell what is release character n an example for release character?
Thank You in advance.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: HariniPriya

Hi
The data which follows after release character represent the data but not syntax
ex: Supose there is a record in the delimited file ,

1 ? ,2 ,3 ,4,5

Here there are total 4 fields are there
Field 1 =1 ,2
Field 2= 3
Field 3=4
Field 4=5

Field 1 = 1,2 in this value there is a comma but release character is preceeded So,we can treat this as Field 1
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Rav666

Thank You so much harini for being so clear.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: paul.brett

The way I would deal with the scenario above is enclosed.

It's a bit of a 'cheat', but I have defined the first field with an initiator of , and a terminator of ,, (double-comma).

Fields 2, 3 and 4 do not have an initiator, but do have a double-comma as the terminator.

The last field has only a single comma as the terminator.

My trace reads:

Data at offset 1 ('Element1') was found to be of TYPE
Data at offset 11 ('Element2') was found to be of TYPE
Data at offset 21 ('Element3') was found to be of TYPE
Data at offset 31 ('John') was found to be of TYPE
Data at offset 36 ('smith') was found to be of TYPE
Data at offset 31 ('John,smith') was found to be of TYPE
Data at offset 43 ('Element5') was found to be of TYPE

I hope this helps

Thank-you.

Paul

Follow me on Twitter

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