AnsweredAssumed Answered

Script: Truncating Text Values and search/replace text

Question asked by lkeyes on Jul 30, 2012
Latest reply on Jul 30, 2012 by robwoof

I've got a situation where I've got a committee name and a church name that I want to truncate to use as a file name:


"Committee On Formation" is an example, I"d like to truncate this to something like



1. Eliminate the "Committee" part of the string

2. Truncate to a maximum of 14 letters. (Probably using Left function)

3. Append ."pdf"



"Colchester St. Andrew's"



1. Strip out spaces and apostrophes

2. Truncate to maxium of 14 letters (probably using Left function)

3. append ."pdf"


I know there is a combination of script steps and probably functions for this, but can't seem to put the right thing together.


There is a field in the data table that contains the source string.

I'm stroring the results in a variable - $FileName


I don't have a problem with the truncation (step 2's above...); but I'm trying to figure out the first step in each example.


---- Larry