dbTalk Databases Forums  

Are SDF & ASCII same?

comp.databases comp.databases


Discuss Are SDF & ASCII same? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rachana
 
Posts: n/a

Default Are SDF & ASCII same? - 04-02-2008 , 02:34 PM






HI,

I know generation of SDF files.
Sequential data without delimitors, zero padding etc.

Now, I have to generate ascii file with extension "txt" and delimitor
^

Each record must end with new line character. Hex values "0D" and
"0A". What does it mean?

Are SDF & ASCII same?

Thanks,
Regards,
Rachana


Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-02-2008 , 03:33 PM






On Apr 2, 3:34 pm, Rachana <mbs.rach... (AT) gmail (DOT) com> wrote:
Quote:
HI,

I know generation of SDF files.
Sequential data without delimitors, zero padding etc.

Now, I have to generate ascii file with extension "txt" and delimitor
^

Each record must end with new line character. Hex values "0D" and
"0A". What does it mean?

Are SDF & ASCII same?

Thanks,
Regards,
Rachana
SDF as you said refers to the file format. So it is comparable to CSV
(Comma Separated Values) format
ASCII is the character coding.
I can easily imagine an SDF file using EBCDIC

If this is in a requirement specification for your project I suggest
you ask the author of that document to clarify. But IF they specify
the end-of-line is terminated by x0d0a, then it sure looks like it
MIGHT be ASCII. In EBCDIC x0d is carriage return just like ASCII but
line feed is x0a in ASCII while line feed is x15 in EBCDIC.

So finally to answer your question directly SDF and ASCII are NOT the
same.
Ed


Reply With Quote
  #3  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-02-2008 , 03:33 PM



On Apr 2, 3:34 pm, Rachana <mbs.rach... (AT) gmail (DOT) com> wrote:
Quote:
HI,

I know generation of SDF files.
Sequential data without delimitors, zero padding etc.

Now, I have to generate ascii file with extension "txt" and delimitor
^

Each record must end with new line character. Hex values "0D" and
"0A". What does it mean?

Are SDF & ASCII same?

Thanks,
Regards,
Rachana
SDF as you said refers to the file format. So it is comparable to CSV
(Comma Separated Values) format
ASCII is the character coding.
I can easily imagine an SDF file using EBCDIC

If this is in a requirement specification for your project I suggest
you ask the author of that document to clarify. But IF they specify
the end-of-line is terminated by x0d0a, then it sure looks like it
MIGHT be ASCII. In EBCDIC x0d is carriage return just like ASCII but
line feed is x0a in ASCII while line feed is x15 in EBCDIC.

So finally to answer your question directly SDF and ASCII are NOT the
same.
Ed


Reply With Quote
  #4  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-02-2008 , 03:33 PM



On Apr 2, 3:34 pm, Rachana <mbs.rach... (AT) gmail (DOT) com> wrote:
Quote:
HI,

I know generation of SDF files.
Sequential data without delimitors, zero padding etc.

Now, I have to generate ascii file with extension "txt" and delimitor
^

Each record must end with new line character. Hex values "0D" and
"0A". What does it mean?

Are SDF & ASCII same?

Thanks,
Regards,
Rachana
SDF as you said refers to the file format. So it is comparable to CSV
(Comma Separated Values) format
ASCII is the character coding.
I can easily imagine an SDF file using EBCDIC

If this is in a requirement specification for your project I suggest
you ask the author of that document to clarify. But IF they specify
the end-of-line is terminated by x0d0a, then it sure looks like it
MIGHT be ASCII. In EBCDIC x0d is carriage return just like ASCII but
line feed is x0a in ASCII while line feed is x15 in EBCDIC.

So finally to answer your question directly SDF and ASCII are NOT the
same.
Ed


Reply With Quote
  #5  
Old   
Ken North
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-05-2008 , 02:04 PM



SDF (System Data Format) is a format that came into common use when PCs
expanded the community of computer and software users. ASCII was the
'native' format for those early personal computers based on 8-bit and
16-bit microcomputers.

SDF files were commonly used for importing and exporting data between
applications, such as Lotus 1-2-3 and desktop database apps (Btrieve,
Xtrieve). The SDF file format is one record per line, with fields
delimited by commas. Text values are enclosed in "". Field ordering in
each record must be consistent. Two commas in a row indicate a field
value is null. Files in that format often used the .SDF extension.

For a file in that format today, many products use the term
comma-delimited or CSV (comma-separated values). Some products support a
CSV format that includes metadata (field names) in the first record
(first line) of a file.






Reply With Quote
  #6  
Old   
Ken North
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-05-2008 , 02:04 PM



SDF (System Data Format) is a format that came into common use when PCs
expanded the community of computer and software users. ASCII was the
'native' format for those early personal computers based on 8-bit and
16-bit microcomputers.

SDF files were commonly used for importing and exporting data between
applications, such as Lotus 1-2-3 and desktop database apps (Btrieve,
Xtrieve). The SDF file format is one record per line, with fields
delimited by commas. Text values are enclosed in "". Field ordering in
each record must be consistent. Two commas in a row indicate a field
value is null. Files in that format often used the .SDF extension.

For a file in that format today, many products use the term
comma-delimited or CSV (comma-separated values). Some products support a
CSV format that includes metadata (field names) in the first record
(first line) of a file.






Reply With Quote
  #7  
Old   
Ken North
 
Posts: n/a

Default Re: Are SDF & ASCII same? - 04-05-2008 , 02:04 PM



SDF (System Data Format) is a format that came into common use when PCs
expanded the community of computer and software users. ASCII was the
'native' format for those early personal computers based on 8-bit and
16-bit microcomputers.

SDF files were commonly used for importing and exporting data between
applications, such as Lotus 1-2-3 and desktop database apps (Btrieve,
Xtrieve). The SDF file format is one record per line, with fields
delimited by commas. Text values are enclosed in "". Field ordering in
each record must be consistent. Two commas in a row indicate a field
value is null. Files in that format often used the .SDF extension.

For a file in that format today, many products use the term
comma-delimited or CSV (comma-separated values). Some products support a
CSV format that includes metadata (field names) in the first record
(first line) of a file.






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.