CODEWITHSUNDEEP
informatica-powercenter
JohnD
JohnD

Reputation: 353

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.

Upvotes: 0

Views: 79

Answers (2)

Samik
Samik

Reputation: 3455

The filter will pass the records for which the field A starts with a number.

Upvotes: 0

John Doe
John Doe

Reputation: 1319

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

Upvotes: 2

Related Questions