Visit Our UNIX and Linux User Community


Cutting Columns and Moving in to a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cutting Columns and Moving in to a file
# 1  
Old 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..,
# 2  
Old 10-22-2007
I'm no Awk guru but wouldn't something like the following work:
Code:
awk -F\t '{ print $1 }' ~/Desktop/datafile.txt > ~/Desktop/a.txt

awk -F\t '{ print $2 }' ~/Desktop/datafile.txt > ~/Desktop/b.txt

awk -F\t '{ print $3 }' ~/Desktop/datafile.txt > ~/Desktop/c.txt

# 3  
Old 10-22-2007
Code:
BEGIN {
   filesN=split("a.txt b.txt c.txt", filesA, " ")
}
{
   for(i=1; i <= filesN; i++) {
      print $i > filesA[i]
      close(filesA[i])
   }
}

# 4  
Old 10-22-2007
1) how to print columns : see 7.5.1
2) directing output to file: see 10.5

Last edited by vgersh99; 10-22-2007 at 09:00 AM.. Reason: fixed 1st URL

Previous Thread | Next Thread
Test Your Knowledge in Computers #912
Difficulty: Medium
A null pointer in C always contains the value "".
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Cutting specific columns from lines

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

2. Shell Programming and Scripting

Moving columns around

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

3. UNIX for Dummies Questions & Answers

cutting multiple columns into multiple files

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

4. UNIX for Dummies Questions & Answers

moving columns to alternating rows

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

5. Shell Programming and Scripting

Cutting file name from end

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

6. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter (|^)

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

7. Shell Programming and Scripting

Cutting a file with multiple delimiters into columns

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

8. Shell Programming and Scripting

Cutting columns starting at the end of each line...

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

9. Shell Programming and Scripting

Cutting last few characters of file name

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

10. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter

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

Featured Tech Videos