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.



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

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


Issue with Update override at Target table in Informatica.

2 Answers  


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


What is the Router transformation?

2 Answers   Informatica,






What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  


What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,


how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,


Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,


Categories