Skip to Content
Former Member
Oct 01, 2009 at 10:45 PM

Using Split to sort out contractors from Feds


split({description field}," ")[1]

I'm wondering if and how I could use this to solve another issue. Perhaps I should start anopther thread but it is along the same lines as this one.

We need to separate out the work done by the contractors and the work done by the Feds. All contractors have CTR in the middle of their name though some, because Lotus Notes won't allow duplicate names in the directory, use their middle initial. So in other words, my name is

Barbara CTR Buckley

If I were to use my middle initial my name would be:

Barbara A-CTR Buckley

Could I use this formula to somehow pull out all the contractor work and if so, how would I go about accounting for both situations (middle initial and no middle initial)? If not what would be the best way to do this?