i want to remove the header line from the csv file...
# suitescriptv
vennila ramasamy
10/10/2023, 2:55 PMi want to remove the header line from the csv file? how to do that?
a
Anthony OConnor
10/10/2023, 3:00 PM Copy code
let fileObj = file.load({id: fileId});
const iterator = fileObj.lines.iterator();
//skip the header
iterator.each(function () {
return false;
});
let newContents = '';
iterator.each(function (line) {
newContents += line.value;
});
log.debug(newContents);n
Nathan L
10/10/2023, 3:00 PM Copy code
const removeHeaderLine = (csv) => {
const lines = csv.split('\n');
lines.shift();
return lines.join('\n');
}Nathan L
10/10/2023, 3:00 PMoh i like anthony's better
😂 1
a
Anthony OConnor
10/10/2023, 3:04 PMI mean they're both fine
n
Nathan L
10/10/2023, 3:05 PMAlso this is the perfect type of question to ask chatGPT. May speed up your process a little if you don't want to wait for a response here
Nathan L
10/10/2023, 3:06 PMAlthough looking at what it wrote maybe not. Its weird that it joined the string the separated it again to return
e
ehcanadian
10/10/2023, 3:07 PMIt's also assigning the NS file module to the file variable
sadblob 1
n
Nathan L
10/10/2023, 3:07 PMOk ignore everything i said. +1 for humans, -1 for robots
😂 2
n
NElliott
10/10/2023, 3:17 PMMy bot replied:
n
Nathan L
10/10/2023, 3:19 PMYeah it has the same problem that ehcanadian mentioned. Your file module is likely aliased as file. Then you are overwriting it by storing the loaded csv as var file
So as long as you updated your file variable that would work fine
n
NElliott
10/10/2023, 3:19 PMIt's an assumption and in the wrong hands yeah totally a risk
💯 1
v
vennila ramasamy
10/10/2023, 4:01 PMactually i was exporting the saved search to a csv file and saved in the file cabinet prior. now the customer wants to save it as a zip file. so now
1. export saved search to CSV
2. Load the CSV to remove the header
3. and convert into ZIP
4. and save it in file cabinet
Now my question is how to remove the header wthout saving the csv into the file cabinet because which is again saving into the file cabinet the customer dont want
a
Anthony OConnor
10/10/2023, 4:06 PMsave csv into the file cabinet anyway
remove the line as before
convert to zip
save zip to the file cabinet
delete the csv from the file cabinet
v
vennila ramasamy
10/11/2023, 7:54 AMi get the iterator as {} empty.
vennila ramasamy
10/12/2023, 9:40 AMI need to load the CSV after saving the search results. but it shows empty when i am loading i mean the process is not completed when i load the CSV. what could i do?
e
ehcanadian
10/12/2023, 2:30 PMUse the addInboundDependency method.
9 Views