Alphanumeric data

[edward_m]

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

Code: Select all

num(column)=1

to process recrods with numeric data, however when i try to use

Code: Select all

num(column)<>1

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.

[chulett]

however when i try to use <snip>

What happens?

Perhaps a simple if-then-else?

If num(column) then X else Y

[ray.wurlod]

alnum() function.

[RPhani]

Hi,

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

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

[ray.wurlod]

Read the manual.

[vibwipro]

It Checks only alphanumeric characters

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

[chulett]

Hence the name.