Skip navigation
Contact Us
651 Views 0 Replies Latest reply: Feb 13, 2013 10:54 PM by Oğuz KARA RSS
Oğuz KARA Newbie 1 posts since
Feb 11, 2013
Currently Being Moderated

Feb 13, 2013 10:54 PM

Perl compatible regular expression syntax error..

Hi,

 

i am using reg_replace function to eliminate whitespaces but whenever a unicode character found in the string informatica raise an error like that;

 

 

2013-02-11 14:33:50 : ERROR : (6868 | TRANSF_1_1_1) : (IS | PCI_Unicode) : Informatica2_Node : TE_7007 : Transformation Evaluation Error [<<Expression Error>> [CustomFunc]: Process row failed for function [REG_REPLACE]: The Integration Service failed to extract the subpattern because of a perl compatible regular expression syntax error..

... u:CustomFunc(u:'asdfasd      İ i I ı Ğ ğ ş Ş Ö ö Ü ü Ç ç',u:'\s+',u:' ')]

2013-02-11 14:33:50 : ERROR : (6868 | TRANSF_1_1_1) : (IS | PCI_Unicode) : Informatica2_Node : TT_11132 : Transformation [EXPTRANS] had an error evaluating output column [reg_str]. Error message is [<<Expression Error>> [CustomFunc]: Process row failed for function [REG_REPLACE]: The Integration Service failed to extract the subpattern because of a perl compatible regular expression syntax error..

... u:CustomFunc(u:'asdfasd      İ i I ı Ğ ğ ş Ş Ö ö Ü ü Ç ç',u:'\s+',u:' ')].

 

is it a bug? how can i handle

 

thanks

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points