Text File Export

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jlassell
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

Text File Export

Post by jlassell » Mon Nov 22, 2004 10:22 am

(Using xBase 8.1)____Is there a way to export a multi-line RECORD band using the "Text Data File" option and force a CRLF for each line? Currently, I my result is that the entire band is exported to 1 line.____I am using conditional line prints as well because each data line isn^t in the same format.____I am aware of the ^non-pagination^ option in v10+ for "Text" export. I am looking for a solution that uses v8.1.____Thanks very much,__-Jeff

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Text File Export

Post by kfleming » Tue Nov 23, 2004 7:02 am

If you export to text rather than text data you have the choice of whether CR will be done once per line or once per band.____Kathleen__R&R Support

jlassell
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Text File Export

Post by jlassell » Tue Nov 23, 2004 3:39 pm

Thanks Kathleen. ____I^m aware of the Text File option. I would like to know if I can do this (or use a clever trick) on Text data file exports.

jlassell
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Text File Export

Post by jlassell » Tue Nov 30, 2004 5:59 pm

Is there a bug in xBase v10+ build 10.1.003 in the "Text Data File" Export?____I am doing an export of a GF Band. __If the band has 2 lines with the 2nd line using a conditional line print (which basically causes the line not to print), I only get the very first line exported (ie, 1 exported record). __If I delete the 2nd line, the one with the conditional line print) then I get the correct number of records exported.____=======================================__For example,__5GF field1 field2 field3__5GF? field4 field5 "the ? causes this line not to print"__(the above only exported the very first record,)____5GF field1 field2 field3__(this way the export works fine)__=======================================____It appears that a multi-line band with a conditional line print doesn^t export correctly.____Thanks for your help,__-Jeff

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: Text File Export

Post by kfleming » Wed Dec 01, 2004 4:36 pm

Can you use a query in place of a conditional line to cause the export to behave?____Kathleen__R&R Support

jlassell
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: Text File Export

Post by jlassell » Wed Dec 01, 2004 4:44 pm

A query controls the entire RECORD band, and I^m trying to control only 1 line of a 2-line band. I don^t see how a query would do that.__Are you saying that you can^t use a conditional line in a TEXT DATA FILE export?__I am also trying to resolve the issue mentioned in the previous part of this post.____Thanks again,__-Jeff

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

======> RE: Text File Export

Post by kfleming » Thu Dec 02, 2004 1:58 pm

Conditional lines can cause problems for export.__Another alternative would be to make each field on the layout a conditional field.____Kathleen__R&R Support

Post Reply