Null ASCII fields in Tab Delimited File

[pbackstrom]

My source file is tab delimited. Some places it has Tab, Null, Tab (09, 00, 09 in Hex). As soon as Informatica hits that sequence, no fields in the rest of the row are loaded.

To me, it should load the Null and keep going. Access and Excel have no trouble with it; the whole row loads into the right columns. Any hints (other than changing the source file to send 09 09)? Thanks.

 

[pbackstrom]

FYI I wound up going back to the data provider who agreed to give me consecutive delimiters instead of nulls, so nobody has to spend time testing a solution. If you do know one, of course, post it -- it would be more comforting to know that Informatica can handle whatever's in the file...