This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

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:
```LTRIM({otherrefnum},'#')```
otherrefnum: PO#123456
After workflow = 123456

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 