[justbow]

Hi,

I have log in here
There are any line that print
3GPP-IMSI : String Value = 528111500090773
Calling-Station-Id : String Value = 6738804956

Then I will parse log become ( only takes IMSI and MSISDN number )

3GPP-IMSI,Calling-Station-Id
528111500090773,6738804956
.
.
.
.
end

Can anybody help me?

I've try using awk and doesn't work

here my script

Quote

awk '
/\Dictionary\ /{f=1}
/\3GPP-IMSI\ /{imsi=$2}
f && /\Calling-Station-Id\ /{msisdn=$2}


f && /Accounting /{
s= imsi "," msisdn
print s
f=0
}' SBR_FE2_grep.log

[eggi]

Hey there,

I'm somewhat confused. Why does your awk statement begin with a pattern match for the word "Dictionary." Is something left out of the example?

Thanks,

Mike

[justbow]

i try this

Quote

awk '
/\Accounting\ Request/{print s;f=1}
f && /3GPP-IMSI /{print $8}
f && /Calling-Station-Id /{print $8}
{s=$8 " " $9}' SBR_FE2_grep.log

then result become

528111500111614
6738790448

528111500075211
6738863638

528111500068173
6738769831

528111410001944
6738718661

528111500058725
6738791509

528111500090773
6738804956

528111500072850
6738885717

528111400012622
6738980388


...

i wanna result become this
528111500111614,6738790448
528111500075211,6738863638
528111500068173,6738769831
528111410001944,6738718661
528111500058725,6738791509
528111500050141,6738899302
528111500072850,6738885717
528111400012622,6738980388
528111510008438,6738893884
528111500084284,6738999866
528111500077061,6738887170
528111500121956,6738970043
528111500121956,6738970043
528111500121956,6738970043


can u help me

[eggi]

Hey again,

I don't see "Accounting Request" in the original text you're trying to parse?

, Mike

[justbow]

hi Mike my log in here

[eggi]

Thanks, man,

Here's an easier way, since you've done all of the work already. It looks like you just don't want the two parts of the line to both have carriage returns, like

aaaa
bbbb

you want

aaaabbbb

You can do that by chaning the first

{print $8}

to

{printf("%s", $8)}

and perhaps (if that causes issues) change the second one to

{printf("%s\n", $8)}

Basically, all you need to do is clip the newline on the first "print $8" in each loop. This might be slightly more complex if there are hard returns in your file, but you can strip them from the first one pretty easily.

Best wishes,

Mike

[justbow]

Hi Mike

do u mean like this :

Quote

awk '
/\Accounting\ Request/{print s;f=1}
f && /3GPP-IMSI /{printf("%s\n", $8)}
f && /Calling-Station-Id /{printf("%s\n",$8)}
{s=$8}' SBR_FE2_grep.log

i've try but the result still can't print new line..
here is the result :

Quote

528111500111614
6738790448

528111500075211
6738863638

528111500068173
6738769831

528111410001944
6738718661

528111500058725
6738791509

528111500090773
6738804956

528111500072850
6738885717

528111400012622
6738980388

528111510008438
6738893884

528111500084284
6738999866

528111500077061
6738887170

528111500121956
6738970043

is there any way
may be the other script

[eggi]

Hey There,

Almost, but since you want the second variable to tag onto the end of the first before the newline, change this line:

Quote

f && /3GPP-IMSI /{printf("%s\n", $8)}

to

Quote

f && /3GPP-IMSI /{printf("%s", $8)}

removing the newline and the two parts should print together, since only your second printf statement has a newline.

Best wishes,

Mike

[justbow]

Hello Mike,

Hihi, maybe we just do a little bit trick,

Quote

awk '
/\Accounting\ Request/{print s;f=1}
f && /3GPP-IMSI /{printf("%s", $8)}
f && /Calling-Station-Id /{printf("%s", ","$8)}' SBR_FE2_grep.log

then the result become :

Quote

528111500111614,6738790448
528111500075211,6738863638
528111500068173,6738769831
528111410001944,6738718661
528111500058725,6738791509
528111500090773,6738804956
528111500072850,6738885717
528111400012622,6738980388
528111510008438,6738893884
528111500084284,6738999866
528111500077061,6738887170
528111500121956,6738970043

Thanks Mike..

[eggi]

Excellent

Glad to help and glad you got that all figured out

Best wishes,

Mike