• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

TEXT FILE

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
mkramer777
Asked:
mkramer777
  • 2
1 Solution
 
Michel PlungjanIT ExpertCommented:
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
 
mkramer777Author Commented:
It is Viewpoint Construction software.
0
 
Michel PlungjanIT ExpertCommented:
I have no access to that software.

Perhaps you should ask here

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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now