special character

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
fmartinsferreira
Participant
Posts: 142
Joined: Wed Mar 24, 2004 10:51 am
Location: Brazil

special character

Post by fmartinsferreira »

Is there any function to recognize special character?

Regards,

Fernando Martins
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What do you mean by "special"? The Alpha and Num functions can isolate whether a string is alphabetic or numeric. The expression (Oconv(string,"MCP") = string) can report whether a character is printable. Some special characters live in particular code point ranges, for example "control set 0" comprises all the characters whose code point is 31 and below.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
fmartinsferreira
Participant
Posts: 142
Joined: Wed Mar 24, 2004 10:51 am
Location: Brazil

Post by fmartinsferreira »

I mean by "special" = a character that isn't on the keyboard. :D

Regards,

Fernando Martins
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

So, effectively, the non-printing characters.

Code: Select all

(Oconv(ch, "MCP") = ch)
will identify that the character is non-printable. The expression returns 1 (true) if the character is non-printable, 0 (false) otherwise. It returns NULL if ch is NULL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
fmartinsferreira
Participant
Posts: 142
Joined: Wed Mar 24, 2004 10:51 am
Location: Brazil

Post by fmartinsferreira »

Thanks!
Post Reply