Script

[smilingjohn]

Hi All

I have a field called Team, within the field name i have many contentes and among which i have to select those which has Iperformance ,

Please find the attachment .. can some one tell me how do i write in the script to get those Team which has iperformance in it .

and Iperformance

Regards ,

[MarcoWedel]

another solution might be:

-(Team like '*iperformance*') as iPerf

hope this helps

regards

Marco

[vinieme12]

Hi,

Wildmatch returns a number if it finds the search string it will return 1 else 0,   so we don't need to encapsulate it in an if() statement.... try it first

[vinieme12]

Hi,

Wildmatch returns a number if it finds the search string it will return 1 else 0,   so we don't need to encapsulate it in an if() statement.... try it first

LOAD *,wildmatch(Team,'*iperf*') as iPer_flag INLINE [

Id,Team

1,324e iperformance Test Drive

82,328e Iperformance

99,330e Iperformance

100,330e Sedan Iperformance

180,530e Iperformance

181,530e Xdrive Iperformance

182,530e Xdrive iperformance

183,530e Xdrive

];

[MarcoWedel]

comparison of the different proposed solutions:

LOAD Team,
     WildMatch(Team,'*iperformance*') as iPer_flag,
     If(SubStringCount(Lower(Team),'iperformance')>0,1,0) as IsValueAvailable,
     -(Team like '*iperformance*') as iPerf      
INLINE [
    Team
    324e iperformance Test Drive
    328e Iperformance
    330e Iperformance
    330e Sedan Iperformance
    530e Iperformance
    530e Xdrive Iperformance
    530e Xdrive iperformance
    530e Xdrive
];

hope this helps

regards

Marco