read contents of a file using AWK


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting read contents of a file using AWK
# 1  
Old 02-27-2012
read contents of a file using AWK

Hi,

I am kind of new at awk programming, so any help would be great !

I am trying to read a date from a file into a variable and a count into another variable and display both these variables.

The file looks like the attached file...

I tried this but it doesn't work ...

Code:
 
FILE_DATE =`cat report.txt | awk '/TIME:/ {gsub(",","",$3); print $3}'`
echo "FILE DATE is: $FILE_DATE"

I need the output as:
02/03/2012
125

Any help would be greatly appreciated !

Thanks
rdr

Last edited by RDR; 02-27-2012 at 02:16 AM..
# 2  
Old 02-27-2012
Something like this..?
Code:
awk '/TIME/{d=$4}/--/{getline;print d "\n" $0}' inputfile

# 3  
Old 02-27-2012
Code:
awk '
/TIME:/ {print $4}
/^[1-9][0-9]*$/ {print $1}
' report.txt

# 4  
Old 02-27-2012
Code:
FILE_DATE=` awk '/TIME:/ {print $4}' report.txt
NO_OF_CHARS=`awk '/characters/ {getline; getline; print}' report.txt`

Alternatively, using sed:
Code:
FILE_DATE=`sed '/TIME:/ s/[^0-9]*\([0-9]\{2\}\/[0-9]\{2\}\/[0-9]\{4\}\).*/\1/; q' report.txt`
NO_OF_CHARS=`sed -n '/characters/{n;n;p}' report.txt`

# 5  
Old 02-27-2012
Thanks a lot guys ... These worked like charm ....

My file was a little different from the one I attached , so had to do little modification ... Here is what I used ...


Code:
 
FILE_DATE=`awk '/TIME:/ {print $7}' report.txt`
echo "FILE DATE is: $FILE_DATE"
NO_OF_CHARS=`awk '/--/ {getline;print d $1}' report.txt`
echo "NO OF CHARS: $NO_OF_CHARS"

Thanks a Lot !

Last edited by RDR; 02-27-2012 at 02:16 AM..
# 6  
Old 02-27-2012
@RDR,

use the code tag. (while you post the sample data and script )

https://www.unix.com/how-post-unix-li...code-tags.html
# 7  
Old 02-27-2012
Alternatively using shell:
Code:
rep=$(cat report.txt)
rep=${rep#*: }
fdate=${rep%% *}
count=${var2##*
}
echo "File date is $fdate , count is $count"

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

For loop inside awk to read and print contents of files

Hello, I have a set of files Xfile0001 - Xfile0021, and the content of this files (one at a time) needs to be printed between some line (lines start with word "Generated") that I am extracting from another file called file7.txt and all the output goes into output.txt. First I tried creating a for... (5 Replies)
Discussion started by: jaldo0805
5 Replies

2. Shell Programming and Scripting

Replace partial contents of file with contents read from other file

Hi, I am facing issue while reading data from a file in UNIX. my requirement is to compare two files and for the text pattern matching in the 1st file, replace the contents in second file by the contents of first file from start to the end and write the contents to thrid file. i am able to... (2 Replies)
Discussion started by: seeki
2 Replies

3. Programming

read() contents from a file

Hi, I'm trying to implement a C program on ubuntu which reads the contents of a file that is passed in as an argument and then displays it to the screen. So far I've cobbled together this from bits online but most of it is probably wrong as its all copied and pasted... #include <stdio.h>... (2 Replies)
Discussion started by: cylus99
2 Replies

4. Shell Programming and Scripting

how to read contents of file?

I have made a script something like this. I want it to read the contents of either file or directory but 'cat' and 'ls' is not working. Can anyone help me? I am a newbie in scripting so dont know much about it. I also dont know how can i put my code separatly on this forum #!/bin/bash echo... (9 Replies)
Discussion started by: nishrestha
9 Replies

5. Homework & Coursework Questions

How to read contents of a file into variable :(

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have to read the contents of each field of a file creating user accounts. The file will be of format : ... (6 Replies)
Discussion started by: dude_me5
6 Replies

6. Shell Programming and Scripting

How to read contents of a file into variable :(

My file is in this format : username : student information : default shell : student ID Eg : joeb:Joe Bennett:/bin/csh:1234 jerryd:Jerry Daniels:/bin/csh:2345 deaverm: Deaver Michelle:/bin/bash:4356 joseyg:Josey Guerra:/bin/bash:8767 michaelh:Michael Hall:/bin/ksh:1547 I have to... (1 Reply)
Discussion started by: dude_me5
1 Replies

7. Shell Programming and Scripting

Read contents from a file

Hi Friends, I am new to this forum. Just struck up with a logic. I have a csv file seperated by ":" (colons). This csv file contains hostname and groups as follows: HOSTNAME:VT Group SGSGCT2AVPX001:Team1 SGSGCT2AVPX003:Team2 SGSGCT2AVPX005:Team2 PHMNCTTAVPX001:Team3 I want to... (2 Replies)
Discussion started by: dbashyam
2 Replies

8. Shell Programming and Scripting

Read contents of the file and print

AT ---------- 0 Elapsed: 00:00:00.02 SO ---------- 0 Elapsed: 00:00:00.01 SE ---------- 0 Elapsed: 00:00:00.01 CR ---------- (4 Replies)
Discussion started by: sandy1028
4 Replies

9. Shell Programming and Scripting

how to read the contents of a file using PERL

Hi My requirement is to read the contents of a fixed length file and validate the same. But am not able to read the contents of the file and when i tried it to print i get <blank> as an output... I used the below satatements for printing the contents ... (3 Replies)
Discussion started by: meva
3 Replies

10. Shell Programming and Scripting

Read File and use contents to rename another

Hello guys, thank God that I found this forum. I hope that someone can help me because I don't have any idea on how to start it. I know that for some of you this is a very simple task but I'm not as advance on shell scripting like many people out there. I got this file with a permanent... (10 Replies)
Discussion started by: Shark Tek
10 Replies
Login or Register to Ask a Question