begins with function
Moderators: chulett, rschirm, roy
begins with function
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...
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...
Re: begins with function
There is a function named "Matches". Check that out.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...
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
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
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Um... that doesn't check that the field starts with those values, that checks if they are equal to those values.rasi wrote:If InputColumn = 'begin' Or InputColumn = 'end' Then Expression1 Else Expression2
Substring would be one way:
Code: Select all
If InputColumn[1,5] = 'begin' Or InputColumn[1,3] = 'end' Then Expression1 Else Expression2
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: