Normal Topic Exporting in Sesame (Read 524 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Exporting in Sesame
May 27th, 2004 at 3:10pm
Print Post Print Post  
Hi

I want to export but with a carriage return as file separater.
Does anyone has an answer for this one?

I just want to have a ASCII - file like in Q&A with a carriage return ( each field in one line).
Using the File I/O functions to create the export file
What must i tipe as Code for the carriage return @CR ? or..

Thanks.

Dr. A. Belhareth
« Last Edit: May 28th, 2004 at 3:55pm by Amor »  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Exporting in Sesame
Reply #1 - May 27th, 2004 at 3:37pm
Print Post Print Post  
Your best bet for this is probably to use the File I/O functions to create your export file exactly as you want it. You should be aware that anything you might want to import into is likely to have trouble with a carriage return as a field separator, instead of a record separator.

What did you plan to use for a record separator?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Justin_ICC
Junior Member
**
Offline



Posts: 95
Joined: Feb 5th, 2004
Re: Exporting in Sesame
Reply #2 - May 27th, 2004 at 3:58pm
Print Post Print Post  
You would have to do this using SBasic programming. I haven't personally done exporting using sbasic but its very similar to any other programming language.

E.g.
var vFileHandle as Int
var vFieldDelim as String

vFieldDelim = @Newline();
vFileHandle = fileOpen("Destfile.txt");
if vFileHandle >= 0
{
    FileWrite(vFileHandle,Field1+vFieldDelim+Field2+vFieldDelim+...);
}
FileClose(vFileHandle);

  
Back to top
 
IP Logged