Reading each item from a formatted file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Reading each item from a formatted file
# 1  
Old 04-07-2010
Reading each item from a formatted file

Hi,
I have a file generated like this -

1. Fire SQL and store the formatted output in a temp file

echo "select path, empid, age from emp_tbl" | /usr/sql emp_db 2 > count_file | grep vol > tempFile

2. The tempFile looks like this after the above statement

/vol/emp1 0732 25
/vol/emp2 0745 26


My requirement is to read each "column" of this temp file ? How can I do that ? Smilie

Thx a lot in advance. Kindly help.
# 2  
Old 04-07-2010
Use cut like this:

Code:
cut -d ' ' -f 2 tempFile

produces:

Code:
0732
0745

# 3  
Old 04-07-2010
Quote:
Originally Posted by hergp
Use cut like this:

Code:
cut -d ' ' -f 2 tempFile

produces:

Code:
0732
0745

Hi,
I am a totally newbie to Solaris. So, can you tell me how do use this inside a script. I ran this from the shell directly, but it does not work.
# 4  
Old 04-07-2010
Something like this:
Code:
while read column1 column2 column3
do
 # do something with $column1
 # do something with $column2
 # do something with $column3
 .
 .
done <  tempFile

# 5  
Old 04-07-2010
Try this :

Code:
awk '{print $2}' tempFile


Last edited by Franklin52; 04-07-2010 at 07:20 AM.. Reason: Please use code tags.
# 6  
Old 04-07-2010
Quote:
Originally Posted by Jairaj
Try this :

Code:
awk '{print $2}' tempFile

Hi Jai,
That was great. It worked. Smilie Can you explain this commaned too Smilie ?
# 7  
Old 04-07-2010
$2 - Indicates print the second field of tempFile. Space is default delimiter.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to process a list of items and uncomment lines with that item in a second file

Hello, I have a src code file where I need to uncomment many lines. The lines I need to uncomment look like, C CALL l_r(DESNAME,DESOUT, 'Gmax', ESH(10), NO_APP, JJ) The comment is the "C" in the first column. This needs to be deleted so that there are 6 spaces preceding "CALL".... (7 Replies)
Discussion started by: LMHmedchem
7 Replies

2. Shell Programming and Scripting

Processing a formatted file with awk

Hi - I want to interrogate information about my poker hands, sessions are all recorded in a text file in a particular format. Each hand starts with the string <PokerStars> followed by a unique hand reference and other data like date/time. There is then all the information about each hand. My first... (5 Replies)
Discussion started by: rbeech23
5 Replies

3. UNIX for Beginners Questions & Answers

Zabbix item for last line of a log file

Dear all,Zabbix version : 2.4 (yes, I know, upgrading soon - honest) Server OS version : CentOS 6, 64-bit (CentOS 7 with the Zabbix upgrade)I've got a large log file that I would like to read by an external process. It's basically the same as reading the item value on a web-page. I have... (5 Replies)
Discussion started by: rbatte1
5 Replies

4. Shell Programming and Scripting

Read a lis, find items in a file from the list, change each item

Hello, I have some tab delimited text data, file: final_temp1 aname val NAME;r'(1,) 3.28584 r'(2,)<tab> NAME;r'(3,) 6.13003 NAME;r'(4,) 4.18037 r'(5,)<tab> You can see that the data is incomplete in some cases. There is a trailing tab after the first column for each incomplete row. I... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

5. Shell Programming and Scripting

awk operation to get table formatted file

I need to parse .conf file in Unix system to get output from the snippets like below : ; generated by mod_identity exten => int,1,GoSub(mdc_template-3,s,1) exten => int,n(next_380),Return() ; default action for busy exten => ext,1,GoSub(mdc_template-3,s,1) exten => ext,n,Set(PRI_CAUSE=17)... (2 Replies)
Discussion started by: cheecky
2 Replies

6. Shell Programming and Scripting

Mail a formatted csv file

I have the below script i am getting the csv in garbled format.Please suggest the changes. SUNOS ####################################################################### ####MAIN SCRIPT ####################################################################### today=`date "+%m-%d-%Y ... (3 Replies)
Discussion started by: rafa_fed2
3 Replies

7. Shell Programming and Scripting

Extract information from Log file formatted

Good evening! Trying to make a shell script to parse log file and show only required information. log file has 44 fields and alot of lines, each columns separated by ":". log file is like: first_1:3:4:5:6:1:3:4:5:something:notinterested second_2:3:4:3:4:2 first_1:3:4:6:6:7:8 I am interested... (3 Replies)
Discussion started by: dummie55
3 Replies

8. Shell Programming and Scripting

Print new item in file with symbol

Dear all, I have encountered some problem here. I prompt the user for input and store it into a data file, eg. key in name and marks so the data file will look like this andrew 80 ben 75 and the next input is carine 90. So the problem here is i want to print... (2 Replies)
Discussion started by: branred
2 Replies

9. Shell Programming and Scripting

Searching for file and stopping at first item found

Hello, I try to write a shell script that would list all files on a directory and stop when it finds the first item specified on a find or ls command. How can I tell to the find or ls command to stop when it finds the first ".doc" file for example ? Thank you (7 Replies)
Discussion started by: davchris
7 Replies

10. Shell Programming and Scripting

Printing Formatted Records From A File

Hi All, I'm writing a script that provides a menu to manipulate records. I'm having a problem, however. The first option I'm writing is simply to display all of the records in a supplied file. The supplied file ('records') currently contains sample data, this data is: ... (3 Replies)
Discussion started by: Silentwolf
3 Replies
Login or Register to Ask a Question