on 2005 Nov 29 6:37 AM
Hi gurus,
I have a problem in Netvalue KF..., when i am trying to upload data from flat file which resides in application server.., i have 3 KF related to price..., i have the data like the following...,
1stKF 2nd KF 3rd KF
-
-
-
837,23 9834,75 8376,098
8373.234 8765,32 73653,789
so here because of ' , ' my loading is terminated . but in PSA some records are showing error because of this.
i tried to rectify it manually in PSA, but there is lot of records there... so i am planning to write a routine
in transfer rules for all these 3 keyfigures for getting valid value like 837,23 to 83723.
so how would i achieve this...? anyone can help me out & send coding for eliminating , and returning remaining values same...,
waiting for ur inputs plz.........
Regards
Swetha
Hi Swetha,
As Roberto said make "," as your decimal separator and "." as your thousand separator. I guess ""(space) would be your Data separator.
Try this and let us know.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you have FTP access then you can donwload it your PC, Change the format and then upload it back.
Otherwise you would have to do it as AHP suggested or write an ABAP routine.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Swetha,
i think no need to write routine,
what's you flat file type/format ? csv ? what's the Data Separator -> comma ?
check settings in your infopackage >> tab 'external data'
- file type, data separator
- Separator for Thousand
- Character Used for Decimal
try to click 'preview' to check data validity.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear dinesh & A.H.P,
thankx for ur suggestions.
yes i'm using .csv file..., so no need of writting code you mean...
But dear dinesh my file is in application server.., so i am don't have permissions to change it....
can you tell me is there any another way of maintaining it....
i will check & update you...,
Regards
Swetha
Message was edited by: swetha saxena
Hi Swetha,
I guess you are using ".csv" format. You can change the format of the column for the key figures in the flatfile itself. This way you need not invest any time for writing any code.
Just select the KF column in "Excel" -> right click -> format cells -> and choose the correct format.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.