TIBCO Cloud ™ Integration - Connect Using Special Characters in a Text File as Source
book
Article ID: KB0075032
calendar_today
Updated On:
Products
Versions
TIBCO Cloud Integration - Connect ( Scribe )
-
Description
Note: TIBCO Scribe® Online has been rebranded as Connect within TIBCO Cloud Integration. For a period of time, both products will be available as subscriptions are renewed on the TIBCO Cloud platform. This article refers to both products.
Issue Description: When using a Text File As Source connection in TIBCO Cloud ™ Integration - Connect you may need to use a .CSV file as the source which contains special characters such as ™ and ®. When previewing the data or when attempting to insert these special characters into the target you may receive an error or see the ™ and ® appear as a ? as Connect (Scribe) is having a difficult time working with the values. This can happen if the file encoding and the Text File As Source connection encoding are different.
Environment
TIBCO Cloud ™ Integration - Connect
Resolution
Resolution: In order to use the ™ and ® characters in Connect (Scribe) you will need to specify the same file encoding in the text file connection that is being used in your CSV file.
In the Text file connection on the Entities Tab specify which File Encoding to use. By default we set this value to UTF8. If a specified type of encoding is selected to be used in the CSV file, you must ensure the same value is used in the connector.
If you did not specify a type of encoding to be used in the CSV file then you may need to re-save the file and specify the proper encoding.
For example: You have a Excel file that you saved as the default .csv file type. In Connect (Scribe) we set up a Text File as Source Connection using UTF8 encoding. When previewing the data from a query block of the Text File As Source connection the Special characters show up as a "?". In this case the original csv file will need to be saved again in Excel with the proper encoding. In Excel, perform a Save as, then on the file type selection drop down choose CSV UTF-8 (Comma delimited) (*.cs) and replace the old csv file with the new one. In TIBCO Cloud ™ Integration - Connect refresh the metadata for the Text File As Source connection and preview the records. We should now see the ™ and ® characters displayed correctly.
Issue/Introduction
When using special characters such as ™ and ® in a TIBCO Scribe® Text File as Source connection, you need to specify the same file encoding in the text file connection that is being used in your CSV file.