reading the csv file form application server

[Former Member]

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]

Hi,

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

-Simo

[Former Member]

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 ''.