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

How to load a Dimension ? and how to load a fact table?

1395

What is lookup transformation?

1017

COM components can be used in Informatica

2344

What are the new features of informatica 9.x in developer level?

960

How to use procedural logic inside infromatica?

1169

Define pmcmd command?

1010

Reusable transformation and shortcut differences

1805

How to load last n records of file into target table - informatica

1039

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1292

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1246

What are Dimensional table?

1021

Why do you use Mapping Parameter and mapping variable?

1712

What does reusable transformation mean?

1097

What is the fact table?

1022

What is meant by incremental aggregation?

1055