Write 2nd and 3rd fields to a 4th file name?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Write 2nd and 3rd fields to a 4th file name?
# 1  
Old 11-19-2012
Write 2nd and 3rd fields to a 4th file name?

I have a flatfile A.txt
Code:
date|products|notes|location
121117|a108|this is a test|florida
121118|b111|just test it|tampa

How do i write an awk to create a file name as location.txt and have products:notes

Code:
awk -F'|' '{ print $2 ":" $3 }' A.txt > $4.txt

I am sure it cannot write to $4.txt; how do you do that?
Thanks.
# 2  
Old 11-19-2012
Code:
awk -F'|' '{ close(o);o=$4 ".txt";print $2,$3 >> o}' OFS=: A.txt

# 3  
Old 11-19-2012
Code:
awk -F'|' '{ fname=$4; print $2 ":" $3 > fname; close (fname)}'    A.txt

If you have duplicate $4 field values this will not work.
# 4  
Old 11-19-2012
Jim, How do i write output to /some/where/fname.txt?
vgersh99, how do i write it to folder /some/where/o.txt ?
I write to local. If i add path i got syntax erro.
Thanks
# 5  
Old 11-19-2012
Code:
# change this:
fname=$4;
#to
fname= "/path/to/some/where" $4;

the space is the concatenation operator in awk.
# 6  
Old 11-20-2012
Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to print the string between 3rd and 4th backslashs to end of line

im trying to get awk to print the string between 3rd and 4th backslashs to end of line test could be any word this http://example.com/test/ >to this http://example.com/test/ > testalso the other way round insert string at end of line... (13 Replies)
Discussion started by: bob123
13 Replies

2. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

3. Shell Programming and Scripting

To write shell script based on 1 and 4th columns

Hi, I am trying to write shell script for below requirement File has below values @mqm soft nproc 75000 @mqm hard nproc 75000 @mqm soft nofiles 76492 @mqm hard nofiles 76492 @mqm soft locks 76492 @mqm hard ... (7 Replies)
Discussion started by: darling
7 Replies

4. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

5. Shell Programming and Scripting

How to extract 3rd,4th and 5th element

Hi All! I trying to execute this perl script to extract a particular field in a text file, luckily it works. But, right now I would like to extract 3 more fields in the text file but couldnt get the right syntax on how to do it. command is: perl -pe '$_ = (split(//)) . "\n"' TestDoc.txt... (3 Replies)
Discussion started by: VicNetIT
3 Replies

6. Shell Programming and Scripting

1st column,2nd column on first line 3rd,4th on second line ect...

I need to take one column of data and put it into the following format: 1st line,2nd line 3rd line,4th line 5th line,6th line ... Thanks! (6 Replies)
Discussion started by: batcho
6 Replies

7. Shell Programming and Scripting

search 3 file and write to 4th file (a bit complex)

hi buddies; rollbackip.txt:10.14.3.65 2 10.14.3.65 3 ... lookup.txt: ... 10.14.3.65 2 10.14.5.55 1 55 10.14.6.66 1 66 10.14.3.65 3 10.14.7.77 3 77 10.14.8.88 2 88 10.14.9.99 4 99 ... ip-port.txt ... port111 3 10.14.5.55 57 port111 2 10.14.5.55 51 port111 1 10.14.5.55 59 ->... (7 Replies)
Discussion started by: gc_sw
7 Replies

8. Shell Programming and Scripting

Cut 2 fields and write to a output file

Hi, I am writing a code where the file is a pipe delimited and I would need to extract the 2nd part of field2 if it is "ATTN", "C/O" or "%" and check to see if field9 is populated or not. If field9 is already populated then leave it as is but if field9 is not populated then take the 2nd part of... (3 Replies)
Discussion started by: msalam65
3 Replies

9. Shell Programming and Scripting

How to extract 3rd line 4th column of a file

Hi, Shell script: I would need help on How to extract 3rd line 4th column of a file with single liner Thanks in advance. (4 Replies)
Discussion started by: krishnamurthig
4 Replies

10. Shell Programming and Scripting

printing 3rd or 4th feild from last in awk.

Whats up fellas... hope someone can help me with the following... I am parsing an file that is space delimited, however, in the middle, there is an ugly "Account Name" feild that in itself has multiple varying spaces, and commas which throws off my script. The 1st 3 feilds I am able to obtain... (8 Replies)
Discussion started by: djsal
8 Replies
Login or Register to Ask a Question