on 01-14-2014 10:03 AM
Hi Experts,
I am Working on Flat file to proxy.Here am getting an CSV file and need to delete the comma.
File structure is :
Bus_123,12344,09877890,1,michigan,1990-09-01 06:06:11, , , 1221
If there is any missing field I have to skip it and move to next line.
What are the FCC Parameters need to be use.
Thanks,
Shaik
Hi ,
As per my understanding if any of the record (line) contains empty value then you need to skip that record (line)
Read the file using normal fcc parameters ,with "," as the field separator and 'nl as endseperator
Below is the sap documentation for sender side fcc for your ref.
https://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
In mapping implement the logic to skip the record(line) if any of the field value is empty.
We can achieve this using simple udf .
Regards
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkat,
As you said it is comma delimiter and when ever there is no line it has to skip to the next line.I think in FCC there is no parameter like that to skip the line.And if it is going on reading the empty value also it is time consuming process.Can you tell me is there any logic we can give in FCC Parameter side.
Or else can we explain me in UDF.
Thanks,
Shaik
Hi Ricardo,
Thanks for the prompt reply.I have to give fixed length value detials also .How can I define it.
Thanks,
Shaik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shaik,
<node>.fieldFixedLengths – comma-separated ordered list of field lengths in the particular node
Example:
<node>.fieldFixedLengths = 10,2,5
So you are separating the next value of XML tag by 10 chars, 2 chars, 5 chars
Example of csv:
1234567890,br,oiuyt
But you need be sure that this "size" will not modifed with time or you will have problems, I recomend you get values based on "comma, / or ; ".
Check this link:
http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/
Regards,
Hi,
File should be either delimiter separated or fixed length file in order to process....
Both cannot be accommodated in the same file. As you already mentioned its a csv file which means its a comma separated file (delimiter here is comma) and don't understand why its going to be a fixed length for fields...when already comma is used...
Both cannot be handled in single file....PI Engine fail to process FCC parameters during file reading in that case.
HTH
Rajesh
Hi Shaik,
Check this link below:
http://saptechnical.com/Tutorials/XI/Contentconversion/page2.htm
You must use the file content conversion, and the delimited of field by field will be "comma".
Kind regards,
BR.
Ricardo Viana.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.