Hi, use this function for above question, replacestr(0,col,'$'

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...

Question Posted / meenakshivc

6 Answers
12190 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / meenakshivc

Hi,

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

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization and types in informatica

1122

What is an Integration service in Informatica?

1191

How can you increase the performance in joiner transformation?

1248

What are the transformations that are not supported in mapplet?

1084

what is the Default Source Option For Update Strategy Transformation?

1287

Mention some types of transformation?

1097

What are the different components of powercenter?

1114

What do think which one is the better joiner or look up?

1247

Different qualification between a related rotate toward the sky and isolates look upward?

1039

Can anyone tell me the new features in Informatica 9 Version?

2213

What is a connected transformation?

1185

What do you mean by filter transformation?

1006

How to elaborate powercenter integration service?

1174

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2252

What are the databases that informatica can connect to windows?

1098