Need help extracting data for report creation


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help extracting data for report creation
# 15  
Old 07-18-2014
it is
Code:
 SunOS

on
Code:
i86

egrep
Code:
-A -B

is not working Smilie

Code:
% uname -a
SunOS xxxx 5.10 Generic_147148-26 i86pc i386 i86pc

# 16  
Old 07-18-2014
Quote:
is not working Smilie
This still doesn't help. What is not working?

Again, I don't want to be rude, but imagine if you took your car to the garage and said "Something is wrong." At least the mechanic could explore it, test drive it and try to work out what you are getting at. I'm blind unless you explain and fully answer what is asked.

I have a potential answer, but I don't want to muddy the board going off on the wrong tack. My logic is:-
  • Use egrep on the file to get the two items
  • Use paste to glue the pairs of lines together
  • Use egrep again to extract just the records you want
  • Use cut to trim off the detail you don't need (i.e. the owner: .... bit)
All of this is one read operation with pipes in between. You could even tag it on to the command you use to extract the data directly from Autosys if you choose.

Does this seem like a suitable process? Would you care to try your hand first, after all we're all here to learn and that's best done by having a go.




Regards,
Robin
# 17  
Old 07-19-2014
Hi.

On my Solaris 10, there are additional GNU utilities in a separate directory:
Code:
/usr/sfw/bin/ggrep
OS, ker|rel, machine: SunOS, 5.10, i86pc
Distribution        : Solaris 10 10/08 s10x_u6wos_07b X86
ggrep grep (GNU grep) 2.5

which may help with lack of -A, -B options on the Sun version of grep.

Best wishes ... cheers, drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting data

I have a txt file of the following format >ab_ qwerty >rt_ hfjkil >Ty2 hglashglkasghkf; >P2 aklhfklflkkgfgkfl >ui_ vnllkdskkkffkfkkf >we32 vksksjksj;lslsf'sk's's .... ..... I want to split this big file based on the header (>) (5 Replies)
Discussion started by: Lucky Ali
5 Replies

2. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

3. Shell Programming and Scripting

Test data creation

Hi, I need to produce A LOT of test data for a testing environment I've been told to look after. Should have stayed at home this week As it is for testing and probable sending to vendors I can't use real data (customer details). My wish list to Sanata is to have a number of flat files that... (1 Reply)
Discussion started by: nhatch
1 Replies

4. Shell Programming and Scripting

data in file while creation

I want to add some starting information in a file while creation. like if I type vi test.sh then #!/bin/bash will be added automatically. Somebody suggest me how to do this ?? (1 Reply)
Discussion started by: lipun4u
1 Replies

5. Shell Programming and Scripting

Extraction of data from multiple text files, and creation of a chart

Hello dear friends, My problem as explained below seems really basic. Fact is that I'm totally new to programming, and have only a week to produce a script ( CShell or Perl ? ) to perform this action. While searching on the forums, I found a command that could help me, but I don't know... (2 Replies)
Discussion started by: ackheron
2 Replies

6. Shell Programming and Scripting

Help with Creation of Script to Input Separators in Data

Hi all, I have one problem that is preparing datas so I can run a script to extrat informations for my statistic reports. I receive some datas, that are informations mixed and I need to separate them to analyse. This is an exemple of datas:... (8 Replies)
Discussion started by: Alexis Duarte
8 Replies

7. Shell Programming and Scripting

Awk Help for extracting report from logs

Hi I have a log file, with lines of following kind. ------------------------ 2009-05-15 07:49:42,574 INFO - SqlMapObjectDataDao - select - selectObject - 2 ms 2009-05-15 07:49:42,575 INFO - SqlMapUserDao - select - getUserSystemAdminSuperGroup - 0 ms 2009-05-15 07:49:42,576 INFO -... (3 Replies)
Discussion started by: jitendriya.dash
3 Replies

8. Shell Programming and Scripting

Creation of script,if the data file have more than one entry!!!

1.Daily there will be 14 files in the data directory 2.someday's the 14 files receive more than once r twice with different time stamps....we need to chk the count of the file and if the count of the file is two.we need to combine the both the files. 3. if any duplicate data is there just... (1 Reply)
Discussion started by: bobprabhu
1 Replies

9. UNIX for Dummies Questions & Answers

How to get a data creation file

Hi, I've two machine A and B. On the machine B there's a script that get with an ftp command a file on the A machine. I want that creation data file on the machine B is the creation data file on the machine A. Example: File text.txt on machine A created on 01/01/2006 11:00. The script on the... (2 Replies)
Discussion started by: superfabius
2 Replies

10. UNIX for Advanced & Expert Users

Get data creation file

Hi, I've two machine A and B. On the machine B there's a script that get with an ftp command a file on the A machine. I want that creation data file on the machine B is the creation data file on the machine A. Example: File text.txt on machine A created on 01/01/2006 11:00. The script on the... (1 Reply)
Discussion started by: superfabius
1 Replies
Login or Register to Ask a Question