Need Help

[paulwalker]

HI Community,

Load * inline [

ID, Stage

100, 'Abc,123, JDB'

101, '123,BBB,JHJ'

102, 'ABC123, BCA, DCA'

103, 'CDA,JUJ,123'

];

Here, I have one Stage field, in that if i have any where 123 i want to return data.

My output should be

ID, Stage

100,123

101, 123

103,123

Thanks in Advance....

[#2]

only(if(WildMatch(Stage, '123,*', '*,123', '*,123,*'), 123))

[Anonymous]

Hi Paul,

You can use this expression to get your desired output:

if(WildMatch(Stage, '*123*'), 123)

Hope it helps you!!

[ramoncova06]

if(WildMatch(Stage, '*123*'), 123)

[maxgro · Accepted solution]

Load * Where Stage='123';

Load ID, SubField(Stage, ',') as Stage

inline [

ID, Stage

100, 'Abc,123, JDB'

101, '123,BBB,JHJ'

102, 'ABC123, BCA, DCA'

103, 'CDA,JUJ,123'

];

[Anonymous]

Hi Paul,

You can achieve the result by Massimo Grossi Solution.

Thanks @Massimo Grossi

[MarcoWedel]

maybe also possible:

If(WildMatch(','&Stage&',', '*,123,*'), 123)

hope this helps

regards

Marco