sequential file reading with ~# delimiter

marpadga18 · Post by **marpadga18** » Thu Jul 05, 2012 7:28 am

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

ArndW · Post by **ArndW** » Thu Jul 05, 2012 7:35 am

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

marpadga18 · Post by **marpadga18** » Thu Jul 05, 2012 7:45 am

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

ArndW · Post by **ArndW** » Thu Jul 05, 2012 9:00 am

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

srinivas.g · Post by **srinivas.g** » Fri Jul 20, 2012 2:13 pm

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 (~#).

ssreeni3 · Post by **ssreeni3** » Tue Jul 24, 2012 5:48 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jul 24, 2012 6:03 am

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.