Solved

TEXT FILE

Posted on 2013-06-13
3
208 Views
Last Modified: 2013-07-03
I have a text file that I export from our accounting system.  I export it as a tab delimited file.  I can tell it to set page breaks or if I type in a 999 on the report parameters it will not do page breaks.  I think it says truncate beside this field where I type in 999.  If I do not type in 999 I have to remove a symbol at each page break for this to work for me to import into another program.  The file knows what the last page is.  If I type in 999 then it adds a bunch of what I think is blank lines.  If I only have 900 lines then it will export blank lines all the way to 999.  I need to do something to the text file to stop this at the end of the data.
0
Comment
Question by:mkramer777
  • 2
3 Comments
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 39246625
We of course need to know what your accounting system is, if it is for example excel, you likely have a VBA Macro in there we would need to look at.

Once we know what system it is and can look at some code, we can also change the topic to the correct zone.
0
 

Author Comment

by:mkramer777
ID: 39247446
It is Viewpoint Construction software.
0
 
LVL 75

Accepted Solution

by:
Michel Plungjan earned 500 total points
ID: 39247487
I have no access to that software.

Perhaps you should ask here

http://www.viewpointcs.com/Community.aspx
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is Python programming? 3 122
Export Table to CSV - Access to CSV - using python 18 170
T-SQL:  Sigh---Boy, this is fun.... 12 57
Difference between List and Array in Python 5 94
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question