Hi, I want to show External Ids in a saved search,...
# suiteanalyticss
Seer
03/17/2021, 4:13 PMHi, I want to show External Ids in a saved search, but I want to show blank if the External Id starts with 'CUS-' or if it contains 'CUS-'
Any ideas please?
w
Watz
03/17/2021, 4:32 PMTry decode(substr({externalid},1,4),'CUS-',null,{externalid})
✅ 1
s
Seer
03/17/2021, 5:17 PM@Watz Many thanks for this!