Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AKV0524
Contributor III
Contributor III

can we convert the ITF (Interchange Text Format) to regular text in Qlik Replicate

can we convert the ITF (Interchange Text Format) to regular text in Qlik Replicate

Labels (1)
2 Replies
Heinvandenheuvel
Specialist III
Specialist III

Are you talking about " The format ITF (Interchange Text Format) is a SAPscript format for storing and displaying SAPscript texts. This format consists of all characters that can be displayed on the screen (system character set) Before outputting a text, the SAPscript composer must first convert the ITF format to OTF format (Output Text Format), using the layout definitions of the allocated style and form."  ???

Seems like someone ingested too much 'cool-aid'

Replicate does NOT know how to do this 'out of the box'. If the input column is available a simple text, then maybe a User Defined Transformation function can be created, using lots of SAP hard core programming skills to do this.

Hein

john_wang
Support
Support

Hello @AKV0524 ,

I'd like to add a more common explanation besides @Heinvandenheuvel  expert point of view: The Replicate File endpoint can be used either as source or as a target. For your scenario, the text format output on the target side is fine. When File is used as a source, the File endpoint requires the source files to be in delimited text file format includes:
1- CSV: Comma Separated Values
2- TSV: Tab Separated Values
3- Any other format if it's available by an ODBC Driver. For example, "Microsoft Access Text Driver" can be used to access the Fixed Format File as source.
Detailed information can be found in the File Endpoint General overview.

Hope this helps.

Regards,
John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!