topic Re: reading the csv file form application server in Application Development and Automation Discussions

reading the csv file form application server

Former Member — Wed, 30 Sep 2009 15:26:09 GMT

hi...

i am reading the csv file from application server. my file contains last field "profit center' whose basically values for testing purpose is PC .

As i read the file , the # is appended at the end of field value ( i.e PC# ).

Now i m using the BAPI "BAPI_PROJECT_MAINTAIN' for creating and updating the project definition and wbs element.

But while doing that , the system is showing the error with profit center field like ( 1000 / PC profit center does not exist )

So , i m unable to understand that from where this 1000 gets added to this profit center field value.

if any body understand this issue.....then plz give me the suitable answer....

hope of replies.....

Former Member — Fri, 02 Oct 2009 11:46:08 GMT

Hi,

Try to open the file IN LEGACY TEXT MODE. This looks like a ansi to unicode conversion problem.

-Simo

Former Member — Fri, 02 Oct 2009 11:55:17 GMT

donot worry. # comes has horizontal tab.

after getting the profit center, search for the # and replace it with ''.

replace all occurrences of '#' in field1 with ''.