Method Community

Hi,

Can someone please point ne in the right direction on this? I am trying to use "Enter Value into Field on Screen" but I want to trim the first 9 characters. (It is either Billable: or Overhead:)

I have been through all the functions and have tried different combinations of them - but not working yet.

I see join with space, comma, etc. But is there somehow to split it?

Get right doesn't work because the information after the colon is various lengths. 

Get left doesn't work because it just gives me Billable: or Overhead: which I want to remove.

Thank you,

Annette

Annette,

You can use the Character function to get the length of the value first, then use a basic math calculation to trim 9 from the length value.  You can then use Get right as you would know the length after the colon.

- Adam