Hi, can anyone help me with a saved search Formula...
# general
h
Hi, can anyone help me with a saved search Formula? I'm looking to locate account numbers for accounting that are long strings and pull results based on location of numbers so example Account Number: 100*200300*105555 I want to pull results for accounts that have the string 200300. Help greatly appreciated!
r
case when {accountnumber} like '%200300%' then 0 else 1 end. Filter for the 0s. You'll have to check me I'm not 100% sure that's the tag for Account Number.
👍 2
h
Thank you!! I'll test this, I think the tag is accountnumber I believe you are correct there.