DSXchange

I was trying to process only numeric data in a file based on a particular column and track other records with Alpha numeric. i used to process recrods with numeric data, however when i try to use to track records with alphanumeric records, could you please suggest me whats the best way to track alpha numeric records,i use constraint in transformer stage.

Thanks in advance for your help.

edward_m wrote:however when i try to use <snip>

What happens?

Perhaps a simple if-then-else?

If num(column) then X else Y

alnum() function.

Hi,

I think Alnum() checks for Alphabets Or Numbers Or AlphaNumerics in a string.
Not only AlphaNumerics.

=========================
RPhani

Read the manual.

It Checks only alphanumeric characters

Link :- https://dtdctw99.tdbank.ca/infocenter/i ... ditor.html

Hence the name.