Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview

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...

1 Reply
prieper
Master II
Master II

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

HTH
Peter