meenakshi


{ City } banglore
< Country > india
* Profession *
User No # 86644
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 1
Questions / { meenakshi }
Questions Answers Category Views Company eMail




Answers / { meenakshi }

Question { IBM, 10023 }

i have a flat file and the file s are like below
****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$
IN THIS FORMATE
Means un limited special charecter between and sides of the
string data..output should be(GANESH)
HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE
AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...


Answer

Hi,

use this function for above question,
replacestr(0,col,'$','!','@','#','%','^','&','*', NULL)
or
replacechr(0,col,'$!@#%^&*', NULL)

Is This Answer Correct ?    8 Yes 1 No