Shell Programming and Scripting

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:

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:

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

what is your expected output?

--ahamed

My intention is to generate a csv file, just looking like this:

That's why the final echo command:

Code:

echo "$proceso;$longfila;$numfilas_IN;$horacomienzo;$horafin"

Now you are asking...it would be great to convert this to DOS line terminator

Would the following command do that?

Code:

sed 's/$'"/`echo \\\r`/"

For DOSing the file you can use this

Code:

unix2dos <filename>

--ahamed

Thanks a lot!

Any suggestion for the csv output?

Add -n and p to all your sed commands and try this for getting everything after HORA COMIENZO...

Code:

sed -n 's/.*HORA COMIENZO: \(.*\)/\1/p'

--ahamed

What are we doing with that? (lets try to get a lesson from your wisdom)

With this you said now I am solving problem 2 (if pattern not found, no value is shown) but still I am losing my times: