DSXchange

Hi,
I have a file with |& as the delimiter.
eg: abc|&cde|&fgh|&ijk

I need to extract the values based on the delimiter |&

Tried Field () function, but didn't work here.

any other idea?

Thanks

Just set the stage property to Delimiter String rather than Delimiter (as in single character) and give that value.

That don't work, as i am reading the file entirely..
and the delimiter count is different for each line.

Here is the file looks like

HEADER|&Value1|&Value2|&Value3
Body|&Val1|&Val2|&|Val3|&Val4
Body|&Val5|&Val6|&|Val7|&Val8
Tail|&Date

I am splitting the file and writing into 3 different files (header, body, tail).

Is there any function in Transformer to extract particular field value?

A minor detail you failed to mention in the original post.

I would suggest using the Field() function like you were for a single character, say the pipe as the field delimiter, and then strip the extraneous second character from the field. That or making a pass to convert those pairs to a single character, something that could be as simple as stripping one, then use Field() on the survivor.

That would be a problem,if the source data have | character.

chulett wrote:A minor detail you failed to mention in the original post.
I would suggest using the Field() function like you were for a single character, say the pipe as the field delimiter, and then strip the extraneous second character from the field. That or making a pass to convert those pairs to a single character, something that could be as simple as stripping one, then use Field() on the survivor.

Of course. In that case reverse the choice. That or (as noted) take the extra effort to convert the pair to a single character you "know" won't occur in the source data.

Hi,

Are you or have you imported the table definition for the file as yet?

Please consider that the & sign is not treated as data on input as datastage would see character as a functional character and you cannot use that character as a delimiter value either.
Please attempt first without the &.

Change the delimiter in source with something like and use '~' as your delimiter.

You can do the same within the job.

If you are using sequential file use:

final delimiter : none
quote: none
Delimiter : |

I hope this will help you