topic Re: CSV file help-awk in Operating System - Linux

CSV file help-awk

viseshu — Tue, 07 Nov 2006 07:14:43 GMT

Hi All,
I have a CSV file like
"hi","my,home",1245,"hellow",56457,...
"new",73994,"may,get",12335,..
I want to check whether each field is of predefined length(len='2 8 6 8 9')..if lenght of particular field doesnt match it should return the record and field number...Can you please help itout?
NOTE: commas may be present in the double quotes and if any of the fields(character) doesnt contain double quotes then itshud return the record and field number also..

Re: CSV file help-awk

Hein van den Heuvel — Tue, 07 Nov 2006 08:58:33 GMT

See prior discussion in:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1064324

Read it.
Read it again.

Good luck!
Hein.

Re: CSV file help-awk

Peter Godron — Tue, 07 Nov 2006 09:19:32 GMT

Hi,
sqlload the data onto oracle database. It will do all the length checking etc., it will also find any numeric field errors.
The sqlload will provide you with clean data on the database, and an error file with all your records detailed with error location.