Scripting job to complete

SunilB2011 · April 15, 2011, 8:23am

Hi Friends,

I don't have much experience in shell scripting & have a urgent scripting job to complete. Need your help to do the following.

I have a input file like below:

CDR #1
----------
Name James
Age 30
Country Japan
 
CDR #2
----------
Name Robin
Age 31
Country Germany
 
CDR #3
----------
Name George
Age 32
Country Australia

I want output like:

James|30|Japan
Robin|31|Germany
George|32|Australia

Thanks,
Sunil

pbillast · April 15, 2011, 8:35am

make a file test.awk containing

/Name/ { n=$2 }
/Age/ { a=$2 }
/Country/ { { c=$2;printf "%s|%s|%s\n",n,a,c}
}

awk -f test.awk yourfile
-> 
James|30|Japan
Robin|31|Germany
George|32|Australia

kevintse · April 15, 2011, 12:37pm

pbillast's solution won't work as expected when Name or Country contains more than one word, the following code does:

awk '/^(Name|Age|Country)/{ $1=""; sub(/^[ \t]+/, ""); if(++i%3){ORS="|"}else{ORS="\n"} print }' inputfile

SunilB2011 · April 16, 2011, 12:48am

Thanks for your replies. I will implemet the suggetsed solutions & revert to you guys as soon as possible.

Best Regards,
Sunil

palanisvr · April 17, 2011, 5:20am

#!/bin/ksh

for i in   `grep  -n "-" tempfile.dat |awk -F ':' '{print $1}'`
do
  echo  $i
  idx=`expr $i + 3`
  echo idx : $idx
  echo `sed -n  "$i","$idx"p tempfile.dat|awk  '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3}'` >>newfile.dat
done

matrixmadhan · April 17, 2011, 5:21am

Please use code tags, it only takes less than a second to wrap your code with CODE tags. Without them, reading the code is difficult.

SunilB2011 · April 18, 2011, 1:47am

Dear Friends,

Once again thank you all for the help. The input file is now changed by the customer. I am attaching the actual input file. Following is the snippet from the file.

File Header: Size :0 bytes:

CDR #1
----------
recordType EGSNPDPRECORD
servedIMSI 405150016945607
ggsnAddress 115.255.8.82
chargingID 626709187
sgsnAddress 220.224.141.18
 
CDR #2
----------
recordType EGSNPDPRECORD
servedIMSI 405210010858247
ggsnAddress 115.255.8.83
chargingID 626709171
sgsnAddress 220.224.141.85

There will be mulitiple CDR #n records in the file.

I need a script that will give me output of only the 2nd field for each CDR like below.

EGSNPDPRECORD|405150016945607|115.255.8.82|626709187|220.224.141.18......
EGSNPDPRECORD|405210010858247|115.255.8.83|626709171|220.224.141.85......

Each CDR should be in a separate line. The script should be able to count the total number of CDR# in the file & genearte CDR as mentioned above for all the CDR's.

Thanks,
Sunil

palanisvr · April 18, 2011, 2:00am

#!/bin/ksh
for i in    `grep  -n "CDR" cdr.txt |awk -F ':' '{print $1}'`
do
  i=`expr $i + 2`
  idx=`expr $i + 5`
  echo `sed -n  "$i","$idx"p cdr.txt|awk  '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 }'` >>newfile.dat
done

pbillast · April 18, 2011, 2:09am

you should be able to write at least part of this script by yourself by now, don't you think?

SunilB2011 · April 18, 2011, 2:45am

palanisvr:

#!/bin/ksh
for i in    `grep  -n "CDR" cdr.txt |awk -F ':' '{print $1}'`
do
  i=`expr $i + 2`
  idx=`expr $i + 5`
  echo `sed -n  "$i","$idx"p cdr.txt|awk  '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 }'` >>newfile.dat
done

Hi,

This is my script.

[root@FLPROVP01 cdr]# cat t.sh
#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "-" cdr_2.txt |awk -F ':' '{print $1}'`
do
     idx=`expr $i + 15`
     echo `sed -n "$i","$idx"p cdr_2.txt|awk '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14"|" $15}'` >>o.txt
done

3 things still needed in the script.

A] The script should ignore the lines:

listOfTrafficVolumes
qosNegotiated

B] One of the parameter in Filed 1 is Alloc./Retention priority. It contains a ./ & it should not affect script processing.

