11-30-2007
Thread
IT Resource Center forums - Remove columns in file asks almots an identical question.
Responses available with both perl and awk
# awk -F'\t' 'NR>1 {for(i=1;i<=20;++i) printf(i<20?"%s\t":"%s\n",$i)}' ofile
# perl -nle 'print if $.==1;@a=split;print join "\t", @a[0..19] file
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
My file looks like
abc$%sdfhs$%sdf$%sdfaf$%
here as seen delimiter is $%...now how cas i take out second field as cut command expect delimiter as single charecter only.....is there is any other way
thanks and regards
mahabunta (9 Replies)
Discussion started by: mahabunta
9 Replies
2. UNIX for Dummies Questions & Answers
Hi,
In the below line
a|b|10065353|tefe|rhraqs|135364|5347575
dgd|rg|4333|fhra|grhrt|46423|urdsgd
Here i want to cut the characters in between the second and third pipe delimiter and then between fifth and sixth delimiter and retain the rest of the line.
My output should be
... (3 Replies)
Discussion started by: ragavhere
3 Replies
3. Shell Programming and Scripting
Hi,
I need to append the data in to a file by using tab delimiter.
eg:
echo "Data1" >> filename.txt
echo "\t" >> filename.txt (its not working)
echo "Data2" >> filename.txt.
the result sould be like this.
Data1 Data2 (6 Replies)
Discussion started by: Sharmila_P
6 Replies
4. UNIX for Dummies Questions & Answers
Hello,
Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another.
Thanks,
G (4 Replies)
Discussion started by: Gussifinknottle
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am having a file with the delimiter '|^'.
File name:test_dlim.csv
I want to cut the first field of this using awk command.
I tried with the help of the following link:... (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
6. Shell Programming and Scripting
here are the few scenarios...
isoSizeKB text NOT NULL,
reserved1 varchar(255),
KEY `deviceId` (`deviceId`)
`d5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dHead` enum('HistoryInfo','Diversion') COLLATE utf8_unicode_ci,
`ePR` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
... (7 Replies)
Discussion started by: vivek d r
7 Replies
7. UNIX for Dummies Questions & Answers
How can i make a tab delimiter file to a comma delimiter??? (13 Replies)
Discussion started by: saggiboy10
13 Replies
8. Shell Programming and Scripting
Hi,
I have two files like:
file1
chr1 40
chr1 50
chr2 10
chr2 60
file2
chr1 30
chr1 50
chr2 15
chr2 20
and want to get the difference of column 2 when column 1 is the same in both files. (4 Replies)
Discussion started by: linseyr
4 Replies
9. Shell Programming and Scripting
Hi ,
I have a set of files in a folder which i need to cut in to two parts....
Sample files
touch AE_JUNFOR_2014_MTD_2013-05-30-03-30-02.TXT
touch AE_JUNFOR_2014_YTD_2013-05-30-03-30-02.TXT
touch temp_AE_JUNFOR_2014_MTD_2013-05-30-03-30-02.TXT
touch... (4 Replies)
Discussion started by: chillblue
4 Replies
10. Shell Programming and Scripting
Hi All,
I have a string with , delimiter
america,finland,netherlands
Now i want these values to be stored in file as below with newline character at end of each value
america
finland
netherlands
Regards
Prasad (3 Replies)
Discussion started by: krishna_gnv
3 Replies
CUT(1) BSD General Commands Manual CUT(1)
NAME
cut -- cut out selected portions of each line of a file
SYNOPSIS
cut -b list [-n] [file ...]
cut -c list [file ...]
cut -f list [-d delim] [-s] [file ...]
DESCRIPTION
The cut utility cuts out selected portions of each line (as specified by list) from each file and writes them to the standard output. If no
file arguments are specified, or a file argument is a single dash ('-'), cut reads from the standard input. The items specified by list can
be in terms of column position or in terms of fields delimited by a special character. Column numbering starts from 1.
The list option argument is a comma or whitespace separated set of numbers and/or number ranges. Number ranges consist of a number, a dash
('-'), and a second number and select the fields or columns from the first number to the second, inclusive. Numbers or number ranges may be
preceded by a dash, which selects all fields or columns from 1 to the last number. Numbers or number ranges may be followed by a dash, which
selects all fields or columns from the last number to the end of the line. Numbers and number ranges may be repeated, overlapping, and in
any order. If a field or column is specified multiple times, it will appear only once in the output. It is not an error to select fields or
columns not present in the input line.
The options are as follows:
-b list
The list specifies byte positions.
-c list
The list specifies character positions.
-d delim
Use delim as the field delimiter character instead of the tab character.
-f list
The list specifies fields, separated in the input by the field delimiter character (see the -d option.) Output fields are separated
by a single occurrence of the field delimiter character.
-n Do not split multi-byte characters. Characters will only be output if at least one byte is selected, and, after a prefix of zero or
more unselected bytes, the rest of the bytes that form the character are selected.
-s Suppress lines with no field delimiter characters. Unless specified, lines with no delimiters are passed through unmodified.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of cut as described in environ(7).
EXIT STATUS
The cut utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
Extract users' login names and shells from the system passwd(5) file as ``name:shell'' pairs:
cut -d : -f 1,7 /etc/passwd
Show the names and login times of the currently logged in users:
who | cut -c 1-16,26-38
SEE ALSO
colrm(1), paste(1)
STANDARDS
The cut utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').
HISTORY
A cut command appeared in AT&T System III UNIX.
BSD
December 21, 2006 BSD