Does anyone know of a way you could identify if a ...
# suiteanalyticsm
Matt
03/08/2017, 4:05 PMDoes anyone know of a way you could identify if a Purchase Description has a linebreak in it?
k
kimberly
03/08/2017, 4:06 PMmatt: which trx type?
m
Matt
03/08/2017, 4:06 PMitem
k
kimberly
03/08/2017, 4:06 PMchecking for you - i dunno off the top of my head
kimberly
03/08/2017, 4:08 PMhaha - unfortunately, does not show it!
kimberly
03/08/2017, 4:09 PMthat's annoying, sorry for that
m
Matt
03/08/2017, 4:10 PMI've tried something along the lines of instr({description}, chr(10)) > 0)
Matt
03/08/2017, 4:10 PMBut it just returns everything.
k
kimberly
03/08/2017, 4:11 PMi didnt use a formula, it was much simpler than what you tried. i added a break then ran a SS to check.. it shows it all lumped into one line