Sudheer,
could you explain the problem a bit more. You said you have a comma delimiter and that is working. What is the format of the rows that are different? Do the rows have the value "..." for just one column?
csv file issue
Moderators: chulett, rschirm, roy
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
One possibility is that you have incomplete rows (rows with delimiters less than expected. If this is the case, when you try to view data on the csv file, you'll get an error message. The problem can be solved by setting (double click on the sequential file / outputs / format) the Missing Column Action as "Pad with empty string".
Sudheer
What you can do is read your csv file record as one single string and then inside your transformer check the total commas you expect for good records. Have two links as ouput. One being the good ones which you wanted to use and the other for the rejected records.
What you can do is read your csv file record as one single string and then inside your transformer check the total commas you expect for good records. Have two links as ouput. One being the good ones which you wanted to use and the other for the rejected records.
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar