Convert ip

[LeHibou]

Hello,

I currently have this script :

awk 'BEGIN{OFS=",";} {print substr($4,2)}' my.log > log.txt

I simplified it since it would normally be :

awk 'BEGIN{OFS=",";} {print substr($4,2),$1,$6,$8}' my.log > log.txt

I would like to be able to convert an ip (the $4 field) 192.168.1.1 to its decimal counterpart.


So, i shoud do something around substr($4,2) since it it the column i am interested in.

Could someone tell me how to do so ?

Thanks,

 

[feherke]

Hi

I would like to be able to convert an ip (the $4 field) 192.168.1.1 to its decimal counterpart.

Write a function to do the conversion then use it ?

[COLOR=darkgoldenrod]function ip2dec[/color][teal]([/teal]ip[teal])[/teal]
[teal]{[/teal]
  [b]split[/b][teal]([/teal][navy]$1[/navy][teal],[/teal]n[teal],[/teal][fuchsia]/\./[/fuchsia][teal])[/teal]
  [navy]d[/navy][teal]=[/teal][purple]0[/purple]
  [b]for[/b] [teal]([/teal][navy]i[/navy][teal]=[/teal][purple]1[/purple][teal];[/teal]i[teal]<=[/teal][purple]4[/purple][teal];[/teal]i[teal]++)[/teal] d[teal]+=[/teal]n[teal][[/teal]i[teal]]*[/teal][purple]256[/purple][teal]**([/teal][purple]4[/purple]-i[teal])[/teal]
  [b]return[/b] d
[teal]}[/teal]

Note that the above function works well in [tt]gawk[/tt] but not in [tt]mawk[/tt].

Feherke.
feherke.github.io

 

[LeHibou]

Many thanks,

totally missed the -f option to put the function file to launch

You rock !

LeHibou

 

[feherke]

Hi

Oops, a bug. Intended to process the function's parameter, not the input field :

[b]split[/b][teal]([/teal][highlight]ip[/highlight][teal],[/teal]n[teal],[/teal][fuchsia]/\./[/fuchsia][teal])[/teal]

Feherke.
feherke.github.io

 

[LeHibou]

Yes ! I corrected this