Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

awk: issues for writing a script

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers awk: issues for writing a script
# 1  
Old 03-23-2012
awk: issues for writing a script
%%%%%
Last edited by lucasvs; 05-01-2012 at 06:18 AM..
# 2  
Old 03-23-2012
Try this awk script...
Code:
awk -F\| '{OFS="|";if(NR==1) print "Field1|Field2|Location|Info";else{split($2,a," ");$4=a[1];print}}' file

Last edited by shamrock; 03-23-2012 at 02:55 PM..
# 3  
Old 03-23-2012
Code:
awk -F\| 'BEGIN{print "Field1|Field2|Location|Info"}NR==1{next}{split($2,a," ");$4=a[1]}1' OFS='|' yourfile

# 4  
Old 03-23-2012
Code:
awk -F\| '{if(NR>1){$4=$2;sub(/[ \t].*/,x,$4)}else sub($3,"Location|Info")}1' OFS=\| infile

# 5  
Old 03-23-2012
Inspired by Scruti's good idea ...

Code:
awk -F\| '{split($2,a," ");$3=NR<2?"Location|Info":$3 OFS a[1]}1' OFS=\| infile

Smilie

Go go Scruti ! shot a shorter one ! Smilie
Last edited by ctsgnb; 03-23-2012 at 04:59 PM.. Reason: Changing NR==1 into NR<2 ... LOL
# 6  
Old 03-23-2012
Way to go. Switching to sed,
Code:
sed '1s/[^|]*$/Location|Info/;1!s/[^|]*\(|[^ \t]*\).*/&\1/' infile

-or-
Code:
sed '1s/[^|]*$/Location|Info/;1!s/\(|[^ \t]*\).*/&\1/' infile

Smilie

---------- Post updated at 22:28 ---------- Previous update was at 22:09 ----------

Inspired by cts, back to awk:
Code:
awk -F'[| ]' 'sub($NF"$",NR<2?"Location|Info":$NF"|"$2)' infile

Last edited by Scrutinizer; 03-23-2012 at 06:50 PM..
# 7  
Old 03-24-2012
Thanks guys !!!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with writing a awk/sed script

Hi, I thought I am getting pretty good with sed and awk, but now I dont have a way out of this question. I have a table 0.5 16 1.3 14 0.25 15 0.85 16 I want to make a column 3 which contains values that are (corresponding $2 value/sum of all $2). Please help me out here. Thanks. (6 Replies)
Discussion started by: jamie_123
6 Replies

2. Shell Programming and Scripting

Issues running an awk script

Hi, I have an awk script(test.awk) as below which I am trying to execute through the following command and I am getting error as follows. Request your valid inputs on where I am going wrong. Thanks. :/usr/chandra# awk -f test.awk input.txt syntax error The source line is 1. The error... (18 Replies)
Discussion started by: adept
18 Replies

3. Shell Programming and Scripting

AWK - Issues with script running at start of month.

I have a script that runs on an AIX 5.3.10.0. It runs perfectly on days that are double digit numbers, but from the 1st to the 9th of the month it runs but does not report anything. The command in the script is as follows: awk -v d=$(date '+%b%d') '/user:warn/ && /has shutdown/ && ($1$2 ==... (2 Replies)
Discussion started by: jimbojames
2 Replies

4. UNIX for Dummies Questions & Answers

Writing awk script to read csv files and split them

Hi Here is my script that calls my awk script #!/bin/bash set -x dir="/var/local/dsx/csv" testfile="$testfile" while getopts " f: " option do case $option in f ) testfile="$OPTARG";; esac; done ./scriptFile --testfile=$testfile >> $dir/$testfile.csv It calls my awk... (1 Reply)
Discussion started by: ladyAnne
1 Replies

5. Shell Programming and Scripting

Help in writing a find/replace script using awk

Hi All, I need to write a script that will go through 600+ files and perform find and replace. I was going to use sed but there is a level of complexity that is doing my head in. To explain: I have 600+ files that have a line in them that reads (for example) FILE=DCLCLHST... (4 Replies)
Discussion started by: Kocko
4 Replies

6. Shell Programming and Scripting

Help needed in writing awk script for xml source

Hi, i am not able to get an approach for converting xml file to flat file using awk programming. Can anyone help me out. The input xml is like this: <outer> <field1>one</field1> <field2>two</field2> <field3>three<Error Code=777 Description=12345/></field3> <field4>four</field4> </outer>... (2 Replies)
Discussion started by: naren_0101bits
2 Replies

7. Shell Programming and Scripting

plz help in writing awk script

hi buddies pls help in this matter i have file like this input file -------------------------- (PARTITION PARTITION_1 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_1 ,PARTITION PARTITION_2 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_2 ,PARTITION PARTITION_3 VALUES LESS THAN (101,... (3 Replies)
Discussion started by: LAKSHMI NARAYAN
3 Replies

8. Shell Programming and Scripting

help in writing awk script, plz urgent

I have a file like this I have to I have input file this , I want to give the out put in the below input file (NARAYANA 1 ENDING AT (100, 16383) ,NARAYANA 2 ENDING AT (100, 32766) ,NARAYANA 3 ENDING AT (100, 49149) ,NARAYANA 4 ENDING AT (100, 65535) ,NARAYANA 5... (8 Replies)
Discussion started by: LAKSHMI NARAYAN
8 Replies

9. Shell Programming and Scripting

hi help in writing awk script(urgently)

hi to all i have file like this file.txt this is naryana expect hyderabad is a cool place now climate VISAKHSAPATNAM became very cool #vizag is my birth place #hyderabad is a cool place #now climate of hyd became very cool #vizag is my birth place #hyderabad is a cool place ... (7 Replies)
Discussion started by: LAKSHMI NARAYAN
7 Replies

10. Shell Programming and Scripting

writing to a file using awk

using awk, we can read a specific column of a file. is it possible to write to a specific column of a file too? and how? (if possible) (7 Replies)
Discussion started by: gfhgfnhhn
7 Replies
Login or Register to Ask a Question