Using special characters with the TIBCO Scribe® Online Connector For Scribe Labs — Excel
Article ID: KB0074713
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.
Note: TIBCO Scribe® Online Labs Connectors are offered on an as-is basis and TIBCO does not offer formal support or guarantees for these Connectors.
Issue Description: When using the TIBCO Scribe® Online Connector For Scribe Labs — Excel as a 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 ® or others. 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 ?. This can happen if the file encoding and the CSV File being used in the connection different encoding.
Note: TIBCO Scribe® Online Labs Connectors are offered on an as-is basis and TIBCO does not offer formal support or guarantees for these Connectors.
Issue Description: When using the TIBCO Scribe® Online Connector For Scribe Labs — Excel as a 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 ® or others. 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 ?. This can happen if the file encoding and the CSV File being used in the connection different encoding.
Issue/Introduction
Explains how to make special characters visible in Connect (Scribe) in order to use them successfully
Resolution
In order to use the ™ and ® characters in TIBCO Cloud Integration - Connect you will need to specify the file encoding when saving the CSV file in Excel. Connect (Scribe) uses UTF8 encoding as default.
If you did not specify a type of encoding to be used in the CSV file when saving, then you may need to re-save the file and specify the proper encoding.
For example: You have an Excel file that you saved as the default .csv file type. In TIBCO Cloud Integration - Connect, when previewing the data from a query block of the Scribe Labs - Excel 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) (*.csv) and replace the old CSV file with the new one. In TIBCO Cloud Integration - Connect, refresh the metadata for the Scribe Labs - Excel connection and preview the records. You should now see the ™ and ® characters displayed correctly.
If you did not specify a type of encoding to be used in the CSV file when saving, then you may need to re-save the file and specify the proper encoding.
For example: You have an Excel file that you saved as the default .csv file type. In TIBCO Cloud Integration - Connect, when previewing the data from a query block of the Scribe Labs - Excel 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) (*.csv) and replace the old CSV file with the new one. In TIBCO Cloud Integration - Connect, refresh the metadata for the Scribe Labs - Excel connection and preview the records. You should now see the ™ and ® characters displayed correctly.
Feedback
Yes
No
Powered by
