fgrep to file plus some


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting fgrep to file plus some
# 1  
Old 02-25-2009
fgrep to file plus some

Hi,
I know that I can grep desired data to a file but is there a way to add an additional field of data to the output in addition to what is found. I want to add a login id to the data that is found in the grep. Is this even possible? Thanks for your help.
Toni
# 2  
Old 02-25-2009
You can either:
1. use 'sed' to do the searching and modify a found record/line adding whatever you want.
2. use 'awk' to do the same as above
3. pipe the output to 'sed' to modify found records and save to file afterwords.

Posting a sample file and desired output could help as well.
# 3  
Old 02-25-2009
fgrep"${getdate}"${PROCESSOR${LOGINID}/Sum_SCR_Records.${YEAR}.log
> ${results} 2>/dev/null
The above outputs multiple entries for the date desired (same client can have mulitple entries). There are 3 logs for each client. The idea is to consolidate and recap to a report.
The problem is there is no identification to the client so I would like to add the login id.
Thanks.
# 4  
Old 02-25-2009
Sorry, sample below

Log: entries grep by date
Date, Batch, Number of Items, Amount

Result - need to add client

Client, Batch, Number of Items, Amount
# 5  
Old 02-25-2009
Quote:
Originally Posted by ski
fgrep"${getdate}"${PROCESSOR${LOGINID}/Sum_SCR_Records.${YEAR}.log
> ${results} 2>/dev/null
The above outputs multiple entries for the date desired (same client can have mulitple entries). There are 3 logs for each client. The idea is to consolidate and recap to a report.
The problem is there is no identification to the client so I would like to add the login id.
Thanks.
You have mis-balanced '{}' combos: I guess the '${PROCESSOR' is missing a trailing '}': '${PROCESSOR}'

How do you derive the client id?
# 6  
Old 02-25-2009
Quote:
Originally Posted by ski
Sorry, sample below

Log: entries grep by date
Date, Batch, Number of Items, Amount

Result - need to add client

Client, Batch, Number of Items, Amount
How do you derive 'Client' value?
What happened with the 'Date' column?

Please post a sample data file and a desired output using BB Codes.
# 7  
Old 02-25-2009
Sorry about that - must have happened in my cut and paste of the code.
I know the grep works though. I have all the data consolidated one file (in the script). I am reading (exec) the client directory and searching for the logs for each client.
I did skip the date in the result. - sorry at work and trying to do too many things.
But the end result is the entire record from the log file plus one field (loginid)

thx
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Fgrep literal string from a file

have a file1 aaa-bbb-ccc-abcd aaa-bbb-ccc-bacd aaa-bbb-ccc-aaad aaa-bbb-ccc-ahave another file2 aaa-bbb-ccc-a fileusing the fgrep command, trying to have only the literal string returned. fgrep -f file2 file1 is returning aaa-bbb-ccc-abcd aaa-bbb-ccc-aaad aaa-bbb-ccc-aOnly looking for... (1 Reply)
Discussion started by: jimmyf
1 Replies

2. UNIX for Dummies Questions & Answers

Fgrep -v

Using the fgrep command with the -v option. I have two files: file1: dog 1 cat 3 bird 5 fish 7file2: dog catUsing fgrep -v file2 file1 According to the fgrep man page, the output should be bird5 fish 7 but I can't seem to get it to work. Any help would be appreciated. (2 Replies)
Discussion started by: jimmyf
2 Replies

3. Shell Programming and Scripting

Pipe and fgrep

Hi , Please help me resolve the below issue. I need to combine the below two command into one. grep 'ImanItemP' import.report| tr -s ' ' | cut -f2 -d ' ' > tmp.txt fgrep -v -f tmp.txt input.txt > reuired file.txt Thanks Ramesh (4 Replies)
Discussion started by: ramesh12621
4 Replies

4. Shell Programming and Scripting

Problem in Using fgrep Command with pattern file option

Hi, i am using fgrep command with following syntax fgrep -v -f pattern_file_name file file contains few line and have the pattern which i am giving in pattern file. My Problem is : its is not giving any output. while i am using fgrep -f pattern_file_name file it is showing all... (4 Replies)
Discussion started by: emresearch
4 Replies

5. Shell Programming and Scripting

Awk Vs Fgrep

Hi All, I have 2 files new.txt and old.txt cat new.txt sku1|v1|v2|v3 sku2|v11|v22|v33 sku3|v11|v22|v33 cat old.txt sku1|vx1|vx2|vx3 sku2|vx11|vx22|vx33 sku3|v11|v22|v33 The key column in both files are first column itself. I want to get records in... (6 Replies)
Discussion started by: morbid_angel
6 Replies

6. Shell Programming and Scripting

fgrep command

How can we use fgrep command to search pattern on perticular field on a file. eg : I have a parren file having format cat patternfile SPA16S199982 SPA5S26330 I want to seach these pattern on FIRST field of File2(since other field has same data) and that too maching entirely. ... (10 Replies)
Discussion started by: morbid_angel
10 Replies

7. UNIX for Dummies Questions & Answers

FGREP question

Hi, I need fgrep to search all files in the subdirectories in /var/spool/postfix/defer/... How can I issue such a command? (3 Replies)
Discussion started by: mojoman
3 Replies

8. Shell Programming and Scripting

fgrep fails...!?

Hi all, I need to transport a number of files from one server to other. I like to ensure the integrity using file checksum values. The action plan is, 1. create the list of checksum values for all the files using cksum command in source server. 2. Transfer all the files including the file... (5 Replies)
Discussion started by: r_sethu
5 Replies

9. UNIX for Advanced & Expert Users

fgrep

Hi Guys, Can anyone explain why I'm getting error below? when I execute in other server there is no error, what could be the reason. $ fgrep -f timecell.txt ldap_prev.dat wordlist too large $ wc -l timecell.txt ldap_prev.dat 372461 timecell.txt 3722878 ldap_prev.dat Thanks in... (2 Replies)
Discussion started by: krishna
2 Replies

10. UNIX for Dummies Questions & Answers

I need help with fgrep or grep

How can I do an and condition with fgrep. I want to do: ps -ef | fgrep -f searchvalues > tempmail.file mailx -s "Email Subject" email@domain.com < tempmail.file The search values file contains: opt/bea.*java.*80 mysqld What I want is to find things that contain: mysqld OR... (7 Replies)
Discussion started by: jimmy
7 Replies
Login or Register to Ask a Question