[Jeff Wolf]

I have a column in one of my searches that pulls in data related to revenue. The result shows *Marketing Execution : Email. Is there a way to only show the work Email or anything to the right of the : ?

thanks
This is a cached copy. Click here to see the original post.

[rnedelkow]

The LTRIM string function might do the trick. SuiteAnswer 21503 provides a few examples.

[Jeff Wolf]

I'm not sure I'm following that. I need it to look at a character in a custom field. I tried LTRIM(: [, {custcol_item_for_je}]) and it isn't working thoughts?

[fourthwaveconsulting]

Try this:

LTRIM(':' , {custcol_item_for_je} )

The brackets indicate optional fields, and shouldn't be included when you use the formula. Also, literals should be in a single quote.

[rnedelkow]

There's also this formula that works on parent : child hierarchy results:

rtrim(regexp_substr({field},'[^:]*$'))

[Jeff Wolf]

that 2nd one worked perfectly!!! thank you very much!

[Author]

Posts