Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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"

Answer Posted / kumaravelu

substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fine tune mappings?

943


where we cannot use sorter Transformation. if we use then we will not get correct data?

2199


What are the different etl testing categories as per their function?

1078


What is etl tool in hadoop?

894


What are the names of the layers in etl?

1001


Explain etl mapping sheets?

1082


Explain what are the various etl tools in the market?

948


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1865


What are the types of Data Warehouse applications?

1025


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1004


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2271


what is a worklet?

998


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1200


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2497


what is data modeling?

2319