Sponsored Content
Top Forums Shell Programming and Scripting Need help extracting data for report creation Post 302909709 by rbatte1 on Friday 18th of July 2014 11:38:18 AM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
CUT(1)								   User Commands							    CUT(1)

NAME
cut - remove sections from each line of files SYNOPSIS
cut OPTION... [FILE]... DESCRIPTION
Print selected parts of lines from each FILE to standard output. Mandatory arguments to long options are mandatory for short options too. -b, --bytes=LIST select only these bytes -c, --characters=LIST select only these characters -d, --delimiter=DELIM use DELIM instead of TAB for field delimiter -f, --fields=LIST select only these fields; also print any line that contains no delimiter character, unless the -s option is specified -n with -b: don't split multibyte characters --complement complement the set of selected bytes, characters or fields -s, --only-delimited do not print lines not containing delimiters --output-delimiter=STRING use STRING as the output delimiter the default is to use the input delimiter --help display this help and exit --version output version information and exit Use one, and only one of -b, -c or -f. Each LIST is made up of one range, or many ranges separated by commas. Selected input is written in the same order that it is read, and is written exactly once. Each range is one of: N N'th byte, character or field, counted from 1 N- from N'th byte, character or field, to end of line N-M from N'th to M'th (included) byte, character or field -M from first to M'th (included) byte, character or field With no FILE, or when FILE is -, read standard input. GNU coreutils online help: <http://www.gnu.org/software/coreutils/> Report cut translation bugs to <http://translationproject.org/team/> AUTHOR
Written by David M. Ihnat, David MacKenzie, and Jim Meyering. COPYRIGHT
Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. SEE ALSO
The full documentation for cut is maintained as a Texinfo manual. If the info and cut programs are properly installed at your site, the command info coreutils 'cut invocation' should give you access to the complete manual. GNU coreutils 8.22 June 2014 CUT(1)
All times are GMT -4. The time now is 10:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy