2)if findc(emailid,'@','company.com')=0 then emailid=

CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"

Question Posted / erqf

11 Answers
17263 Views
I also Faced
E-Mail Answers

Answer Posted / erqf

2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

When do we analyze the tables? How do we do it?

1002

what are the facilities provided by data warehouse to analytical users?

2121

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2314

What are the etl testing operations includes?

1156

What are the types of Data Warehouse applications?

1083

How many steps etl contains?

993

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1113

Define slowly changing dimensions (SCD)?

1100

what are the session parameters? How do u set them?

2094

Explain and compare etl & manual development?

974

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2413

what do u do when DB time takes more?in sap bi

2244

What is Data Vault???

2792

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2088

What is data modeling and data mining?

1022