Substring function

[#1]

Hi,

How can obtain two fileds : Addr. ipv4 and Addr. Ipv6 with substring function: 253.109.102.236/FA80::61B7:A707:80B:4411

Addr. IPv4 : 253.109.102.236

Addr. IPv6 : FA80::61B7:A707:80B:4411

Thanks for your help.

[m_woolf]

Somthing like this:

left(FIELD,index(FIELD,'/')-1) as IPv4,

mid(FIELD,index(FIELD,'/')+1) as IPv6,

[hic]

subfield(Address,'/',1) as ipv4

subfield(Address,'/',2) as ipv6

HIC

[#4]

Thanks, mwoolf & Henric.