| Stephen W. Thomas 2004-11-09, 5:49 pm |
| Hello.
I did something just like this in the past. I set up a VB function. Then,
I called it inside a scripting functoid in the map. I had to add a new
scripting functoid for each element and it ended up being over 100. I ran
some basic performance tests on this and the impact was about 15% slower with
all the scripting calls.
This approach was taken since the output is flat file and we only wanted 90%
of the fields converted. Inside a pipeline it would be more difficult to
selectively select items and after conversion to Flat File the proper casing
wouldn’t work correctly.
Stephen W. Thomas
http://www.geekswithblogs.net/sthomas
"RichTheHSTGuy" wrote:
>
> I have multiple data inputs that are recieved in upper case which need to map
> to the output in 1st letter upper case all others in lower case.
> E.G.
> JOE CAMEL to Joe Camel
> 123 SOUTH MAIN STREET to 123 South Main Street
> ANYTOWN KANSAS to Anytown Kansas
>
> 1. Can this be accomplished with 1 functoid for all of a couple of hundred
> inputs.
> 2. Do I have to have a functoid for each input
> 3. Best way to accomplish this
>
|