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)
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