Convert Special Characters to Any Other Char

Convert Special Characters to Any Other Char:DK®

1.Using this logic we can convert special characters to any other characters.
2.Untranslatable character handling
3.Remove new line characters from source data

Logic need to implement in transformer :DK®

1. If you want to convert new line character CHAR(10) and vertical Tab Char(11) to space then you can below mentioned column level derivation in your job.


Convert(char(10):char(11),' ',InputLink.ColumnName)


Refer this chart to get the CHAR NUM based on your requirement.


No comments:

Post a Comment