Solved

I need help adding a line terminator in my VB6 application

Posted on 2014-01-09
1
295 Views
Last Modified: 2014-04-17
Hi Experts,
I am building a .csv file from an Array in my vb6 application.  The client has asked me to add a Line Terminator of Carriage Return, Line Feed (CRLF) to each row.  How can I do this?

Here is sample of how I create my rows of data as I loop through my Array:
 
strRecord = strRecord & "," & Trim$(Replace(tempRow.Extract(28, 1, 1), ",", "''"))


How do I add the CRLF terminator to this?  Thanks in Advance.
mrotor
0
Comment
Question by:mainrotor
1 Comment
 
LVL 10

Accepted Solution

by:
acbxyz earned 500 total points
ID: 39768644
There is a special constant vbCRLF
strRecord = strRecord & "," & Trim$(Replace(tempRow.Extract(28, 1, 1), ",", "''")) & vbCRLF
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

680 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