Joined: 23 Dec 2005 Posts: 61 Location: Providence , US
Hi All,
I have a problem , i am creating a file whose input file has some corrupt data . Thus , the o/p file is having the same too. So that is causing problem in FTP process as the data when downloaded is in junk format for some fields (the file which i create is ftp ed to a diff vendor ). I cannot change the input file , thus while populating the o/p field i have put in a patch like given below ..
Thus it checks for valid value then populate the o/p file . But , is there any better way that i can check for alphabets and special charchters ,numbers without using this sort of logic ?
Instead of writing all alphabets and numbers in value clause, u want to write a smart statement.
If my understanding is right. Following may one may solve ur problem.
Instead of writing all alphabets from "A" to "Z", u can use IS ALPHABETIC clause to check all alphbets. To check numbers, u can use IS NUMERIC clause and for special chanracters, as for as I know, u have to code indivisually.
Joined: 23 Dec 2005 Posts: 61 Location: Providence , US
Hi Ksk,
Thanks for the quick reply . Yeah u got my problem , yes i was thinking of
changing for alphabets and numbers but can we handle the special charchters too my any smarter way . 'coz i dont know of any ? If you do come across or any body else , please do inform me.