NAB the TAB (File Adapter)


SAP PI Interview Questions and SAP PI Tutorials

SAP PI Interview Questions and SAP PI Tutorials

NAB the TAB (File Adapter)

“The biggest cause of trouble in the world today is that the stupid people are so sure about things and the intelligent folks are so full of doubts.”Bertrand Russell

So let’s try and clear all doubts and make things sure on the TAB delimited file and hence process them with the file adapter. I hope this blog will prove helpful for all those forum posts on the same.

A TAB delimited file has its fields separated by a TAB. The following screenshot is of a TAB delimited file.

image

SAP PI Interview Questions and SAP PI Tutorials

SAP PI Interview Questions and SAP PI Tutorials

How do you read such a file using the file adapter?

Suppose we have our data type as follows:

image

Assuming that all other parameters for the sender file adapter has been provided we just focus on the content conversion for the same.

The hexadecimal notation for the TAB is 0x90.

Note:

The hyperlinks http://www.scit.wlv.ac.uk/cbook/chap1.Codes.html & http://www.cplusplus.com/doc/papers/ascii.html will help us to find the hexadecimal notation for a lot of escape sequences and printable/nonprintable characters.

So we can specify the (substructure).fieldSeparator as ‘0x09’.

image

Another way to accomplish the same (but a tricky one) is described below.

Open the notepad and press the TAB button once. Copy the space generated and paste it in the content conversion. The following screenshot will throw more light on the same.

To copy the space gererated by the TAB key :

image

Paste it into the content conversion parameters:

image

Amazingly this trick works too :-).

Hope this blog helps in answering the queries related to the TAB delimited file in the forums.

NAB the TAB (File Adapter)

SAP PI Interview Questions and SAP PI Tutorials

SAP PI Interview Questions and SAP PI Tutorials

Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter
en.pdf24.org    Send article as PDF   
This entry was posted in sap pi training, sap pi tutorials, sap xi jobs, sap xi training, SAP XI Tutorials. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *