AnsweredAssumed Answered

How do I Extract the first letter each of a 3 word string?

Question asked by gcastle on Jan 4, 2012
Latest reply on Jan 6, 2012 by ibrahim_bittar

How do i Extract the first letter of each word of a 3 word string?

Do I somehow nest a Left() in a LeftWords() then Middle() - the same and Right() - the same?

I want to put a company name in a "Company" field and when I leave the field trigger the calculation to put the first letter of the first three words of the company field in the Company ID field.

 

Your help will be appreciated! Gary E Castle

Outcomes