on 12-14-2010 2:12 PM
Hi,
I would like to confirm whether my understanding is right.
Is it necessary to have a field separator in a fixed length file?
If yes, how different is that comparing a normal CSV file
Fixed Length:
Say my field lengths are 3,3,5 with comma as a separator
so the file would be
001,abc,12345
If i go for a normal CSV file then the file would be
1,abc,12345
Is this the only difference where the fixed length must have all the characters irrespective of whether the field separator is space or comma,
I would like to understand the difference and need of having a field separator in a fixed length compared to csv.
Regards
Krish
Hi,
Just go through this link. It will help you for sure.
http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/technology/sap/79/
Thanks
Veeru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in a field separator, fields are identified based on the separator.
ex. aaa,bbb,ccc here there are three fields separated by a comma
in case of fixedfieldlengths, the field length are fixed.
ex. if the fixedfieldlength is 3,3,3 and the string is aaabbbcc then aaa is one field, bbb and ccc other fields
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
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.