Skip to Content
0
Former Member
Oct 07, 2014 at 08:27 AM

Dealing with empty spaces in field name in Header Column of Excel sheet

963 Views

Dear all,

I am developed a custom adapter module to convert .xls file to xml file and its working fine as shown below.

Input File 1

Outout file 1

But my requirement is... In the .xls input file, in header fields they are sepaated by a space like "Job Req Id". In PI we dont have a provision to use spaces in name of field tags. So i have taken thedata type field name as JobReqId. Now when i test the scenario the result is as follows:

Actual Input

Actual error output

So please let me know how to deal with the space in header column field of excel (.xls) file

Regards

Koti Reddy

Attachments

in1.JPG (33.1 kB)
out1.JPG (27.5 kB)
in2.JPG (33.4 kB)
out2.JPG (37.1 kB)