Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 6 Answers
- 12191 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / anirban_ghosh
Since it's been said...we know nothing of the special characters present in between...therefore..the wise thing would be tp extract each character and compare it with the (int value) of the alphabets......if the (int) value of the extracted character is between....65-90 or 97-122......store it in a queue......at the end....flush out the queue....that's it!!!
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you load first and last records into target table?
When do you use sql override in a lookup transformation?
Differentiate between Load Manager and DTM?
How we can create indexes after completing the loan process?
How many ways are there to do 'remove duplicate records in informatica'?
wat are deployement groups in informatica, how it will be used for developers
What is option by which we can run all the sessions in a batch simultaneously?
How do you load alternate records into different tables through mapping flow?
Why update strategy and union transformations are active? Explain with examples.
Can you generate sequence numbers without using the sequence generator transformation?
What are Dimensional table?
Explain your project of banking domian.
What does refresh system mean, and what are its distinctive choice?
is it possible to index the data in cache of lkp transformation ?
how we can load rejected record's at run time?(not through bad files)
