I got a project to read a text file in which there are about 5000 records. Below is a sample of data file.
@@@,35,20120527,WQ,1900.38*RRR,1K,300507861*RRR,D9, 090499904949*RRR,BLT,111*DDD,472,RD8,20130821
@@@,220,20131020,QQ,454*RRR,1K,300507862*RRR,D9, 010947700046*RRR,BLT,131*DDD,472,RD8,20131021
1) each record start with "@@@"
2) each column separate by ","
3) my project only need to read first 4 columns. That is, if see first "*" then go next record.
For the sample text, I need to read
35,20120527,WQ,1900.38
220,20131020,QQ,454
Can some expert help me?
My big problem is how to code to "Go next record when see the first '*' "?
Go to the complete details ...