2006 Jan 30 3:38 PM
Hi ALL
What is the Difference between Tab delimited Format and Fixed Langth Format
It's very urgent
plz any one can give answer for this
Regards...
Hi ALL
What is the Difference between Tab delimited Format and Fixed Langth Format
It's very urgent
plz any one can give answer for this
Regards...
2006 Jan 30 3:43 PM
Hi,
For Tab delimited format there is a TAB SPACE between
two fields.In fixed length format there is no such
space between two fields.
EX:
IF field1 and FIELD2 are two fields of 6char the
below gives an idea.
field in TAB delimited format
FIELD1 FIELD2 (Even if FIELD1 is of 100 char length
it will look as above)
field in fixed length format
FIELD1FIELD2
Regards,
GSR.
2006 Jan 30 3:43 PM
If u use the TAB option between field values ==> its Tab delimited format.
Fixed length==>define manually and split according to that
2006 Jan 30 3:48 PM
Hi,
if it is Tab delimited format then you need use split at
tab. since tab will appear as '#'. so splitting can be done some thing like this..
split at cl_abap_char_utilities=>horizontal_tab ...
but fixed length you need use offset and proceed.
regards
vijay
2006 Jan 30 3:50 PM
Hi Chinna,
Tab delimited - Fields are separated by tab space.
Fixed length : Fields should be placed in fixed length.
for example
Tab delimited with 3 fields each of length 5.
yyyyy xxxxx zzzzz
Fixed length file format will be
yyyyyxxxxxzzzzz
Hope this helps.
Close the thread and reward points ,if your query is resolved.
Regards,
Sudheer
2006 Jan 30 3:56 PM
Hi Sudheer,
I am appreciate u r answer
but 1) if there is no data for particular filed plz tell me the format
2) If the length of the field is changed then what will be happend ie if length is 5 char suppose if they give 3 char or 6 char what will be happend please clarify
we are expecting good light from you
warm regards
2006 Jan 30 4:19 PM
If there is no data for a particular field in
Fixed length (say 5 chars)
AAAAA CCCCC ( It will be empty, as in the middle)
In Tab delimited format
AAAAA CCCCC(there will be a TAB delimiter)
If U have other than 5 char length(in this case) then
In fixed length format
AAAAABBB CCCCC ( will be given like this) If it exceeds
5 chars , the other chars will fill the next field.
In Tab delimited
AAAAABBB CCCCC(same as above)