Re: count(*) <> "wc -l" of unload file

Posted in 1998

jparker@epsilon.com — Fri, 10 Apr 1998 09:47:27 -0400 — source: Informix-list mailing list archive (1991-1998)

look for the record that someone popped a \\n into. awk 'print length($0)}' <datafile | sort -nu will give you the record lengths of all the diff records. Now go back through and look for the short one: awk '{if (length($0) != $std_length) print}' < datafile of course if you have varchar in there you won't be seeing a std record length, so you'll have to use a range. if (length($0) < low_end || length($0) > high_end) .... cheers j.