C] The script should be able to display the following type of values properly.

 
0x0C (12)
0x1 (Delay class 1)
etc.

i am atatching the actual input file cdr.txt again.

Thanks,
Sunil

palanisvr · April 18, 2011, 3:00am

Try with the updated one .

#!/bin/ksh
for i in    `grep  -n "CDR" cdr.txt |awk -F ':' '{print $1}'`
do
  i=`expr $i + 2`
  idx=`expr $i + 5`
  echo `sed -n  "$i","$idx"p cdr.txt|awk  '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 }'` >>newfile.dat
done

It should ignore the below and writes the fabricated data into newfile.dat file. delete the file before running this script else it would append to the same.

3 things still needed in the script.

A] The script should ignore the lines:

listOfTrafficVolumes
qosNegotiated

B] One of the parameter in Filed 1 is Alloc./Retention priority. It contains a ./ & it should not affect script processing.

C] The script should be able to display the following type of values properly.

0x0C (12)
0x1 (Delay class 1)
etc.

SunilB2011 · April 18, 2011, 3:48am

palanisvr:

Try with the updated one .
#!/bin/ksh
for i in    `grep  -n "CDR" cdr.txt |awk -F ':' '{print $1}'`
do
  i=`expr $i + 2`
  idx=`expr $i + 5`
  echo `sed -n  "$i","$idx"p cdr.txt|awk  '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 }'` >>newfile.dat
done
It should ignore the below and writes the fabricated data into newfile.dat file. delete the file before running this script else it would append to the same.

3 things still needed in the script.

A] The script should ignore the lines:

listOfTrafficVolumes
qosNegotiated

B] One of the parameter in Filed 1 is Alloc./Retention priority. It contains a ./ & it should not affect script processing.

C] The script should be able to display the following type of values properly.

0x0C (12)
0x1 (Delay class 1)
etc.

Hi,

The output is fine till 9 rows. After that the following rows are not processed properly.

Length 0x0C (12)
Alloc./Retention priority 0x01 (1)
Delay class 0x1 (Delay class 1)
Reliability class 0x3 (Unack. GTP/LLC, Ack. RLC, 
Protected data)
Peak throughput 0x04 (Up to 8000 oct/s)

Following is my script.

[root@FLPROVP01 cdr]# cat t.sh
#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
echo `sed -n "$i","$idx"p cdr_2.txt|awk '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14 "|" $15 "|" $16 "|" $17 "|" $18 "|" $19 "|" $20 "|" $21 "|" $22 "|" $23 "|" $24 "|" $25}'` >>o.txt
done

Thanks,
Sunil

palanisvr · April 18, 2011, 4:38am

I could find in the script that you are refering to incorrect file in the grep condition , I have changed it accordingly, try with this.

#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
echo `sed -n "$i","$idx"p cdr_2.txt|awk '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14 "|" $15 "|" $16 "|" $17 "|" $18 "|" $19 "|" $20 "|" $21 "|" $22 "|" $23 "|" $24 "|" $25}'` >>o.txt
done

SunilB2011 · April 18, 2011, 5:15am

palanisvr:

I could find in the script that you are refering to incorrect file in the grep condition , I have changed it accordingly, try with this.

#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
echo `sed -n "$i","$idx"p cdr_2.txt|awk '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14 "|" $15 "|" $16 "|" $17 "|" $18 "|" $19 "|" $20 "|" $21 "|" $22 "|" $23 "|" $24 "|" $25}'` >>o.txt
done

Thank you so much for helping me. Below is the output after modifying the script. This output is still missing many many fields.

EGSNPDPRECORD|405150016945607|115.255.8.82|626709187|220.224.141.18|rcomwap|IPV4|10.88.79.121|TRUE|0x0C|priority|class|class|throughput|class|throughput|class|order|of|SDU|bit|bit|BER|error|
EGSNPDPRECORD|405210010858247|115.255.8.82|626709171|220.224.141.85|rcomwap|IPV4|10.88.96.179|TRUE|0x0C|priority|class|class|throughput|class|throughput|class|order|of|SDU|bit|bit|BER|error|
EGSNPDPRECORD|405060031074049|115.255.8.82|626709196|115.255.8.81|rcommms|IPV4|10.94.34.193|TRUE|0x0C|priority|class|class|throughput|class|throughput|class|order|of|SDU|bit|bit|BER|error|
EGSNPDPRECORD|405060031074049|115.255.8.82|626707737|115.255.8.81|rcomwap|IPV4|10.88.97.57|TRUE|0x0C|priority|class|class|throughput|class|throughput|class|order|of|SDU|bit|bit|BER|error|

