Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 11 Answers
- 17266 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
Use trim(columnname,'_','a') to remove the '-' values from
the columns
2) use field function: field(columnname,'@'2) to get the
company.com
Thanks
Kumar
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
what is pmrep command?
what is session partitioning?
What is partitioning? Explain different types of partitioning?
what are the production issues in datastage?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain about round-robi?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is etl tool in hadoop?
how do u set partition points in the mapping?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what is different between sequential batch and concurrent batch and which is recommended and why?
Compare ETL & Manual development?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are dimensions?
how do u extract data from different data sources explain with an example?
