 Carriage return in exported text file |
|
Welcome Guest ( Log In | Register ) · View New Posts · View Unanswered Topics
  |
 Mar 17 2007, 10:29 AM
Post
#1
|
|
|
New Member Posts: 3  |
Novice Access user. I have a long report of 200 lines and 30 to 40 characters each line, pulled from a complex query. When I export it to a text file for a required transmission there are unwanted carriage returns in the text file. I do not use the Wizard and it cannot be and is not a delimited or fixed length file. Would appreciate some help.
|
 |
 
|
|
Mar 17 2007, 10:53 AM
Post
#2
|
|
 UtterAccess VIP Posts: 4,767 From: Upstate NY, USA |
So you're just right clicking the query and selecting export?
Are there also carriage returns that are wanted? -------------------- Just because you are a character doesn't mean that you have character.
|
|
|
|
|
Mar 17 2007, 11:31 AM
Post
#3
|
|
|
New Member Posts: 3 |
I run my report. It looks fine. Go to file. Click export. Save as type. Click text file. Open the text file and there are carriage returns every 5 to 6 lines. There are no carriage returns appearing in the report before it is exported to the text file.
|
|
|
|
|
Mar 17 2007, 04:26 PM
Post
#4
|
|
|
UtterAccess Editor Posts: 15,580 From: Sydney, AUSTRALIA |
Try exporting the data from the Source Query instead of the Report ...
-------------------- Van T. Dinh
|
|
|
|
|
Mar 17 2007, 08:38 PM
Post
#5
|
|
|
New Member Posts: 3 |
I can not send directly from the query. The Report massages the data into a flat file just the way the EDI recipient wants it. That is except for the emply lines caused by the unwanted carriage returns.
|
|
|
|
|
Mar 17 2007, 10:16 PM
Post
#6
|
|
|
UtterAccess Editor Posts: 15,580 From: Sydney, AUSTRALIA |
If your data can be massaged in the Report, it should be possible to massage the same data in a Query.
Perhaps you should post a sample copy of the database with the Report you want to output and see if anyone can massage the data using a Query ... -------------------- Van T. Dinh
|
|
|
|
|
May 3 2007, 08:54 AM
Post
#7
|
|
|
UtterAccess Veteran Posts: 441 From: Omaha, NE |
Did you ever get this resolved? I'm having the exact same problem.
|
|
|
|
|
|
Lo-Fi Version | Time is now: 30th July 2010 - 11:21 AM |