HI,
i have a file , this one look like this
aaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbb
cccccccccccccccccccccc
col1,col2,col3
10,a,200
21,b,300
23,d,100
ddddddddddddddd
eeeeeeeeeeee
ffffffffffffffffffffffffffffffffffff
kkkkkkkkk
here i want to read valid records
means (col1,col2,col3
10,a,200
21,b,300
23,d,100)
how do this one.
how to read BODY data by using sequential file
Moderators: chulett, rschirm, roy
Declare your source file to have just one column, an unterminated VarChar. If "INDEX(In.BigColumn,',',1)" is true then the line has one or more commas and then you can parse the columns using "FIELD(In.BigColumn,",",1)", "FIELD(In.BigColumn,",",2)", etc.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Craig's solution is even simpler and more foolproofer
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>