Remove Header from CSV file

I have a flow that reads a file and sends it via email. I am wanting to remove the Header information from this file. What is the easiest way to accomplish that?

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

hrepxg

Set the starting position to read from line1

0911060553270289.pdf

unknown

I'd run it through a JavaScript Expression and split it by line. x=data.split("
") and for loop through the data and writing it back to a new variable.

x=data.split("
")

for (i=1;i<x.length;i++)

{

dataout+=x[i]+"
"

}

unknown

another option would be to use a javascript expression which may be easiest. syntax below is from memory but would go something like this:

NodeName_outputData = NodeName_outputData.substr(NodeName_outputData.indexOf('
')+1)

jreese

If you are using the data iterator node to read through the file by line, add a branch statement to the flow to check if the line number is one, if yes skip, if no then write the line to a new file.

0712131256598360.doc

unknown

As long as you are reading the file, you might as well rewrite it without the header as jreese suggests. Generally speaking, I use the pattern matching utility, grep, in a syscmd node to filter file records. Here is an example of a grep command that removes a header using the -v flag for inverse matching (causes grep to match everything *but* the phrase you specify).

input.txt

lname,fname,street

test,guy,123 test st

test,gal,456 test st

grep -v lname input.txt > output.txt

output.txt

test,guy,123 test st

test,gal,345 test st

If you are not familiar with grep, there is a nice tutorial of it here: www.computerhope.com/.../ugrep.htm

unknown

When reading in the csv file just skip over line 1 using a FileAccess node and then start your processing at line 2. The javascript solutions below read the whole file into memory first whereas it may be faster to just skip the first line when the processing starts. Then you can output the rest of the csv file without line 1 -- the header.

Copyright © 2025 Infor. All rights reserved.