How do you trim commas on the item description via...
# general
n
How do you trim commas on the item description via saved search? Our item description has item names such as blah blah blah, blah, blah, blah separated with multiple commas. This text formula didn't work!! trim(both',' from {displayname})
g
REPLACE({displayname},',','')
👍 1
that will remove all commas.
n
will try this now, Gregory...
oh wow, worked like magic. Thank you very much!
g
No problem!
n
@grejon04 would you happen to know what formula would I put in the Criteria to only show items that contain commas in displayname and exclude items that don't contain any commas?
s
You should be able to use the
contains
operator with a comma in the value box to the right, to get back only records where the field contains a comma
👍🏻 2