[Woth]

for the first problem,

you could use the following functions

Code: Select all

Count(yourString,".IR")  -- gives you the number of occurences of ".IR" in your string
Right(yourString,3)=".IR" -- gives you the last 3 chars

for the second problem, you could use in a transformer

Code: Select all

index(yourString,"EXCH",1) 

- if the result is equal to 0 then yourString does not contain the token "EXCH" . if its not equal to 0 then the number returned by the function is actually where the "EXCH" token has been found in the string (ex. 7 would mean that the word "EXCH" starts at the 7th char in yourString


refer to the manuals for more info on how to use them

hope it helps

[ArndW]

The COUNT() function might not be the best since it finds any and all occurrences and not just those at the end of the string, but you can use the RIGHT() function to extract the last 2 or 3 characters in a string and do your comparison on that.

[ray.wurlod]

I think the best approach is pattern matching here.

Code: Select all

InLink.FirstCol Matches "0X'.IR'" : @VM : "0X'.P'" : @VM : "0X'.UN'"

For the second, Count() is probably the most efficient. Index() is valid too, as is pattern matching.

Code: Select all

InLink.SecondColumn Matches "0X'EXCH'0X"

[narayana_382]

Ray,

Please let me know what does it mean by
Code: InLink.FirstCol Matches "0X'.IR'" : @VM : "0X'.P'" : @VM : "0X'.UN'"

Code logic indicates that we are appending the pattern matching characters.

Thnks in Advance,
Nari.

[ray.wurlod]

"0X" in DataStage BASIC pattern matching is a wildcard. The value marks (indicated by system variable @VM) create a multi-valued pattern, so that the Matches operator is satisfied by a match against any of the individual patterns. So my expression is true if InLink.FirstCol has a value that ends in ".IR" or ends in ".P" or ends in ".UN".

[ravindrag]

Thanks
right function is working for .IR and .Un
count function is working for 'EXCH'

[ray.wurlod]

And "*.P" ?

[ravindrag]

it also working