Hi,
During Excel import Empty lines from .csv file is reading.
For example in my case I have only 5 records in .csv but after running my x++ job it is processing 15 records i.e. 10 empty lines along with my 5 records. How to avoid these empty lines.
Hi Nikolaos
when I can clear the content of empty lines in csv file it is working fine for me but I am wondering why my code is reading empty lines some times.
Hi Ludwig,
from .csv file I have customer addresses to be updated.
Hi mahiims18,
What data do you try to import from a .csv file?
Can you share details about your job?
Many thanks,
Ludwig
Hi mahiims18,
What data do you try to import from a .csv file?
Can you share details about your job?
Many thanks,
Ludwig
Share
Report
All responses (
Answers (
container roles,readCon;
counter icount,inserted;
int recCount =0,fvalid=0;
delete_from maCustUpdate;
csvFile = new CommaIO(filename, 'r');
try
{
if (csvFile)
{
readCon = csvFile.read();
while (csvFile.status() == IO_Status::OK)
{
readCon = csvFile.read();
fvalid ;
if(readCon)
{
icount ;
This was part of my code, I have almost 200 lines.
While reading the line number 10 is reading 10 lines at a time even though I have 5 records in my .csv file
Hi mahiims18,
Could you please share the code you are using in the job?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
