[Solved] awk output into a file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers [Solved] awk output into a file
# 1  
Old 05-22-2012
[Solved] awk output into a file

Hello board members.. here i am and here is my question.
OS HP-UX
awk
i have a file where the FS is the pipe (|).
So i choose the second field and i would like to do the following:
If this filed is 0 then, i need the line in file1.txt
Else write the line in file2.txt

Code:
cat testfile.txt | awk 'BEGIN{FS="|"}{
mark=$2;
if (mark == 0){
 print;
}
}'>>file1.txt

I tried "print >>file1.txt;" but i get a syntax error...
I would like (if possible) to create the two files, with one if-else statement.
Any ideas?

Thnx

---------- Post updated at 01:50 PM ---------- Previous update was at 01:19 PM ----------

Sorry i just realised that i had to put the filename into "" Smilie.. So after this my question is resolved.

Have a nice day Smilie

Last edited by radoulov; 05-22-2012 at 09:55 AM.. Reason: Marked as solved.
# 2  
Old 05-22-2012
That's a useless use of cat, incidentally. awk is fully capable of reading a file all by itself.
This User Gave Thanks to Corona688 For This Post:
# 3  
Old 05-23-2012
Hi corona688,

thanks a lot for the advice and the link. I will change it you are right! Smilie
 
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 reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

2. UNIX for Dummies Questions & Answers

awk - Rename output file, after processing, same as input file

I have one input file ABC.txt and one output DEF.txt. After the ABC is processed and created output, I want to rename ABC.txt to ABC.orig and DEF to ABC.txt. Currently when I am doing this, it does not process the input file as it cannot read and write to the same file. How can I achieve this? ... (12 Replies)
Discussion started by: High-T
12 Replies

3. UNIX for Dummies Questions & Answers

[Solved] How to Redirect Output To Log File?

I have the below script, but when i execute it is still printing to screen is there a way i can stop this and just print everything to the log file. Thank you. #!/bin/bash exec > >(tee "/var/log/ScriptLogs/called_from_incrontab.log") 2>&1 DIR="$1" FILE="$2" echo "STEP 1: Datafile... (5 Replies)
Discussion started by: Ariean
5 Replies

4. Shell Programming and Scripting

[SOLVED] Why awk script will not output to file?

I have a script that looks like this: for f in LISTDETAIL; do gawk -f script_0113b "$LISTDETAIL";done It works perfectly, and I can see input on the screen. I have tried to redirect it to a file with the following techniques, but no luck: for f in LISTDETAIL; do gawk -f script_0113b... (2 Replies)
Discussion started by: newbie2010
2 Replies

5. Shell Programming and Scripting

[Solved] awk compare two different columns of two files and print all from both file

Hi, I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this File1 1 rs1 abc 3 rs4 xyz 1 rs3 stu File2 1 kkk rs1 AA 10 1 aaa rs2 DD 20 1 ccc ... (2 Replies)
Discussion started by: justinjj
2 Replies

6. Shell Programming and Scripting

[Solved] awk command to read sequentially from a file until last record

Hello, I have a file that looks like this: Generated geometry (...some special descriptor) 1 0.56784 1.45783 -0.87965 8 1.29873 -0.8767 1.098789 ... ... ... ... Generated geometry (....come special descriptor) ... .... ... ... ... ... ... ... and... (4 Replies)
Discussion started by: jaldo0805
4 Replies

7. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

Hi All, I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file. Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies

8. Shell Programming and Scripting

[Solved] Split file using awk

hlow all, need your advice i have sample.txt 1252468812,yahoo,3.5 1252468812,hotmail,2.4 1252468819,yahoo,1.2 1252468812,msn,8.9 1252468923,gmail,12 1232468819,live,3.4 1252368929,yahoo,9.0 1252468929,msn,1.2now i want filtering with awk so output will like this 12524_log.txt... (2 Replies)
Discussion started by: zvtral
2 Replies

9. Shell Programming and Scripting

[solved] merging two files and writing to another file- solved

i have two files as file1: 1 2 3 file2: a b c and the output should be: file3: 1~a 2~b 3~c (1 Reply)
Discussion started by: mlpathir
1 Replies

10. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of... (6 Replies)
Discussion started by: dagigg
6 Replies
Login or Register to Ask a Question