Set 2 letter words to uppercase in a data item?

Gary96

Member
Hi All,

I need to set a data item text to uppercase if the data item length is = 2
This data item could also be enclosed in brackets

Eg. data1 = (jp) OR jp
Expected result = JP
 

sahil_raina_91

Active Member
In a decision stage use expression - Len(Replace(Replace ([Data Item],"(",""),")","")) = 2.
Connect YES with calculation stage - Upper(Replace(Replace ([Data Item],"(",""),")",""))
 
Top