transformation

smohd1338 · Post by **smohd1338** » Tue Mar 19, 2013 8:20 am

Hi, if in input field, "Change Section Design" i need output as CSD , the first letter of each word in the input.how do i dot his?

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 19, 2013 8:23 am

is space only the delimiter for the words?
is three words the maximum?

smohd1338 · Post by **smohd1338** » Tue Mar 19, 2013 8:30 am

yes, sapce is the only delimeter, but its not just 3 words, it can be 4, or words or 2 or 1, input may also come lilke "input may also come lilke" then output is IMACL

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 19, 2013 8:48 am

For now i can think like this. Considering the maximum number of words as n.

Code: Select all

   LEFT (FIELD (lnkIp.ip_column, " ", 1), 1)
|| LEFT (FIELD (lnkIp.ip_column, " ", 2), 1)
|| LEFT (FIELD (lnkIp.ip_column, " ", 3), 1)
.
.
.
|| LEFT (FIELD (lnkIp.ip_column, " ", N), 1)

I dont think we can loop in some way.
This is the option to get first character of a string.

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 19, 2013 8:53 am

There must be a size for the input column so we can somehow conclude the value N.
And in the above solution irrespective of any number of words in input it will gives us result

smohd1338 · Post by **smohd1338** » Tue Mar 19, 2013 9:08 am

the size is 150 varchr coming in input, looks liek the value of N can be anythng between 1-10 mostly

prasson_ibm · Post by **prasson_ibm** » Tue Mar 19, 2013 9:16 am

Hi,
If you are in version 8.5 and above,you can use the power of transformer caching.

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 19, 2013 9:18 am

yeah you know the data very well. you can repeat the function any number of times. guess 25 will be better

smohd1338 · Post by **smohd1338** » Tue Mar 19, 2013 9:22 am

I am using 8.1

chulett · Post by **chulett** » Tue Mar 19, 2013 9:24 am

That would be pretty trivial in a Server routine. Any chance of using a BASIC Transformer in your job?

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 19, 2013 9:24 am

Hmm i expected this. Can you explain how we are acheiving it in higher version

If you are in version 8.5 and above,you can use the power of transformer caching.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 19, 2013 1:27 pm

Use BASIC Transformer stage and Oconv(InLink.TheString, "MCT")

chulett · Post by **chulett** » Tue Mar 19, 2013 2:23 pm

Ray, isn't that the same as CAPITALS? If so they just the first letter of each word, not the first letter of each word capitalized. If I am mis-remembering what "MCT" does, forgive me...

ray.wurlod · Post by **ray.wurlod** » Tue Mar 19, 2013 2:53 pm

CAPITALS is a Transform that encapsulates Oconv(%Arg1%, "MCT")

chulett · Post by **chulett** » Tue Mar 19, 2013 2:57 pm

That's what I thought... meaning it won't solve their problem.