Originally posted by: raj1

I have few records which uses space as delimiter between elements.I have one text element in that record which has few spaces as part of the data.so due the space delimiter it is stopping at the first space of the text element and not reading the full data.how to overcome this problem?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

Unless there is something special about the elements surrounding the element containing spaces it would be challenging to provide an easy solution. Is the element following the issue element numeric? Does it have a unique characteristic you can define in your type tree?

If not I'd suggest trying to get the record format fixed. As a practice non-printable delimiters can make debugging a file difficult. In leu of changing delimiters get the element changed.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: raj1

ivan,
The element having this problem is the last element in the record.The problem with using fixed width is that we donot know the size of this element in the inputfile and the size varies for record to record.Can you have some other way to solve this?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: jvanboga

Not a perfect solution.. If it's always the last element in a record you could handle it in a several ways....

make the last element (1:s)
create a group place the last element in the group as (1:s)

As a reoccuring item in a group it might be easier to work with.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: mikeladd

Probably already solved this on your own by now (I hope), but if it's a few fields in order, with the space delimiter, you could simply read in all of them as one large text field, then when you need to split them out into individual fields in the output just use the WORD function with the delimiter of <SP> between words.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender