how to find special characters

[sanjujeeboy]

Hi 

I have a field called list, My requirement is if a field value consists of '_' then return that value else Null. how to acheive this. Ex for the below dimension, NA and canvas should return null and the other two as it is.

List

17_us_en_5f2879

Canvas

18_at_de_545456

NA

Thanks

[tresesco · Accepted solution]

Load  If(Index(List, '_'), List, 'NA') as NewList