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
- 16869 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what do u do when DB time takes more?in sap bi
What is etl process? How many steps etl contains?
how do use session mapping parameters ?(in which transformation)
What do you understand by the term ‘transformation’?
Compare ETL & Manual development?
what is the meaning of upgradation of Repository?
what is data modeling?
What are your responsibilities as an etl tester?
where are the log files generally stored.Can you change the path of the file.what can the path be?
what are the types in error loging?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
How can we use external procedural logic in informatica?
how does the server recongnise the source and target databases.Elaborate on this
what are the data modeling tools you have used?(polaris)
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
