How to get rid of non ascii characters in a string? Ex:- United States Microsof

How to get rid of non ascii characters in a string?
Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件

to

United States Microsoft Visual Studio Tools for Applications 2012 x86.

Question Posted / ravi

1 Answers
3686 Views
CTS, I also Faced
E-Mail Answers

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tool..

Answer / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Informatica Interview Questions

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers L&T,

How can yoU improve session performance in aggregator transformation?

8 Answers TCS,

What is hash partition?

2 Answers

Insert else update option in which situation we will use

4 Answers HCL,

how will you get 21 to 30 record from 50 records?

6 Answers

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers

diffrence between command task and control task

1 Answers iNautix,

What are the reusable transformations?

0 Answers Informatica,

What is different between the data warehouse and data mart?

0 Answers

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers

what is index?how it can work in informatica

0 Answers

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers Altisource, Patni,

For more Informatica Interview Questions Click Here