Double-byte to Single-byte string/character conversion

naveed.zuber · Post by **naveed.zuber** » Thu Nov 06, 2014 7:20 am

Please suggest a way to convert double-byte string to single byte string in DataStage.
This conversion is required to match the data with the existing data in DB2

Ex:
ＢＭＷ(Double byte string) to BMW(Signle byte string)

Source is CSV file
DataStage version 8.7
DB2
Unix

Please let us know in case of any questions.

priyadarshikunal · Post by **priyadarshikunal** » Thu Nov 06, 2014 7:30 am

you can try using convert function to replace these characters to ASCII. You will have to identify all such characters and put it in convert function.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 06, 2014 3:52 pm

Note that the majority of double-byte characters cannot be mapped to single-byte. There are just too many of the former.

If you are certain that all of the characters from source can be validly mapped then, yes, it is possible to do so.

Probably the easiest method is to specify Unicode extended property on the link connecting to source, then use a string_from_ustring() mapping in a Modify stage (or UstringToString() function in a Transformer stage).