Bash - delete from csv all the row if the first column is length >
Hi guys,
i have a csv file like:
etc..
I need to read line for line and, if value of first column is > 7 char (in this example are user0003 and user0005), i need to delete row (in the same file) and print on log file this deleted rows.
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)
Hi All,
I am having following file and I want to delete 1 row last column.
Current File Content:
================
procedure test421 put_line
procedure test321 test421
procedure test521 test321
procedure test621 test521
Expected File Content:
===========================
procedure... (3 Replies)
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)
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)
Hello,
am I new to awk, and I am tryint to:
INPUT FILE:
"73423555","73423556","73423557","73423558","73423559"
OUTPUT FILE:
73423555
73423556
73423557
73423558
73423559
My useless code so far:
#!/bin/awk -F ','
BEGIN
{
i=0;
} (8 Replies)
Hi,
I want to delete rows that have 0 at column 4.
The file looks like this:
chr01 13 61 2
chr01 65 153 0
chr01 157 309 1
chr01 313 309 0
chr01 317 469 1
chr01 473 557 0
I want to delete all rows with a 0 at column 4
chr01 13 61 2
chr01 157 309 1
chr01 ... (3 Replies)
Hi,
My input file is this way
1.1 0.0 2.4 3.5
7.9 1.8 22.3 4.7 8.9
0.9 1.3 0.0 3.4 5.6
0.0 1.1 2.2 0.0 0.0
1.1 0.0 0.0 3.4 5.6
I would like to delete the entire row, if either of 2nd and 3rd columns are 0.0.
Please note that my values are all decimal values.
So, my output would... (4 Replies)
Hi, I have a long file in the format below. I want to delete the consecutive lines that contain the same value in column 1.
I have tried awk '!x++' FS="," filename
This has not worked.
14,MM709_BHP_DM,BHP,BHP_MC709_DM
19,OFFLINE,CHE,CHEV_MC773_DM
20,M33,BP,BP_MIM775_NS_DM ... (2 Replies)
I want to delete row in csv file , which row value from 2009-10-01 to 2011-06-03 using script.my csv row data look like:
2009-10-01
2011-03-30
2011-03-31
2011-04-01
2011-06-03
2011-06-30
2011-07-01
2011-09-28 ... (7 Replies)
Discussion started by: rakibul639
7 Replies
LEARN ABOUT DEBIAN
music123
music123(1) General Commands Manual music123(1)NAME
music123 - plays various sound files (usually including MP3, Ogg and Wav).
SYNOPSIS
music123 [ -hqrvz ] file ...
DESCRIPTION
music123 is a shell around various command line programs to play music files. It will descend directories trees with -r, and randomize
file lists with -z. The programs used and the options given them are listed in /etc/music123rc or ~/.music123rc.
OPTIONS -h Show command help and exit;
-q Quiet mode. No messages are displayed.
-r Recurse into directories, instead of ignoring them.
-v Display version information and exit.
-z Play files in random order.
-Z Play the files randomly and endlessly.
-l Loop. -z -l differs from -Z in that -z -l will randomize, play through the song list (without repetition) in random order once, and
repeat the songs in that order over and over; -Z will randomly play the songs, without any order, and will possibly play a song
right after itself.
-i Ignore extension case.
-L List files and exit.
-T Start a task that handle commands, only one command supported : quit, using q or Q will quit the application at the end of the cur-
rent song.
-D Set music123 not to delay between songs. (May make music123 harder to kill).
-d Customize the time music123 delays between songs. -d takes one argument, expressed in seconds, which may have a fractional part.
-@ Play the files listed in the mandatory argument of -@. Other files can be added on the command line, and this option can be given
several times. Note that music123 doesn't yet play URLs.
-- End option list.
EXAMPLES
Play three songs:
music123 test1.ogg test2.mp3 test3.wav
Play a couple of directories and other songs at random:
music123 -z -r Rock/ test1.ogg Pop/ test4.wav
FILES
/etc/music123rc
Describes which programs music123 uses, which files types it supports, and which options it passes those programs.
~/.music123rc
Per-user config file to override the system wide settings.
AUTHORS
Authors:
David Starner <dvdeug@debian.org>
July 24, 2002 music123(1)