Search Results

Thanks Don, definitely does help. I'll have to take some time to digest this.

Hi Don,
I'm trying to figure out how your code works. If you wouldn't mind could you explain it for me please? I'd like to learn how it worked. Thanks.

Thanks everyone, Don's code above did the trick. I really appreciate it, this will help immensely and save me an enormous amount of time.

Thanks for making me go back to the original sample, I looked at a few of the more complex database statements and there were blank lines in some of the statement text= fields. Here's an example of...

Manually editing would be very time consuming so I'll attempt to explain using the example below. Running your initial function helped quite a bit and re-formated the majority of records. There were...

Some of the records are longer than 4K. There are no blank lines in the long record however there are some line feeds, which is what is breaking the record into different lines. I am able to manually...

I'll have to create a mock up of a sample of the records as I can't put up live data. Hopefully that will suffice. Thanks.

---------- Post updated at 01:58 PM ---------- Previous update was at...

:) Don, that definitely worked for all but a small portion of the log. That really helps. In a copy of the actual log, I ran the code you gave me and it did merge most lines.

I ran the od -bc...

Thanks RudiC. We are getting closer thanks to you all. The last command put everything on one line. The events should all begin with the timestamp field. So by using the example I provided there...

Thanks Don. I used the command line below. Right behind each semi-colon is a \r following by what looks like a space.

awk 'sub (/;$/, "")+1 && $1=$1' RS= infile
0000000 357 273 277 164 151 155...

Thanks for the quick response guys. I'm not seeing the same results as you are. The only line that I am seeing is the very last 'statement text' line.

statement text=SELECT table.field,...

Hi all, I'm relatively new to scripting, I can do pretty basic things. I have a daily log file that looks like:


timestamp=2017-06-28-01.01.35.080576;
event status=0;
userid=user1;
...