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
- 14178 Views
- I also Faced
- E-Mail Answers
Answer Posted / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How can we use external procedural logic in informatica?
What is Data Vault???
What are the key benefits of ETL Testing?
What are the ETL Testing Operations?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What are the etl testing operations includes?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is the difference between round-robin partitioning and hash partitioning?
What are three tier systems in etl?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are the three tiers in etl?
Explain what are the various etl tools in the market?
How to delete data which is not in source table?
State the differences between shortcut and reusable transformation
Explain what is etl process? How many steps etl contains explain with example?
