Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parsing file: struggling against sed command
Top Forums Shell Programming and Scripting Parsing file: struggling against sed command Post 302575628 by manolain on Tuesday 22nd of November 2011 08:36:06 AM
Old 11-22-2011
Parsing file: struggling against sed command
Hello fellows,

Sure you can help this poor guy that is struggling against sed command, being unable to tame it

I have a lot of files like this:

Quote:
$ cat S_CAP0010001_20111118_122041.log
JOB: S_CAP0010001
FICHERO ENTRADA: S1.PSPER.BCJ.CAP001.F0001
FICHERO SALIDA DATOS: A153895.DS.VYP.BCJ.CAP001.S0001.SMSSTD
FICHERO SALIDA NO MATCH PARES: A153895.DS.VYP.BCJ.CAP001.S0001.ERROR.SMSSTD
HORA COMIENZO: 2011-11-18 12:20:41
CABECERA: I2077CAP0010001 00000000000251220111117215811
PIE: 000000004008848
FILAS ENTRADA (contando carcasa, cabecera y pie): 4008850
FILAS FICHERO SALIDA (contando cabecera y pie): 4007593
FILAS FICHERO NO MATCHS: 1255
HORA FIN: 2011-11-18 12:27:33
STATUS: 2( Finalizado OK con warnings )
From this one, I need to obtain values highlighted in bold/red

To do so, I am executing this piece of code inside a loop:

Code:
ultfichlog=`ls -rt $rutalogs/$proceso* | tail -1`
  fichlog=`cat $ultfichlog`
  #obtenemos los valores que necesitamos
 numfilas_IN=`echo $fichlog | sed 's/.*FILAS ENTRADA (contando carcasa, cabecera y pie): \([^ ]*\).*/\1/' `
 horacomienzo=`echo $fichlog | sed 's/.*HORA COMIENZO: \([^ ]*\).*/\1/' `
 horafin=`echo $fichlog | sed 's/.*HORA FIN: \([^ ]*\).*/\1/' `
  echo "$proceso;$longfila;$numfilas_IN;$horacomienzo;$horafin"

And the response is being the following:

Quote:
S_CAP0010001;2500;4008850;2011-11-18;2011-11-18
S_CAP0010002;2500;1629608;2011-11-18;2011-11-18
S_CAP0010008;2500;8654037;2011-11-18;2011-11-18
S_GIE0010008;157;JOB: S_GIE0010008 FICHERO ENTRADA: S1.PSPER.BCJ.GIE001.F0008 FICHERO SALIDA DATOS: CPPGITB.DS.VAL.BCJ.GIE001.S0008.SMSSTD FICHERO SALIDA NO MATCH PARES: CPPGITB.DS.VAL.BCJ.GIE001.S0008.ERROR.SMSSTD HORA COMIENZO: 2011-11-10 12:40:14 CABECERA: I2077GIE0010008 00000000000016920111104134502 PIE: 000000000007316 HORA FIN: 2011-11-10 12:44:08 STATUS: 2( Finalizado OK con warnings );2011-11-10;2011-11-10
So I am facing two problems here:

1) I need to get everything after 'HORA COMIENZO: ', but I am getting only whatever it is between that and next space

