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
- 17259 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 names of the layers in etl?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Do we need an etl tool?
Explain about round-robi?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the difference between OLTP database and data warehousing database?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
Is apache nifi an etl tool?
What is the difference between Data Warehousing and Data Mining?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
how do u identify the changed records in operational data?
Teradata 
