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"

Answer Posted / kumaravelu

replace ('323-237-2323','-', '')

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is different between sequential batch and concurrent batch and which is recommended and why?

4538


what are the production issues in datastage?

9843


how many steps are there in etl process?

627


what is pmrep command?

2034


what is the difference steps for data modeling?

1661






What are the names of the layers in etl?

617


where is the cache (lookup, index) created and how can you see it.

1668


What are dimensions?

672


if i have a query as flat file how can we load data to target table

1062


Explain about hash partitioning?

624


What are the types of Data Warehouse applications?

595


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

622


What is staging area referring to?

659


Explain do we need an etl tool? When do we go for the tools in the market?

690


What is abap? What are idocs?

593