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')
Tuesday, January 17, 2012
Thursday, January 12, 2012
Regular Expressions in Informatica
Informatica supports PERL like regex syntax. So any parsing you would do in shell, can be done in Informatica as well.
In the code above, __ are the delimiters in the string.
The regext part
\w looks for any alphanumeric character including underscore. Adding + to it makes it look for multiple alphanum characters.
() are to group the patterns
. looks for any character and adding & * makes it look for all the occurrences of any characters.
So we have four groups and the output is the 3rd group.
OUTPUT
Can you figure the other groups? Now can you figure how many groups we need if we just need the number of books in series or just the genre?
REG_EXTRACT('Fiction__JK_ROWLING__HARRY_POTTER__MAX07','(\w+)(__\w+__)(\w+)(__.*)',3)
In the code above, __ are the delimiters in the string.
The regext part
\w looks for any alphanumeric character including underscore. Adding + to it makes it look for multiple alphanum characters.
() are to group the patterns
. looks for any character and adding & * makes it look for all the occurrences of any characters.
So we have four groups and the output is the 3rd group.
OUTPUT
HARRY_POTTERCan you figure the other groups? Now can you figure how many groups we need if we just need the number of books in series or just the genre?
Subscribe to:
Posts (Atom)