replace ('323-237-2323','-', '')

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"

Question Posted / kumaravelu

11 Answers
16862 Views
I also Faced
E-Mail Answers

Answer Posted / kumaravelu

replace ('323-237-2323','-', '')

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is grain of fact?

946

Identifying the bottlenecks in various components of Informatica and resolving them.

1914

Explain the use lookup tables and Aggregate tables?

960

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3004

explain the methodology of Data Warehousing?(Polaries)

2276

What is etl tool in hadoop?

879

Is hadoop a etl tool?

922

Identifying the bottlenecks in various components of Informatica and resolving them.

2605

tell me few points when u become TL

2507

dimension object created in oracle can be imported in designer?how?

2965

how to load the data to fact table?

2686

What is partitioning? Explain about round-robin, hash partitioning.

932

Explain what are the various etl tools in the market?

914

how many maximum session supports to multiload in teradata ??

2090

What is full load & incremental or refresh load?

1191