10-22-2007
Cutting Columns and Moving in to a file
Guys,
Can any one tell me how can we cut the columns and move each column in to a separate file using awk?
I have a tab delimited file as shown below,
1213 wattt werree
2345 skhasdjh aasas
I want to output this in to three files named a.txt,b.txt and c.txt
say a.txt contains
1213
2345
and b.txt contains
watt
skhasdjh
and so on..,
Thanks..,
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. Shell Programming and Scripting
Dear Friends,
Here I have two queries.
1. Want to make folder named as last three characters of a file name (length of file name can vary file to file)
E.g File name is AAAACCCCBBBB.txt (12 Characters excluding file extension) then folder to be created is BBB
Irrespective of... (7 Replies)
Discussion started by: anushree.a
7 Replies
3. Shell Programming and Scripting
Hi Guys,
Can you help me with a sed or a csh script that will have an output from the input below. Cutting the columns starting from the end of the line and not from the start of the line?
Sample1 - The underscore character "_" is actually a space...i need to put it as underscore here coz... (2 Replies)
Discussion started by: elmer1503
2 Replies
4. Shell Programming and Scripting
Hi All
I have recently had to start using Unix for work and I have hit brick wall with this prob....
I have a file that goes a little something like this....
EUR;EUR;EUR:USD:USD;USD;;;EUR/USD;XAU/AUD;XAU/EUR;XAU/AUD,GBP/BOB,UAD/XAU;;;1.11;2.22;3.33;4.44;5.55;6.66;;;
is it possible to... (7 Replies)
Discussion started by: luckycharm
7 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
Dear Friends,
I want to take last 10 characters of a file name in a variable.
E.g.
file name is
123432311234567890.txt
then we want "1234567890" to be taken in an variable.
Request you to guide me to do the same
Thanks in anticipation
Anushree (7 Replies)
Discussion started by: anushree.a
7 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have a space delimited file like this:
AAA BBB CCC
DDD EEE FFF
GGG HHH III
And I would like to change it to the following (including the plus signs):
AAA
BBB
+
CCC
DDD
EEE
+
FFF
GGG
HHH (2 Replies)
Discussion started by: blakers
2 Replies
8. UNIX for Dummies Questions & Answers
Hypothetically, suppose that
file1
id v1 v2 v3 v4 v5 v6 v7..........v100
1 1 1 1 1 1 2 2 .....50
2 1 1 1 1 1 2 2 .....50
3 1 1 1 1 1 2 2 .....50
4 1 1 1 1 1 2 2 .....50
5 1 1 1 1 1 2 2 .....50
I want to write a loop such that I take the id# and the first 5 columns (v1-v5) into the... (3 Replies)
Discussion started by: johnkim0806
3 Replies
9. Shell Programming and Scripting
This is a mysql night mare that I cant seem to wrap my head around. Any shell based answers is appreciated as I dont know Perl and all I would do would be blindly copy & paste !
FILE CONTENTS -
1389685 INSERT INTO Opera_ShirtCatlog(col1,col2) VALUES (1,'TEST1'),(2,'TEST2');
1389675 INSERT... (10 Replies)
Discussion started by: ManoharMa
10 Replies
10. UNIX for Dummies Questions & Answers
I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily?
... (9 Replies)
Discussion started by: wbport
9 Replies
LEARN ABOUT MOJAVE
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD