Qlikview

[#1]

Hi All,

69.57.226.0 69.57.226.255
69.57.234.0 69.57.234.255
69.57.237.0 69.57.237.255
69.57.243.0 69.57.243.255
69.57.248.0 69.57.248.255
76.76.160.0 76.76.163.255
76.76.176.0 76.76.179.255
204.14.248.0 204.14.255.255
205.136.83.64 205.136.83.127
206.48.59.0 206.48.59.255
207.42.133.0 207.42.133.255
208.66.48.0 208.66.55.255
209.59.76.0 209.59.79.255
209.59.119.0 209.59.120.255
209.88.67.0 209.88.68.255
213.9.95.184 213.9.95.187

The above listed data is my ip addresses which i will be getting from my client.. My problem is few IP adresses are coming in the beside the other IP adresse... I dont want this i want them to diaplay in a single column... Awaiting for the reply.... Thanks in advance...

[prieper]

Think that SUBFIELD() may solve your problem. Have attached a sample-file.

HTH
Peter