Solved

file manipulation

Posted on 2000-02-17
12
160 Views
Last Modified: 2010-05-02
i need to take the trailing empty line from a text file...how do i do this?

also, how do you write to a text file without writing an end of line character?
0
Comment
Question by:Sesh
  • 3
  • 3
  • 2
  • +3
12 Comments
 
LVL 3

Expert Comment

by:paulstamp
Comment Utility
Tried using the Trim$ function to remove blanks ?
0
 
LVL 12

Expert Comment

by:roverm
Comment Utility
Tried the Open statement yet ?

Open "inputfile" For Input As #1
Open "outputfile" For Output As #2

Input #1, strReadLine
'do some stuff
Print #2, strReadLine

Close #1
Close #2

When you read the input file you won't see the end-of-line char !

Good luck !

RoverM
0
 

Author Comment

by:Sesh
Comment Utility
my problem actually arises from the inability to output a line without it creating an eoln at the end.

for example,
print %1,"hello"

would make the file like so:
--------beginning of file--------
hello(EOLN)
(EOF)
-----------end of file-------------

but i want it to read:
--------beginning of file--------
hello(EOF)
-----------end of file-------------
0
 
LVL 12

Expert Comment

by:roverm
Comment Utility
If you are writing AND reading the file why don't you add an 'END-CHAR' ?
When you read it again, YOU know that you can ignore the last character !

Another way: Instead of writing blanks (spaces) why don't you write Chr(0) a couple of times ?

RoverM
0
 
LVL 1

Expert Comment

by:macu
Comment Utility
Just do:

Open "FileName" For Output As #X
Print #X, "Data";

The ; is the important part.
0
 
LVL 3

Expert Comment

by:Michelt
Comment Utility
Have You tried to open the File as Binary, then read through the String to remove all the EOF Characters !
and Save it to a New File !


0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 54

Expert Comment

by:nico5038
Comment Utility
Sesh,

A DOS-text file contains normally two bytes to indicate the end of a line:
CarriageReturn and LineFeed. (CR / LF)
With the print statement these are inserted automatically.
When a file only contains LF's (normal for UNIX) it's seen by Notepad as one long string, however Wordpad shows it on different lines!.

To create a file yourself with control about the endofline character(s) you should follow Michelt advice to open the file as Binary and write the full lines with a concatenated vbCRLF variable at the end and "forget it" for the last one.

0
 

Author Comment

by:Sesh
Comment Utility
hmmm... interesting..

does that:
print #X, data ;  take off the cr/lf from the print?? i havent got the dev studio at this moment (not at home at the moment), so cant test it...

i ended up doing a byte - by - byte get() and put() and testing for multiple eoln s, but would much rather use that print thingy
0
 
LVL 1

Accepted Solution

by:
macu earned 100 total points
Comment Utility
Using the ; allows you to write something to a file and not move to a new line, so that more data can be added on the same line. It does work, very simple!
0
 

Author Comment

by:Sesh
Comment Utility
ill take your word on it... thanx a lot!
0
 
LVL 1

Expert Comment

by:macu
Comment Utility
No problem.
0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
Sesh,

It does not take off the CR/LF, but it prevents the placement of it, as the ";" means 'more information has to be added to this string'
The only disadvantage can be that you end up with a string that's too long!
(Check the max string length of your VB version)
That's also why I advised to use the binary file type. Thus no length limit will appear!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now