Control character or Unprintable character in string

[sharma]

Hi,

I want to check whether the string contain control character /Unprintable character in it.

How do i check in the transformer stage .

Is there any function is there to check the same??

Can i check by their Ascii values ??? But how in DS.

Regards
~Nirmal

[kumar_s]

Try using AlNum if its Alpha numeric, or Alpha if only string.
Optionally IsValid for specific datatypes.

[sharma]

ALNum() function checks only for alpha numeric character in the string.

But i actually wanna check .... whatever string i am using should have ASCII characters between 32 and 127.If any of the character is outside this range,it should reject that string.

[ray.wurlod]

Write yourself a little routine.

[kumar_s]

If you are ready to use Server jobs, there are more functions available like chr(), ascii() etc.,

[sharma]

chr() is also there in parallel jobs but ascii() function is not there in parallel jobs.

But i am not sure how to check for an control character within a string using chr() function.

[ray.wurlod]

Prefer Seq() function. Seq() returns the ASCII code value associated with a character.

If you have NLS enabled and are using multi-byte encoding, prefer UniSeq() to Seq(). UniSeq() returns the Unicode code value associated with a character. If you have a single-byte character set, UniSeq() returns the same result as Seq().

[John Smith]

Hi,

I want to check whether the string contain control character /Unprintable character in it.

How do i check in the transformer stage .

Is there any function is there to check the same??

Can i check by their Ascii values ??? But how in DS.

Regards
~Nirmal

You can use the "od" command outside of DS; but that's in Unix unfortunately. You could do this before you run the job meaning run the script to check and cleanse the file prior.
I believe the others have chipped in on doing it in DS ; just offering an alternative.

[JoshGeorge]

Use this logic in your parallel routine:

Ref THIS post also.

Code: Select all

#define NP_RANGE_START  32 
#define NP_RANGE_END    127 


bool IsCharNP(char InCharToCheck ) 
{ 
   bool IsNotPrintable = false; 

   if( (InCharToCheck > NP_RANGE_START  ) && ( InCharToCheck < NP_RANGE_END )) 
   { 
      IsNotPrintable = false; 
   } 
   else 
   { 
      IsNotPrintable =  true; 
   } 
    
   return IsNotPrintable; 
} 

[ray.wurlod]

That's not generally true. All printable accented characters are between 129 and 255.

[JoshGeorge]

OP asked for it. Specifically!

whatever string i am using should have ASCII characters between 32 and 127.If any of the character is outside this range,it should reject that string.