Search Results

Worked like charm. Can you pls explain the expression?

One more question. if I need the output of each file in one line without the tag "HDR" what do I need to do?
For example the output needs to be

1234 abc qwertyabc def ghi jkl

Can you please explain the logic. Where do you have the tag "HDR" as part of the delimiter?

Hello I have a file of following format

HDR 1234 abc qwerty
abc def ghi jkl

HDR 4567 xyz qwerty
abc def ghi jkl

HDR 890 mno qwerty
abc def ghi jkl

HDR 1234 abc qwerty
abc def ghi jkl...

Could you please explain what the script at 1 thru 4 is doing?

My string looks like this:
echo 20140403 07:26:26 IN:CTRL=[CIN=CIN3]:TYP=TYP2:DCN=DCN3:DATA=[xxxxx DCN3 xxxxxxxxx xxxx DCN3 xxx xxx xx xxxx xxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxx...

Hellow:
I have the following data.

id1 xxx xxx xxx id1 xxxx xxx xxx
id2 xxx xxx xxx id2 xxxx xxx xxx id2



In my awk script which reads the file containing the above data I have the...

vgres99; perfect
carona:No, it is a sample how my file looks like, it is way bigger than that, need a sample code so i can apply to it

I have a CSV file that needs to be loaded to a DB. It appears the copy utility expects fixed number of tokens per line so as to insert data into the corresponding database fileds. My input looks like...

Hmm. If I am in a EST with daylight savings observed, what needs to be changed to the above. I use this logic for a set of dates and 20140310 is just n example

---------- Post updated at 04:32 PM...

Hello:
I am bit puzzled with what I could be doing wrong and any help is appreciated.
I have a date in YYYMMDD format and I need to find the previous date. Based on the input on this forum, I have...

Hello:
I am trying to use grep in cygwin to do the following, however I am unable to get the output in the desired format. Please see and let me know how to solve this

Input log file
20140403...

Thanks Yoda , Don cragun
It worked

Good catch.. It was a typo on my part. Not much change from my requirements though.
The output need to contain CID4 and CID5, for brevity I left the off
It was a typo on "CID ID" and needs to be...

Hello:
Newbie with Awk. Trying to compare two files and merge data based on CID. Please see the input file format and desired output. Any help is appreciated.

TIA


Input File1

CID1 ---...

Thanks. One issue. I am not sure how to show. I did a wc-l on the generated file and I see ONE line extra than the original file. I do not see any characters but something non-printable is being...

Yes I would need the trailing comma. The idea is if I have ",," it needs to be replaced with ",0.0,"

I ran your script and it seems to work. let me try on my large file

The output needed is

2,3,1,0.0,0.0,4
1,2,3,0.0,0.0,0.0,0.0,5,
8,7,3,4,0.0,0.0,0.0,
However I am getting

2,3,1,0.0,0.0,4
1,2,3,0.0,0.0,0.0,0.0,5,0.0
8,7,3,4,0.0,0.0,0.0,0.0

while read line
do
echo $line|awk -F"," '{

for (i = 1; i <= NF; ++i) {
if ($i == "")
printf("0.0,")
else {

printf("%s,", $i)

}...

Having a huge file in the following format.
2,3,1,,,4
1,2,3,,,,,5,
8,7,3,4,,,,

Output needed is:
2,3,1,0.0,0.0,4
1,2,3,0.0,0.0,0.0,0.0,5,
8,7,3,4,0.0,0.0,0.0,

I have tried reading the...