Solved

I need help adding a line terminator in my VB6 application

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

A short article about a problem I had getting the GPS LocationListener working.
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.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

813 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

16 Experts available now in Live!

Get 1:1 Help Now