Search code examples
informatica-powercenter

What does this filter code means?


IIF(ASCII(A) >= 48 AND ASCII(A) <= 57, TRUE, FALSE)

Does anyone have any idea what does ASCII do here and what does the code try to accomplish? I ran into this filter condition on our informatica and I am not an ETL developer.

Any help will be greatly appreciated.


Solution

  • Well, it checks if A is in interval between 48 and 57 position in ASCII table.

    Looks like it's check for numbers. (it's 0 to 9).

    Check this out - LINK