Convert Special Character Issue
Posted: Tue Jun 01, 2010 2:37 pm
Hi,
I have a requirement to convert one special character("") to empty (Need to drop this character when encountered).The sequence of keys to generate the special character is:CTRL + Shift +6.
I have used the convert function as
Convert("","",lnk_db_xfm_po_part_dimension.NM_PART).
But the transformer is throwing a compilation error
Property value cannot contain UniVerse mark characters.
Property name is: Value
Invalid data is : //
// Generated file to implement the V0S17_CopyOfCopyOfDRD5558_ex_OTO_XFM_PO_PART_DIMENSION transform operator.
//
// define our input/output link names
inputname 0 lnk_db_xfm_po_part_dimension;
outputname 0 lnk_xfm_ds_po_part_dimension;
initialize {
// define our row rejected variable
int8 RowRejected0;
// define our null set variable
int8 NullSetVar0;
// declare our intermediate variables for this section
string InterVar0_0;
string InterVar0_1;
string InterVar0_2;
// initialise constant values which require conversion
InterVar0_0 = "1845561";
InterVar0_1 = "
";
InterVar0_2 = "";
}
mainloop {
// initialise our row rejected variable
RowRejected0 = 1;
// evaluate constraint and columns for link: lnk_xfm_ds_po_part_dimension
if ((trimc_string(lnk_db_xfm_po_part_dimension.ID_PART) == InterVar0_0))
{
lnk_xfm_ds_po_part_dimension.NM_PART = replace_substring(InterVar0_1 , InterVar0_2 , lnk_db_xfm_po_part_dimension.NM_PART);
writerecord 0;
RowRejected0 = 0;
}
}
finish {
}
Will replace with: //
// Generated file to implement the V0S17_CopyOfCopyOfDRD5558_ex_OTO_XFM_PO_PART_DIMENSION transform operator.
//
// define our input/output link names
inputname 0 lnk_db_xfm_po_part_dimension;
outputname 0 lnk_xfm_ds_po_part_dimension;
initialize {
// define our row rejected variable
int8 RowRejected0;
// define our null set variable
int8 NullSetVar0;
// declare our intermediate variables for this section
string InterVar0_0;
string InterVar0_1;
string InterVar0_2;
// initialise constant values which require conversion
InterVar0_0 = "1845561";
InterVar0_1 = "*";
InterVar0_2 = "";
}
mainloop {
// initialise our row rejected variable
RowRejected0 = 1;
// evaluate constraint and columns for link: lnk_xfm_ds_po_part_dimension
if ((trimc_string(lnk_db_xfm_po_part_dimension.ID_PART) == InterVar0_0))
{
lnk_xfm_ds_po_part_dimension.NM_PART = replace_substring(InterVar0_1 , InterVar0_2 , lnk_db_xfm_po_part_dimension.NM_PART);
writerecord 0;
RowRejected0 = 0;
}
}
finish {
}
Property value cannot contain UniVerse mark characters.
Property name is: Derivation
Invalid data is : Convert("
","",lnk_db_xfm_po_part_dimension.NM_PART)
Will replace with: Convert("*","",lnk_db_xfm_po_part_dimension.NM_PART)
Property value cannot contain UniVerse mark characters.
Property name is: ParsedDerivation
Invalid data is : Convert("
", "", lnk_db_xfm_po_part_dimension.NM_PART)
Will replace with: Convert("*", "", lnk_db_xfm_po_part_dimension.NM_PART)
Can anyone please suggest me how to achieve this.
Thanks in advance
I have a requirement to convert one special character("") to empty (Need to drop this character when encountered).The sequence of keys to generate the special character is:CTRL + Shift +6.
I have used the convert function as
Convert("","",lnk_db_xfm_po_part_dimension.NM_PART).
But the transformer is throwing a compilation error
Property value cannot contain UniVerse mark characters.
Property name is: Value
Invalid data is : //
// Generated file to implement the V0S17_CopyOfCopyOfDRD5558_ex_OTO_XFM_PO_PART_DIMENSION transform operator.
//
// define our input/output link names
inputname 0 lnk_db_xfm_po_part_dimension;
outputname 0 lnk_xfm_ds_po_part_dimension;
initialize {
// define our row rejected variable
int8 RowRejected0;
// define our null set variable
int8 NullSetVar0;
// declare our intermediate variables for this section
string InterVar0_0;
string InterVar0_1;
string InterVar0_2;
// initialise constant values which require conversion
InterVar0_0 = "1845561";
InterVar0_1 = "
";
InterVar0_2 = "";
}
mainloop {
// initialise our row rejected variable
RowRejected0 = 1;
// evaluate constraint and columns for link: lnk_xfm_ds_po_part_dimension
if ((trimc_string(lnk_db_xfm_po_part_dimension.ID_PART) == InterVar0_0))
{
lnk_xfm_ds_po_part_dimension.NM_PART = replace_substring(InterVar0_1 , InterVar0_2 , lnk_db_xfm_po_part_dimension.NM_PART);
writerecord 0;
RowRejected0 = 0;
}
}
finish {
}
Will replace with: //
// Generated file to implement the V0S17_CopyOfCopyOfDRD5558_ex_OTO_XFM_PO_PART_DIMENSION transform operator.
//
// define our input/output link names
inputname 0 lnk_db_xfm_po_part_dimension;
outputname 0 lnk_xfm_ds_po_part_dimension;
initialize {
// define our row rejected variable
int8 RowRejected0;
// define our null set variable
int8 NullSetVar0;
// declare our intermediate variables for this section
string InterVar0_0;
string InterVar0_1;
string InterVar0_2;
// initialise constant values which require conversion
InterVar0_0 = "1845561";
InterVar0_1 = "*";
InterVar0_2 = "";
}
mainloop {
// initialise our row rejected variable
RowRejected0 = 1;
// evaluate constraint and columns for link: lnk_xfm_ds_po_part_dimension
if ((trimc_string(lnk_db_xfm_po_part_dimension.ID_PART) == InterVar0_0))
{
lnk_xfm_ds_po_part_dimension.NM_PART = replace_substring(InterVar0_1 , InterVar0_2 , lnk_db_xfm_po_part_dimension.NM_PART);
writerecord 0;
RowRejected0 = 0;
}
}
finish {
}
Property value cannot contain UniVerse mark characters.
Property name is: Derivation
Invalid data is : Convert("
","",lnk_db_xfm_po_part_dimension.NM_PART)
Will replace with: Convert("*","",lnk_db_xfm_po_part_dimension.NM_PART)
Property value cannot contain UniVerse mark characters.
Property name is: ParsedDerivation
Invalid data is : Convert("
", "", lnk_db_xfm_po_part_dimension.NM_PART)
Will replace with: Convert("*", "", lnk_db_xfm_po_part_dimension.NM_PART)
Can anyone please suggest me how to achieve this.
Thanks in advance