DSXchange

Hi
my data is like this


abc~#asdf~#hdsajds
the delmiter is ~# how do we read this I tried giving the delimiter as ~# but it is reading #also how to avoid this

Thanks
M

In your sequential file stage, specify Format -> Record Level -> Record Delimiter String as "~#" (without the quotes).

abc~#asdf~#hdsajds

these are the column names how to import the sqeuential file table definition. I tried with sequential file table definitions but not working.

Any ideas really helpfull

I assumed those were line terminators, not column delimiters.
Change your sequential stage to declare "~#" as your Field Delimiter String.

use the sed command to replace ~# to comma delimiter and call sed command in filter property. Make sure insided the data you should not have same pattern (~#).

Hi,

Need to run any script?Or use external filter/seq file options?Please give clarity regarding this.Where should we write sed command to resolve this?

Thanks in advance
Sreeni

There's no need to do anything external if you use Arnd's solution.

The solution from srinivas.g requires that the file be pre-processed - it does not matter where.