hey guys, I am using the formula (text) field in a...
# suitescriptl
leo
04/20/2020, 4:14 PMhey guys, I am using the formula (text) field in a saved search and trying to remove the parent name from the item name by using LTRIM(LEADING ':' FROM '{name}') - but i get "error"...anyone knows how to best use this?
t
The Usual Suspect
04/20/2020, 4:18 PMI'm guessing you are doing this in a script? It might be best to handle this logic there so the query doesn't have to process this string manipulation. My guess is there is a null or empty string value possibly throwing your formula off but i'm pretty bad with formulas
b
battk
04/20/2020, 4:25 PMREPLACE({name}, {parent} || ' : ', '')l
leo
04/20/2020, 4:25 PMnot script actually, just formula (text) in saved search
about to try that out @battk
b
battk
04/20/2020, 4:27 PMyou can make it more complex if you want to handle evil cases like items containing ' : ' in the name
l
leo
04/20/2020, 4:36 PMwell sum items may have subparents so maybe I do want to be more evil @battk 🙂
s
Sandii
04/20/2020, 4:37 PM Copy code
NVL(REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ',''),{name})Sandii
04/20/2020, 4:37 PMUse that one, store it somewhere so you do not have to figure it out ever again
l
leo
04/20/2020, 4:37 PM@Sandii - I totally gotta learn that!!!
b
battk
04/20/2020, 4:42 PMi dont think that passes the evil test
battk
04/20/2020, 4:45 PMi dont think you need regular expressions for this
l
leo
04/20/2020, 4:56 PMfrom the guy who is getting into coding and learning it - NVL and NVL2 -- what's the difference?
battk
04/20/2020, 4:59 PMgenerally the difference is if you want a different value if null vs you want to do something different when null
l
leo
04/20/2020, 5:00 PMOH cool, THANKS!
12 Views