How to Handle Apostrophe (') In Message Shape

Document created by sheng_liao462475 Employee on Nov 10, 2016
Version 1Show Document
  • View in full screen mode

Scenario
Put 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].

2 people found this helpful

Attachments

    Outcomes