Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Splitting account name and parent account name
Hi,
I am doing a transaction search and want a separate column for the account name (without number and parent name) and then another column for the parent account number and the parent account name.
I am looking for these fields but struggling. maybe they all exist as selectable fields but i cant find them. I have got the Account number but i cant seem to strip out the account name without it including the parent name? i have tried the following Text Formula but this is not working
SUBSTR({account}, INSTR({account},’:’))
What have i got wrong here?
Chris