wildcard search

[Anonymous]

CountryCode	Coutnry1
US01	US
Uk01	UK
Ind03	West Ind
Ind02	East Ind
Ind01	India
Ind04	India North

Hi, I need the countrycodes of India only in a chart.

Don't hard card the values

I need the suggestions from you guys and kindly share the sample app.

[Anonymous]

Hi Anbu

I cant do like this as I cant load the values in the source file this is the false game.

I need an expression or loop to solve my requirement

[anbu1984]

Like this

Load CountryCode,Coutnry1,Upper(PurgeChar(CountryCode,'0123456789')) As Country Inline [

CountryCode,Coutnry1

Ind01,India

Ind02,East Ind

Ind03,West Ind

Ind04,India North

UAE1,UAE

UK01,UK

Uk02,UKWest

UK03,MidUK

US01,US

US02,East US ];