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
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
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
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
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
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
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
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
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
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
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)