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
- 16532 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / again kuttu!!
select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satish
select replace ('323-237-2323','-') from dual
select substr('test@company.com',6,11) from dual
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kkr
select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / venkateswara rao
--Written in sqlserver
declare @num varchar(100) ='323-237-2323'
, @str varchar(100) ='TEST@COMPANY.COM'
, @ind int
set @ind= CHARINDEX('@',@str)
select SUBSTRING(@str,@ind+1,LEN(@str))
print @ind
select REPLACE(@num,'-','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / erqf
2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;
| Is This Answer Correct ? | 0 Yes | 3 No |
What are the steps involved in etl process?
When do we go for the tools in the market?
SCD2 will work on only dimension tables as well as fact Table?
What is factless fact schema?
what happens if the info.server doesn't find the session parameter in the parameter file?
without using ETL tool can u prepare a Data warehousing and maintaining?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
Can u access a repository created in previous version of Informatica?
what are the data modeling tools you have used?(polaris)
How many steps etl contains?
Explain what is etl process? How many steps etl contains explain with example?
Teradata 