The output of the lenght field should be '0x0C (12)'. But it is coming only as 0x0C & after that the rest of the output is not as expected. The rest of the fields after that have output in similar format like '0x1 (Delay class 1)' , '0x3 (Unack. GTP/LLC, Ack. RLC, Protected data)' etc.

My current script is:

[root@FLPROVP01 cdr]# cat t_new.sh
#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
echo `sed -n "$i","$idx"p cdr_2.txt|awk '{print $2}'|tr "\n" " " |awk -F ' ' '{print $1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14 "|" $15 "|" $16 "|" $17 "|" $18 "|" $19 "|" $20 "|" $21 "|" $22 "|" $23 "|" $24 "|" $25}'` >>o.txt
done
[root@FLPROVP01 cdr]#

Thanks,
Sunil

sivarajb · April 18, 2011, 6:47am

HI,
Try this code:

cat cdr.txt | awk '{len=length($0);if(substr($0,1,3)=="CDR"){print $1}else{print substr($0,40,len)}}' | tr -s ' ' | sed -e 's/^ //g' | grep -v "^$" | awk '{if($0=="CDR"){printf "\n"}else{printf "%s|" ,$0}}'

It should work fine...!

---------- Post updated at 04:17 PM ---------- Previous update was at 04:14 PM ----------

Hi,
Try this.

cat cdr.txt | awk '{len=length($0);if(substr($0,1,3)=="CDR"){print $1}else{print substr($0,40,len)}}' | tr -s ' ' | sed -e 's/^ //g' | grep -v "^$" | awk '{if($0=="CDR"){printf "\n"}else{printf "%s|" ,$0}}'

To count CDR,

cat cdr | grep "CDR" | wc -l

The above one line awk code will fix all ur needs and It should work fine.

matrixmadhan · April 18, 2011, 8:25am

Am going to repeat this, please do use CODE tags. It makes reading the code a lot easier.

palanisvr · April 18, 2011, 8:34am

hope this should fix your issue , as there are lot of white space between the field values I have hard coded the columns to replace with null so change accordingly as per your request if you want to add new columns in the output list , output will be saved in Output.txt.

#!/bin/ksh

sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
sed -e 's/^[ \t]*//' cdr.txt -e '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`

a=`sed -n "$i","$idx"p cdr_2.txt|sed -e s/recordType// -e s/servedIMSI// -e  s/ggsnAddress// -e s/chargingID//  -e s/sgsnAddress//  -e s/accessPointNameNI// -e s/pdpType//  -e s/servedPDPAddress// -e  s/dynamicAddressFlag// -e s/listOfTrafficVolumes//  -e s/qosNegotiated// -e s/Length// -e s/"Alloc.\/Retention priority"// -e s/"Delay class"// -e s/"Reliability class"// -e  s/"Peak throughput"// -e s/"Precedence class"// -e s/"Mean throughput"// -e  s/"Traffic class"// -e  s/"Delivery order"//  -e s/"Delivery of erroneous SDU"// -e s/"Maximum SDU size"// -e s/"Max bit rate for uplink"// -e  s/"Max bit rate for downlink"//  -e s/"Residual BER"// -e s/"SDU error ratio"// |sed 's/^[ \t]*/\|/'|tr "\n" " "` 

if [ ! -z "$a" ]
then
len=`expr length "$a"`
a=`expr substr "$a"  2 $len`
echo $a >>Output.txt
fi

done

SunilB2011 · April 19, 2011, 2:00am

sivarajb:

HI,
Try this code:
cat cdr.txt | awk '{len=length($0);if(substr($0,1,3)=="CDR"){print $1}else{print substr($0,40,len)}}' | tr -s ' ' | sed -e 's/^ //g' | grep -v "^$" | awk '{if($0=="CDR"){printf "\n"}else{printf "%s|" ,$0}}'
It should work fine...!

---------- Post updated at 04:17 PM ---------- Previous update was at 04:14 PM ----------

