https://netsuiteprofessionals.com logo
#suiteflow
Title
# suiteflow
p

PlanetJupiter

03/28/2022, 2:30 PM
I'm trying to use LTRIM in a workflow to remove all text left of '#' character. I have this so far, which doesn't seem to do anything:
Copy code
LTRIM({otherrefnum},'#')
otherrefnum: PO#123456 After workflow = 123456
a

AI1

03/28/2022, 2:53 PM
If the beginning characters are always the same length you could use SUBSTR SUBSTR({number}, 4, 20) That would start at character 4 and do everything after it
Or if it's inconsistent use a combination of SUBSTR and INST
3 Views