Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to delete row in csv file on date range? Post 303016001 by RudiC on Wednesday 18th of April 2018 04:01:31 AM
Old 04-18-2018
Works perfectly for me. Where exactly is your problem?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Delete first row of csv file

I have a csv file, which is > 2 Gigs. I need to BCP that file to Sybase db , but I cant upload that b'caz first row of the file is failing. ( having some errors probably.) I can manually insert the first line into db & then I can upload the rest of the data in file, if i can delete the first row. ... (2 Replies)
Discussion started by: kedar.mehta
2 Replies

2. Shell Programming and Scripting

How to Delete Last Row from .csv file in perl

Hi , I've a perl script to convert .xls to .csv .After conversion I want to delete first 28 and the last row from .csv file.Is there any efficent way to achive this both together. I'm deleting first 28 rows by using folllowing my perl code: exec " tail -n+28 infile.csv > outfile.csv ... (7 Replies)
Discussion started by: ajaypatil_am
7 Replies

3. UNIX for Dummies Questions & Answers

How to delete a row in a file

hi team, i have a file txt1 , in that file there r 10 lines . my aim is to cut 2nd and 6th line of the file . what command we can use for this scenario. (8 Replies)
Discussion started by: natraj005
8 Replies

4. UNIX for Dummies Questions & Answers

Date range command (and delete)

Hello. Newbie here.... I basically have a directory with tens of thousands (literally) subdirectories and need to delete those that are older than 2008 (hundreds) with all their contents. I've looked through all the RM parameters and still can't quite figure out how to specify the data range... (7 Replies)
Discussion started by: pqmomba8
7 Replies

5. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

6. Shell Programming and Scripting

delete a row in csv file based on the date

Hi, I have a csv file with old data..i need to have only last 30 days from the current dateof data in the file.The fourth field in the file is a date field.i need to write a script to delete the old data by comparing the the fourth field with the (current date -30).I need to delete the rows in... (2 Replies)
Discussion started by: pals70423
2 Replies

7. Shell Programming and Scripting

Copying down first row in to all the below blank rows in a .csv file

Hi All, I have many of files(.csv) of the format given below. Date,Name,Location 04/02/2012,A,India ,B,China ,C,USA Like this I have 1000's of rows and many columns in all my files. I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the... (8 Replies)
Discussion started by: ks_reddy
8 Replies

8. Shell Programming and Scripting

Append data to new row in CSV file every day

Hi All I will run the same script every day in corn and output should go to same CSV file but in different row with dates on it. Below is my example in attached format. Script i am using to collect switch port online DATE=`date '+%d-%m-%y'` for f in `cat... (1 Reply)
Discussion started by: ranjancom2000
1 Replies

9. Shell Programming and Scripting

Bash - delete from csv all the row if the first column is length >

Hi guys, i have a csv file like: USERID;COG;DESCR;FIL;OFF user001;user;test1;001;A01 user002;user;test2;002;A02 user0003;user;test3;003;A03 user004;user;test4;004;A04 user0005;user;test5;005;A05 etc.. I need to read line for line and, if value of first column is > 7 char (in this example... (4 Replies)
Discussion started by: kamose
4 Replies

10. Shell Programming and Scripting

Row Count in .csv file

Hi, I have to find the count of rows starting with "E," in given a.csv file . Sample Data File. E,2333AED,A,MC3,25,31-MAY-18 E,2333AED,A,MC3,25,31-MAY-18 CYMC3 25AED 0000 E,2333CZK,A,MC3,25,31-MAY-18 CYMC3 25CZK 0000 E,2333EUR,A,MC3,25,31-MAY-18... (3 Replies)
Discussion started by: Prabhakar Y
3 Replies
mt(1)							      General Commands Manual							     mt(1)

Name
       mt - magnetic tape manipulating program

Syntax
       mt [-f tapename] command [count]

Description
       The command permits the operation of a magnetic tape drive.

Options
       The  -f	flag  option  uses  the specified tape device (next argument) in place of either that tape device defined by your TAPE environment
       variable (.login or .profile) or /dev/nrmt0h.

       Some operations may be performed multiple times by specifying count.  By default, performs the requested operation once.

       The command argument defines the operation to be performed.  Only as many characters as are required to uniquely identify a command need be
       specified.

       The following is a list of commands:

       bsf		   Backspace count files.

       bsr		   Backspace count records.

       cache		   Allows to use the cache buffer on a tape drive that has the cache buffer feature.

       clhrdsf		   Clear  hardware/software problem.  Works with tape drives which use the TMSCP tape controller interface This command is
			   restricted to root access only.

       clserex		   Clear serious exception.  Works with tape drives which use the TMSCP tape controller interface

       clsub		   Clear subsystem.  Works with tape drives which use the TMSCP tape controller interface This command	is  restricted	to
			   root access only.

       eof, weof	   Write count end-of-file marks at the current position on the tape.

       eotdis		   Disable  end-of-tape  detection.   When the end of tape is reached, the tape will run off the reel.	Only the superuser
			   can issue this command.  The command remains in effect for the device until end-of-tape detection is enabled  with  the
			   eoten command.

       eoten		   Enable  end-of-tape	detection.   When the end-of-tape markers are reached, the tape is halted on the reel, between the
			   two end-of-tape markers.  Only the superuser can issue this command.  The command remains  in  effect  for  the  device
			   until end-of-tape detection is disabled with the eotdis command.  This is the default mode after a system boot.

       fsf		   Forward-space count files.

       fsr		   Forward-space count records.

       nocache		   Disables the use of the cache buffer for any tape drive that has the cache buffer feature.

       offline, rewoffl    Rewind the tape and place the tape unit off-line.

       retension	   Retensions the tape.  Retension means moving the tape one complete pass between EOT and BOT.

       rewind		   Rewind the tape.

       status		   Print status information about the tape unit.

Examples
       This example shows how to rewind the tape
       mt -f /dev/rmt0l rewind
       This example shows how to backspace the tape nmt1h three files:
       mt -f /dev/nrmt1h bsf 3
       This example shows how to write two end-of-file marks at the current position on tape nmt6h:
       mt -f /dev/nrmt6h eof 2

Return Values
       In  shell  scripts, returns a 0 exit status when the operation(s) were successful, 1 if the command was unrecognized, and 2 if an operation
       failed.

Files
       /dev/rmt?h or /dev/rmt?l
		 Raw magnetic tape interface with rewind when closed

       /dev/nmt?h or /dev/nmt?l
		 Raw magnetic tape interface with no rewind when closed

See Also
       dd(1), tar(1), ioctl(2), mtio(4), tms(4), environ(7)

																	     mt(1)
All times are GMT -4. The time now is 03:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy