Re: CSV File Parsing

Give us a sample of your data...

Peter L. Berghold -- Unix Professional
Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg

Comment on Re: CSV File Parsing

Replies are listed 'Best First'.
Re^2: CSV File Parsing by Anonymous Monk on Feb 28, 2013 at 19:43 UTC
Sample Data: `12345,John Dow, 123456 54321,ANDREW MALL, 8888882 987865,BOGGS BUNNY, 2234566 88777,CLARK KENT R, 888666 112222,DAVOLIO DARK F, 3321777` [download] Still a problem with: `if( ($columns[0]!~/^[[:digit:]]+$/) \|\| ($columns[2]!~/^[[:digit:]]+$/) + ) { #stop the program here }` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: CSV File Parsing
by Anonymous Monk on Feb 28, 2013 at 19:43 UTC

12345,John Dow,           123456
54321,ANDREW MALL,        8888882
987865,BOGGS BUNNY,       2234566
88777,CLARK KENT R,         888666
112222,DAVOLIO DARK F,          3321777
[download]

if( ($columns[0]!~/^[[:digit:]]+$/) || ($columns[2]!~/^[[:digit:]]+$/)
+ ) {
#stop the program here
}
[download]

[reply]
[d/l]
[select]