Hello, I'm trying to use a formula on a related customer field on a transaction search, to remove the account number. Since we're using account numbers, some searches/reports include customer name as: (account number account name). For example 1018268 Morehouse College. I want to break it up so there is a formula field for account number and one for account name. I figured out the formula to get the account number (using LPAD), but I can't get just the account Name (Morehouse College). It seems that the trim functions trim specific characters but not a number of characters. (I'd like to trim 8 characters from the left.) Thank you!

This formula will extract everything after the first space character, which looks like it might work for your use case:

SUBSTR({field}, INSTR({field}, ' ') + 1)

Thank you - I'll give it a try!