Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text File Export - Truncating record line

Status
Not open for further replies.

ldalessio

Programmer
Apr 16, 2008
23
US
Morning All.
I have set up an automatic download from crystal to a text file that needs to run every night. The problem is that the record line is being truncated. I have played around with exort settings with no luck. Any thoughts? Below is a sample of a record I am exporting.
Thank you all for your help.

This is what it looks like in Crystal:
"1169999","lastname","firstname","","123 main st","","nowhere","NY","","19999","","8455000","01 ","09","100"," ","A","05/12/1998"

This is what is looks like as a .txt file:
"1169999","lastname","firstname","","123 main st","","nowhere","NY","","19999","","8455000","01 ","09",
 
Usually if you're getting truncated you need to increase the Characters Per Inch.
 
Thanks a bunch Carliy. That worked perfectly. To be honest, I was decreasing the the characters per inch, thinking smaller was better. Duh.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top