07-10-2009
I used that cut command but i am getting an error
as shown below for the previous data
PDE 2001 10 29 202148.60 38.92 24.20 33 4.8
PDE 2001 10 29 203423.57 38.88 24.41 33 3.7
PDE 2001 10 30 022401.80 35.92 23.90 5
PDE 2001 10 30 061008.62 34.62 24.12 33 4.0
PDE 2001 10 30 075220.80 38.12 23.21 7
PDE 2001 10 30 101545.66 36.60 70.96 200
PDE 2001 10 30 111050.30 37.10 21.57 5
the last column contains some missing real values for example the 3rd ,5th & so on has the last column missing
i dont know why
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I've got a data file like the following format.
196004010000 196004020000 8192 24 ueaag 98.793 18.750 20 ---- - 36 23 9999 314.161773681641
196004020000 196004030000 8192 24 ueaag 98.793 18.750 20 ---- - 36 23 9999 314.71533203125
196004030000 196004040000 8192 24... (7 Replies)
Discussion started by: su_in99
7 Replies
2. UNIX for Dummies Questions & Answers
how do I delete the first 3 lines and the first column and the tab?
infile:
Colorspace 0
SA-Sample 1 in 32
FTab-Chars 10
Sequence-1 SINE1_7SL 282
Sequence-2 sapieTTns 289
Sequence-3 7SL_Hopns 289outfile:
SINE1_7SL 282
sapieTTns 289
7SL_Hopns 289Thanks (4 Replies)
Discussion started by: jdhahbi
4 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a data file that contains 61 columns. I want to delete all the columns except columns, 3,6 and 8. The columns are tab de-limited. How would I achieve this on the terminal?
Thanks (2 Replies)
Discussion started by: lost.identity
2 Replies
4. UNIX for Dummies Questions & Answers
Dear all,
I have one file (see below) with more then 100 columns and 2500 rows, and need only column which has GType in label with Alphabets, please help me to remove these columns with numbers.
input file is
n.201.GType n-201.Theta n-201.R n_1.GType n_1.Theta n_1.R... (6 Replies)
Discussion started by: AAWT
6 Replies
5. Shell Programming and Scripting
Hi,
I'd like to ask for some help with the following task, please:
there is a big file with a header (this is file.in):
NAME A_1.X A_1.Y A_1.Z B_1.X B_1.Y B_1.Z
name1 AB 0.11 0.12 BB 0.45 0.67
name2 BB 0.34 0.56 AA 0.89 0.68
what I need is to recognize a pattern in the header of this... (10 Replies)
Discussion started by: zajtat
10 Replies
6. UNIX for Dummies Questions & Answers
An extension from an earlier question. Now need a sed script to delete columns 7,15 and 16 from an example txt below..
Again, thanks in advance.
98M-01.WAV,98M,01,00:00:49,01:07:36:00,"MIX",,"BOOM-MKH50",,,,,,,,,,"",
98L-01.WAV,98L,01,00:00:51,01:01:45:00,"MIX",,"BOOM-MKH50",,,,,,,,,,"", (7 Replies)
Discussion started by: Vrc2250
7 Replies
7. Shell Programming and Scripting
How can I delete a column from a CSV file which has comma separated value with a string enclosed in double quotes and a comma in between? I have a file 44.csv with 4 lines including the header like the below format:
column1, column2, column3, column 4, column5, column6
12,455,"string with... (6 Replies)
Discussion started by: dhruuv369
6 Replies
8. Shell Programming and Scripting
Hi
How can I delete a columns from a CSV file which has comma separated value with a string enclosed in double quotes or square bracket and a comma in between?
I have a csv file with below format.
Template,Target Server,Target Component,Rule Group,Rule,Rule Reference Number,Rule... (7 Replies)
Discussion started by: Litu19
7 Replies
9. Shell Programming and Scripting
Hi all ,
I have a file having 12 columns tab delimited .
I need to read this file and remove the column 3 and column 4 and insert a word in column 3 as "AVIALABLE "
Is there a way to do this . I am trying like below
Thanks
DJ
cat $FILENAME|awk -F"\t" '{ print $1 "\t... (3 Replies)
Discussion started by: Hypesslearner
3 Replies
10. UNIX for Beginners Questions & Answers
Goodmorning,
I know how to cut a string and a column, and how to find a word.
I have a file with over 100 columns. All columns have a title in the first line. I have to delete all columns with the XXX title.
I can't use cut -f because the position of XXX columns change in each file, and in... (14 Replies)
Discussion started by: echo manolis
14 Replies
pbmtopsg3(29 June 2001) pbmtopsg3(29 June 2001)
NAME
pbmtopsg3 - convert PBM images to Postscript with G3 fax compression
SYNOPSIS
pbmtopsg3 [--title=title] [--dpi=dpi] [filespec]
DESCRIPTION
Converts the PBM images in the input PBM file to pages in a Postscript file encoded with G3 fax compression.
If you don't specify filespec, the input is from Standard Input.
Remember that you can create a multi-image PBM file simply by concatenating single-image PBM files, so if each page is in a different file,
you might do:
cat faxpage* | pbmtopsg3 >fax.ps
OPTIONS
-title The Postscript title value. Default is no title.
-dpi The resolution of the Postscript output. Default is 72 dpi.
SEE ALSO
pnmtops(1), pstopnm(1), gs(1), pstopnm(1), pbmtolps(1), pbmtoepsi(1), pbmtog3(1), g3topbm(1), pbm(5)
pbmtopsg3(29 June 2001)