How to Handle Apostrophe (') In Message Shape

ScenarioPut a flat file in message shape and the data includes Apostrophe ('). Flat file profile is removing the apostrophe before loading the data.

Solution

Message shape interprets characters differently. There are 2 ways to fix this issue.

1. Use a disk connector to retrieve file instead of using message shape. 2. Within message shape, add another apostrophe (') after the existing one. For example, if the original data is [ya'll], you will need to change it to [ya''ll].