Hi,
Try this.
cat cdr.txt | awk '{len=length($0);if(substr($0,1,3)=="CDR"){print $1}else{print substr($0,40,len)}}' | tr -s ' ' | sed -e 's/^ //g' | grep -v "^$" | awk '{if($0=="CDR"){printf "\n"}else{printf "%s|" ,$0}}'
To count CDR,

cat cdr | grep "CDR" | wc -l

The above one line awk code will fix all ur needs and It should work fine.

Hi,

This code worked perfectly for me.

Thanks a lot.

Following is the snippet of the output.

EGSNPDPRECORD|405150016945607|115.255.8.82|626709187|220.224.141.18|rcomwap|IPV4|10.88.79.121|TRUE|0x0C (12)|0x01 (1)|0x1 (Delay class 1)|0x3 (Unack. GTP/LLC, Ack. RLC, Protected data)|0x04 (Up to 8000 oct/s)|0x1 (High priority)|0x1F (Best effort)|0x3 (Interactive class)|0x2 (Without delivery order ('no'))|0x1 (No detect ('-'))|0x96 (1500 octets)|0x40 (64 kbps)|0x40 (64 kbps)|0x4 (1/250 = 4x10^-3)|0x4 (1/10 000 = 1x10^-4)|0x0A (100 ms)|0x1 (Priority level 1)|0x00 (Subscribed maximum bitrate)|0x00 (Subscribed maximum bitrate)|560|15045|Record Closure|110405121501+0530|110405121439+0530|22|Normal Release|GM2|259437517|MS or Network Provided and Subscription Verified|919022552905|Prepaid|SGSN Supplied|405, 15|3593360370770742|GERAN|+08:02|405, 15,15071,31851|10|2g.prepaid|2001|1|110405121443+0530|110405121458+0530|15|PDP context release|01 0b 41 1f 71 96 40 40 44 29 00 00|220.224.141.18|405, 15|560|15045|110405121501+0530|GERAN|

Best Regards,
Sunil

---------- Post updated at 11:30 AM ---------- Previous update was at 11:12 AM ----------

palanisvr:

hope this should fix your issue , as there are lot of white space between the field values I have hard coded the columns to replace with null so change accordingly as per your request if you want to add new columns in the output list , output will be saved in Output.txt.

#!/bin/ksh
 
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
sed -e 's/^[ \t]*//' cdr.txt -e '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
 
a=`sed -n "$i","$idx"p cdr_2.txt|sed -e s/recordType// -e s/servedIMSI// -e  s/ggsnAddress// -e s/chargingID//  -e s/sgsnAddress//  -e s/accessPointNameNI// -e s/pdpType//  -e s/servedPDPAddress// -e  s/dynamicAddressFlag// -e s/listOfTrafficVolumes//  -e s/qosNegotiated// -e s/Length// -e s/"Alloc.\/Retention priority"// -e s/"Delay class"// -e s/"Reliability class"// -e  s/"Peak throughput"// -e s/"Precedence class"// -e s/"Mean throughput"// -e  s/"Traffic class"// -e  s/"Delivery order"//  -e s/"Delivery of erroneous SDU"// -e s/"Maximum SDU size"// -e s/"Max bit rate for uplink"// -e  s/"Max bit rate for downlink"//  -e s/"Residual BER"// -e s/"SDU error ratio"// |sed 's/^[ \t]*/\|/'|tr "\n" " "` 
 
if [ ! -z "$a" ]
then
len=`expr length "$a"`
a=`expr substr "$a"  2 $len`
echo $a >>Output.txt
fi
 
done

Hi,

This code is also giving the output as desired. Only issue is that it is processing all CDR's twice i.e. My input file had 8 CDR's & the output file had the 8 CDR's followed by 8 CDR's again.

Following is my script.

