Parsing a CSV file and deleting all rows on condition Post: 302528764

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting the emty rows in a file

I am getting some spaces between the two lines(rows) in file.i want delete that empty rows in the file example 1 abc xyz 2 def jkl like i am having lots of rows in a file i want to delete the spce between the two rows give any...

2. Shell Programming and Scripting

deleting rows & columns form a csv file

Hi , I want to delete some rows & columns from file. can someone please help me on this? Regards.

3. Shell Programming and Scripting

Deleting rows from csv file

Hello, I am supposed to process about 100 csv files. But these files have some extra lines at the bottom of the file. these extra lines start with a header for each column and then some values below. These lines are actually a summary of the actual data and not supposed to be processed. These...

4. Shell Programming and Scripting

Deleting specific rows in large files having rows greater than 100000

Hi Guys, I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language the text file contains data in a pipe delimited format sdfsdfs sdfsdfsd START_ROW sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf...

5. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a...

6. UNIX for Dummies Questions & Answers

Help with deleting specific rows from a text file

I know this is a complicated question but I will try to illustrate it with some data. I have a data file that looks like the following: 1341 NA06985 0 0 2 46.6432798439 1341 NA06991 NA06993 NA06985 2 48.8478948517 1341 NA06993 0 0 1 45.8022601455 1340 NA06994 0 0 1 48.780669145 1340...

7. UNIX for Dummies Questions & Answers

Deleting specific rows from a text file

How do I go about deleting specific rows from a text file (given row number)?

8. Shell Programming and Scripting

deleting rows under a certain condition

there are 20 variables and I would like to delete the rows if 13th-20th columns are all NA. Thank you! FID IID aspirpre statihos fibrahos ocholhos arbhos betabhos alphbhos cacbhos diurehos numbcig.x toast1 toast2 toast3 toast4 ischoth1 ischoth2 ischoth3 ischoth4 101 101 1 1 1 1 1 2 1 2...

9. Shell Programming and Scripting

Read column from file and delete rows with some condition..

Hi.... I have a need of script to do delete row whenever condition is true.... 2.16 (3) 1 3 9999 0 (1) (0) 34.42 (4) 1 3 9999 37 (2) (3) 34.38 (4) 1 3 9999 64 (2) (3) 34.4 (4) 1 3 1 ...

10. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and...

LEARN ABOUT CENTOS

aic

AIC(4)							 BSD/i386 Kernel Interfaces Manual						    AIC(4)

NAME

     aic -- Adaptec AIC-6260 and AIC-6360 SCSI driver

SYNOPSIS

     device aic

     In /boot/device.hints:
     hint.aic.0.at="isa"

DESCRIPTION

     The aic driver provides support for the Adaptec AIC-6260 and AIC-6360 SCSI controller chips.  Many systems that use these controller chips do
     not have a boot ROM and therefore cannot be booted from.

HARDWARE

     The adapters supported by the aic driver include:

     o	 Adaptec AHA-1505 (ISA)
     o	 Adaptec AHA-1510A, AHA-1510B (ISA)
     o	 Adaptec AHA-1520A, AHA-1520B (ISA)
     o	 Adaptec AHA-1522A, AHA-1522B (ISA)
     o	 Adaptec AHA-1535 (ISA)
     o	 Creative Labs SoundBlaster SCSI host adapter (ISA)
     o	 Adaptec AHA-1460, AHA-1460B, AHA-1460C, AHA-1460D (PC Card)
     o	 Adaptec AHA-1030B, AHA-1030P (PC98)
     o	 NEC PC-9801-100 (PC98)

SEE ALSO

     aha(4), ahb(4), ahc(4), cd(4), ch(4), da(4), intro(4), sa(4)

BUGS

     The driver does not work well with multiple devices on the SCSI bus.  The driver works well with devices like CDROMs and Tape drives.  The
     driver works not so well with disk drives.  The PC Card version appears to work better than the ISA version, but that may be due to differing
     levels of testing of the devices.

BSD
								 November 8, 2003							       BSD