Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends, Need a quick help..
I have column like below,
IP Address
10.10.10.1
10.10.10.2
10.30.40.5
10.55.45.7
172.65.10.11
When I load this column I dont want IP addresses starting with 10.10. and I want IP addresses starts only with 10.. Any suggestions please?
Try this:
SQL SELECT *
FROM source
WHERE SomeField LIKE '10.*'
AND SomeField NOT LIKE '10.10.*'
;
Try this:
SQL SELECT *
FROM source
WHERE SomeField LIKE '10.*'
AND SomeField NOT LIKE '10.10.*'
;
Something like:
LOAD
IP
INLINE [
IP
10.10.10.1
10.10.10.2
10.30.40.5
10.55.45.7
172.65.10.11
]
Where not([IP] like '10.10*');
HI Vijay,
Kindly find below attached file.
IP_ADD:
LOAD
IP
INLINE [
IP
10.10.10.1
10.10.10.2
10.30.40.5
10.55.45.7
172.65.10.11
]
Where not([IP] like '10.10*');
Regards,
nagarjuna
IF(LEFT([IP Address], 5)<>'10.10', IF(LEFT([IP Address], 2)='10', [IP Address])) AS [IP Address]
Thanks everyone for your timely help.