2) When the file I am checking is missing some of the lines I am looking for, I am getting the whole file. Instead of that, I should get null value for that (in the last case of my example, there is no line starting with 'FILAS ENTRADA (contando carcasa, cabecera y pie):' . In such case, I should just show no value, empty space or something like that


Thank you very much guys for your help
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Struggling with a text file

Hi, I am struggling with the following... I try to grep out information of a text file I got with lynx, a text browser. The text file I get from lynx with dump is attached in the bottom. What I would like to get is another file containing the astro-ph/98324 (number) and title and list of... (13 Replies)
Discussion started by: pau
13 Replies

2. UNIX for Advanced & Expert Users

Help- Unix File Compare- Struggling

I had posted this earlier about 3 weeks ago and had recieved a response and I did sort both the files and the comm command is still not working. Can someone please assist me, I would really appreciate it. Below is what I am trying to do I need to compare File A with File B and create FILE C... (2 Replies)
Discussion started by: guiguy
2 Replies

3. UNIX for Advanced & Expert Users

Parsing xml file using Sed

Hi All, I have this(.xml) file as: <!-- define your instance here --> <instance name='ins_C2Londondev' user='' group='' fullname='B2%20-%20London%20(dev)' > <property> </property> </instance> I want output as: <!-- define your instance here --> <instance... (3 Replies)
Discussion started by: kapilkinha
3 Replies

4. Shell Programming and Scripting

Parsing a file (sed/awk?)

Hello people, newbie question. I'm trying to parse these type of file 1 "CAR " " C1 " " " 6 0 C1 2 "CAR " " O1A" " " 8 0 O1A 3 "CAR " " O1B" " " 8 -1 O1B 4 "CAR " " C2 " " " 6 0 C2 5 "CAR " " C3 " " " 6 ... (10 Replies)
Discussion started by: aristegui
10 Replies

5. Shell Programming and Scripting

awk/sed for parsing file

Hi All, I have a log file like this E Mon Oct 06 00:17:08 2008 xxx2 cm:10614 fm_pi2_svc_iptv_purchase.c:149 1:pin_deferred_act:10601:11:169:1223245028:16 pi2_op_svc_iptv_purchase error <location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1... (10 Replies)
Discussion started by: subin_bala
10 Replies

6. Shell Programming and Scripting

Struggling with arrays and delimited file

Hi, I am trying to use arrays in my script but can not seem to get it to work. I have a file called sections, this contains headers from a tripwire log file, separated by "@" but could be "," if easier The headers will be used to cut sections from the log file into another to be mailed. ... (5 Replies)
Discussion started by: pobman
5 Replies

7. Shell Programming and Scripting

Parsing complicated CSV file with sed

Yes, there is a great doc out there that discusses parsing csv files with sed, and this topic has been covered before but not enough to answer my question (unix.com forums). I'm trying to parse a CSV file that has optional quotes like the following: "Apple","Apples, are fun",3.60,4.4,"I... (3 Replies)
Discussion started by: analog999
3 Replies

8. UNIX for Advanced & Expert Users

Parsing through a file with awk/sed

I don't necessary have a problem, as I have a solution. It is just that there may be a better solution. GOAL: Part one: Parse data from a file using the "\" as a delimiter and extracting only the last delimiter. Part two: Parse same file and extract everything but the last delimited item. ... (8 Replies)
Discussion started by: OrangeYaGlad
8 Replies

9. Shell Programming and Scripting

Help in parsing xml file (sed/nawk)

I have a large xml file as shown below: <input> <blah> <blah> <atr="blah blah value = ""> <blah> <blah> </input> ..2nd chunk... ..3rd chunk... ...4th chunk... All lines between <input> and </input> is one 'order' and this 'order' is repeated... (14 Replies)
Discussion started by: shekhar2010us
14 Replies

10. Shell Programming and Scripting

Trouble with sed and ini file parsing

hi people, i'm having a hard time trying to extract a list of vars delimited by section inside a ini file ... let's consider this ini file : ; config file DESC = "channel synchro TGG01" DMM_VER = DMM23 PATH_FIFO = /users/tgg00/fifo QRT = BTS01.TGG.01.2 MODE_TRACE... (5 Replies)
Discussion started by: odium74
5 Replies

LEARN ABOUT SUSE

sane-pie

sane-pie(5)						   SANE Scanner Access Now Easy 					       sane-pie(5)

NAME

       sane-pie - SANE backend for PIE, Devcom and AdLib SCSI flatbed scanners

DESCRIPTION

       The  sane-pie  library implements a SANE (Scanner Access Now Easy) backend that provides access to PIE, Devcom and AdLib SCSI flatbed scan-
       ners.
       At present, the following scanners should work with this backend:

       Model:		       Status
       ----------------------  ------
       Devcom 9636PRO	       OK
       Devcom 9636S	       Untested
       Devcom 9630S	       Untested
       ScanAce 1236S	       Untested
       ScanAce 1230S	       Untested
       ScanAce II	       Untested
       ScanAce III	       OK
       ScanAce Plus	       Untested
       ScanAce II Plus	       Untested
       ScanAce III Plus        Untested
       ScanAce V	       Untested
       ScanAce ScanMedia       Untested
       ScanAce ScanMedia II    Untested
       ScanAce 630S	       Untested
       ScanAce 636S	       Untested
       JetScan 630	       OK
       JetScan 636PRO	       Untested

FILES

       /etc/sane.d/pie.conf
	      The backend configuration file

       /usr/lib64/sane/libsane-pie.a
	      The static library implementing this backend.

       /usr/lib64/sane/libsane-pie.so
	      The shared library implementing this backend (present on systems that support dynamic loading).

SEE ALSO

       sane(7)

CONTACT AND BUG-REPORTS
       Please send any information and bug-reports to:
       Simon Munton <simon@munton.demon.co.uk>

								    14 Jul 2008 						       sane-pie(5)
All times are GMT -4. The time now is 08:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy