# Omitting a line from a CSV during Parse

**URL:** <https://www.ruby-forum.com/t/omitting-a-line-from-a-csv-during-parse/126275>\
**Category:** Rails\
**Created:** [January 16, 2008, 10:38pm UTC](https://www.ruby-forum.com/t/omitting-a-line-from-a-csv-during-parse/126275 "2008-01-16T22:38:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [January 16, 2008, 10:38pm UTC](https://www.ruby-forum.com/t/omitting-a-line-from-a-csv-during-parse/126275/1 "2008-01-16T22:38:02Z")

</div>

Hello everyone,  
I am very new to Ruby on Rails, and I am working on a project that  
involves uploading a CSV and putting it in the database. It works great,  
but I need to omit the first line of the CSV. My code looks likes this:

require ‘csv’

class ImportController \< ApplicationController

def import

```
 currenttime = DateTime.now
 @parsed_file=CSV::Reader.parse(params[:dump][:file])
 n=0
 @parsed_file.each do |row|
 c=Import.new

```

c.prov\_info\_fac=row[0]  
c.prov\_info\_bac=row[4]  
c.prov\_info\_datatype=row[2]

c.prov\_service\_name=row[1]  
c.prov\_service\_number=row[3]  
c.prov\_service\_provider=row[5]

c.prov\_charges\_tot\_access=row[7]  
c.prov\_charges\_tot\_airtime=row[8]  
c.prov\_charges\_tot\_kb=row[9]  
c.prov\_charges\_tot\_messaging=row[10]  
c.prov\_charges\_tot\_features=row[13]  
c.prov\_charges\_tot\_equipment=row[26]  
c.prov\_charges\_tot\_longdistance=row[27]  
c.prov\_charges\_tot\_roaming=row[31]  
c.prov\_charges\_tot\_misc=row[39]  
c.prov\_charges\_tot\_other=row[42]  
c.prov\_charges\_tot\_taxesfees=row[43]

c.prov\_charges\_messaging\_sms=row[11]  
c.prov\_charges\_messaging\_mms=row[12]  
c.prov\_charges\_feat\_basicvoice=row[14]  
c.prov\_charges\_feat\_voicemail=row[15]  
c.prov\_charges\_feat\_wos=row[16]  
c.prov\_charges\_feat\_aod=row[17]  
c.prov\_charges\_feat\_intnl=row[18]  
c.prov\_charges\_feat\_mou=row[19]  
c.prov\_charges\_feat\_data=row[20]  
c.prov\_charges\_feat\_vidshare=row[21]  
c.prov\_charges\_feat\_wifi=row[22]  
c.prov\_charges\_feat\_messaging=row[23]  
c.prov\_charges\_feat\_otherfees=row[24]  
c.prov\_charges\_feat\_otherfeat=row[25]  
c.prov\_charges\_ld\_local=row[28]  
c.prov\_charges\_ld\_intnl=row[29]  
c.prov\_charges\_ld\_directory=row[30]  
c.prov\_charges\_roam\_airtime=row[32]  
c.prov\_charges\_roam\_kb=row[33]  
c.prov\_charges\_roam\_surcharges=row[34]  
c.prov\_charges\_roam\_ld=row[35]  
c.prov\_charges\_roam\_intnl=row[36]  
c.prov\_charges\_roam\_intnl\_ld=row[37]  
c.prov\_charges\_roam\_taxes=row[38]  
c.prov\_charges\_misc\_voice=row[40]  
c.prov\_charges\_misc\_data=row[41]  
c.prov\_updated\_date=currenttime

```
 if c.save
    n=n+1
    GC.start if n%50==0
 end
 flash.now[:message] = 'CSV Import Successful'

```

end

def delete  
Import.destroy  
redirect\_to :action =\> ‘index’  
end

end

Thanks for you help!!

- Jeff

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [January 17, 2008, 4:09am UTC](https://www.ruby-forum.com/t/omitting-a-line-from-a-csv-during-parse/126275/2 "2008-01-17T04:09:51Z")

</div>

Jeff,

Try the following - where you currently have this:

@parsed\_file.each do |row|

…

end

Do this:

@parsed\_file.each\_with\_index do |row, row\_index|

next if (row\_index == 0)  
…

end

On Jan 16, 1:38 pm, Jeff M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [January 18, 2008, 7:29pm UTC](https://www.ruby-forum.com/t/omitting-a-line-from-a-csv-during-parse/126275/3 "2008-01-18T19:29:00Z")

</div>

Thank you, sir! I ended up using @parsed\_file.shift, which worked great.