begins with function

parvathi · Post by **parvathi** » Mon Sep 04, 2006 11:04 pm

Hi all,
Are there any datastage functions like begins with or ends with ...
I just want to check in the transformer that whether a certain coulmn begins with a particular word...

rasi · Post by **rasi** » Mon Sep 04, 2006 11:18 pm

Hi

do you mean Datastage reserved words. Please be more clear.

balajisr · Post by **balajisr** » Mon Sep 04, 2006 11:24 pm

parvathi wrote:Hi all,
Are there any datastage functions like begins with or ends with ...
I just want to check in the transformer that whether a certain coulmn begins with a particular word...

There is a function named "Matches". Check that out.

parvathi · Post by **parvathi** » Tue Sep 05, 2006 1:09 am

yes datastage reserved words ..
The scenario is as follows ..
i have to compare an input column in the transformer and check whether that column starts with the "begin" or "end" and then i have to do some more operations....

rasi · Post by **rasi** » Tue Sep 05, 2006 1:17 am

Hi Parvathi

Use Constraint in transformer and inside that type the condition (eg InputColumn = 'begin' Or InputColumn = 'end'). This will only allow records with your conditions.

You can also have the same logic applied in your transformer expression using If clause.

If InputColumn = 'begin' Or InputColumn = 'end' Then Expression1 Else Expression2

parvathi · Post by **parvathi** » Tue Sep 05, 2006 2:59 am

thanks ... i was to do with that idea

chulett · Post by **chulett** » Tue Sep 05, 2006 7:04 am

rasi wrote:If InputColumn = 'begin' Or InputColumn = 'end' Then Expression1 Else Expression2

Um... that doesn't check that the field starts with those values, that checks if they are equal to those values.

Substring would be one way:

Code: Select all

If InputColumn[1,5] = 'begin' Or InputColumn[1,3] = 'end' Then Expression1 Else Expression2

ray.wurlod · Post by **ray.wurlod** » Tue Sep 05, 2006 4:41 pm

There are Left() and Right() functions available. Using these would make the meaning in your expression pellucid.

rasi · Post by **rasi** » Tue Sep 05, 2006 7:49 pm

Sorry Craig

I missed the substring....

chulett · Post by **chulett** » Tue Sep 05, 2006 8:47 pm

ray.wurlod wrote:Using these would make the meaning in your expression pellucid.

As noted, substring was just one way... these are another. To be transparently clear.

parvathi · Post by **parvathi** » Wed Sep 06, 2006 3:05 am

thanks a lot to everyone and to their valuable ideas.... I tried with all the options...

DSXchange

begins with function

begins with function

Re: begins with function