Need help in filtering a field

[Anonymous]

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?

[oknotsen · Accepted solution]

Try this:

SQL SELECT *

FROM source

WHERE SomeField LIKE '10.*'

AND SomeField NOT LIKE '10.10.*'

;

[fvelascog72]

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*');

[nagarjuna_kotha]

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

[Karthik3]

IF(LEFT([IP Address], 5)<>'10.10', IF(LEFT([IP Address], 2)='10', [IP Address])) AS [IP Address]

[Anonymous]

Thanks everyone for your timely help.