I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?

Answer Posted / bob

Repacechr(1,""TCS"MUMBAI",'"',null)

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How union transformation is used?

595


What does update strategy mean, and what are the different option of it?

590


What are the different lookup cache(s)?

622


Whats there in global repository

1272


Different sorts of metadata that stores in the storage facility?

564






HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1481


permutations of mapplet

2042


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1467


difference between informatica 8.1.1 and 8.6

3246


Explain direct and indirect flat file loading (source file type) - informatica

837


How many ways a relational source definition can be updated and what are they?

585


what is the complex transformation you used in informatica

2194


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793


How you know when to use a static cache and dynamic cache in lookup transformation?

1343


What are the transformations that are not supported in mapplet?

603