Informatica does not have this documented but you could use SUBSTR function to go from Right to Left as well. Just use a negative start.
IIF(SUBSTR(FILENM,-4)='.PDF', 'PORTABLE')
of what I learned today
No comments:
Post a Comment