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
- 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