[root@FLPROVP01 cdr]# cat cat cdr_script_2.sh
cat: cat: No such file or directory
#!/bin/ksh
sed 's/^[ \t]*//' cdr.txt > cdr_1.txt
sed '/^$/d' cdr_1.txt > cdr_2.txt
sed -e 's/^[ \t]*//' cdr.txt -e '/^$/d' cdr_1.txt > cdr_2.txt
for i in `grep -n "CDR" cdr_2.txt |awk -F ':' '{print $1}'`
do
i=`expr $i + 2`
idx=`expr $i + 25`
a=`sed -n "$i","$idx"p cdr_2.txt|sed -e s/recordType// -e s/servedIMSI// -e  s/ggsnAddress// -e s/chargingID//  -e s/sgsnAddress//  -e s/accessPointNameNI// -e s/pdpType//  -e s/servedPDPAddress// -e  s/dynamicAddressFlag// -e s/listOfTrafficVolumes//  -e s/qosNegotiated// -e s/Length// -e s/"Alloc.\/Retention priority"// -e s/"Delay class"// -e s/"Reliability class"// -e  s/"Peak throughput"// -e s/"Precedence class"// -e s/"Mean throughput"// -e  s/"Traffic class"// -e  s/"Delivery order"//  -e s/"Delivery of erroneous SDU"// -e s/"Maximum SDU size"// -e s/"Max bit rate for uplink"// -e  s/"Max bit rate for downlink"//  -e s/"Residual BER"// -e s/"SDU error ratio"// |sed 's/^[ \t]*/\|/'|tr "\n" " "`
if [ ! -z "$a" ]
then
len=`expr length "$a"`
a=`expr substr "$a"  2 $len`
echo $a >>Output.txt
fi
done
[root@FLPROVP01 cdr]#

Following is the Snippet of the Output.

EGSNPDPRECORD |405150016945607 |115.255.8.82 |626709187 |220.224.141.18 |rcomwap |IPV4 |10.88.79.121 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x40 (64 kbps) |0x40 (64 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405210010858247 |115.255.8.82 |626709171 |220.224.141.85 |rcomwap |IPV4 |10.88.96.179 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x09 (Up to 256000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x56 (240 kbps) |0xFE (8640 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626709196 |115.255.8.81 |rcommms |IPV4 |10.94.34.193 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626707737 |115.255.8.81 |rcomwap |IPV4 |10.88.97.57 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405150016945607 |115.255.8.82 |626709187 |220.224.141.18 |rcomwap |IPV4 |10.88.79.121 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x40 (64 kbps) |0x40 (64 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405210010858247 |115.255.8.82 |626709171 |220.224.141.85 |rcomwap |IPV4 |10.88.96.179 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x09 (Up to 256000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x56 (240 kbps) |0xFE (8640 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626709196 |115.255.8.81 |rcommms |IPV4 |10.94.34.193 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626707737 |115.255.8.81 |rcomwap |IPV4 |10.88.97.57 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405150016945607 |115.255.8.82 |626709187 |220.224.141.18 |rcomwap |IPV4 |10.88.79.121 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x40 (64 kbps) |0x40 (64 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405210010858247 |115.255.8.82 |626709171 |220.224.141.85 |rcomwap |IPV4 |10.88.96.179 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x09 (Up to 256000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x56 (240 kbps) |0xFE (8640 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626709196 |115.255.8.81 |rcommms |IPV4 |10.94.34.193 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626707737 |115.255.8.81 |rcomwap |IPV4 |10.88.97.57 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405150016945607 |115.255.8.82 |626709187 |220.224.141.18 |rcomwap |IPV4 |10.88.79.121 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x40 (64 kbps) |0x40 (64 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405210010858247 |115.255.8.82 |626709171 |220.224.141.85 |rcomwap |IPV4 |10.88.96.179 |TRUE | | |0x0C (12) |0x01 (1) |0x1 (Delay class 1) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x09 (Up to 256000 oct/s) |0x1 (High priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x1 (No detect ('-')) |0x96 (1500 octets) |0x56 (240 kbps) |0xFE (8640 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626709196 |115.255.8.81 |rcommms |IPV4 |10.94.34.193 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)
EGSNPDPRECORD |405060031074049 |115.255.8.82 |626707737 |115.255.8.81 |rcomwap |IPV4 |10.88.97.57 |TRUE | | |0x0C (12) |0x02 (2) |0x4 (Delay class 4 (best effort)) |0x3 (Unack. GTP/LLC, Ack. RLC, Protected data) |0x04 (Up to 8000 oct/s) |0x2 (Normal priority) |0x1F (Best effort) |0x3 (Interactive class) |0x2 (Without delivery order ('no')) |0x2 (Erroneous SDUs are delivered ('yes')) |0x96 (1500 octets) |0x58 (256 kbps) |0x58 (256 kbps) |0x4 (1/250 = 4x10^-3) |0x4 (1/10 000 = 1x10^-4)

Thanks a lot.

Best Regards,
Sunil

sivarajb · April 19, 2011, 3:18am

U r welcome

Thanks
SivarajB