Solved

I need help adding a line terminator in my VB6 application

Posted on 2014-01-09
1
290 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

920 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

12 Experts available now in Live!

Get 1:1 Help Now