Macro Help
 

I have an export format coming over from my hand help device that is coming
over in .csv when i open it up in excel my format is as follows:
date,time,value,shift
date, time,value,shift
date,time,value,shift
date,time value shift

How i need it to come over is this way:
date,time,value,shift[]date,time,value,shift[],date,time,value,shift.......

The[]is the CRLF how can i set the above format up running an excel macro?

Macro Help
 

So what is the current line separator?
That is, what are you replacing with CrLf ?

--
Tim Williams
Palo Alto, CA


"LMI" wrote in message
...
I have an export format coming over from my hand help device that is
coming
over in .csv when i open it up in excel my format is as follows:
date,time,value,shift
date, time,value,shift
date,time,value,shift
date,time value shift

How i need it to come over is this way:

date,time,value,shift[]date,time,value,shift[],date,time,value,shift.......

The[]is the CRLF how can i set the above format up running an excel macro?

Macro Help
 

Or did you mean you want to replace CrLf with the literal string "[]" ?

just read the contents of the file into a variable and use

var2=Replace(var1,vbcrlf,"[]")

Tim


"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
So what is the current line separator?
That is, what are you replacing with CrLf ?

--
Tim Williams
Palo Alto, CA


"LMI" wrote in message
...
I have an export format coming over from my hand help device that is
coming
over in .csv when i open it up in excel my format is as follows:
date,time,value,shift
date, time,value,shift
date,time,value,shift
date,time value shift

How i need it to come over is this way:

date,time,value,shift[]date,time,value,shift[],date,time,value,shift.......

The[]is the CRLF how can i set the above format up running an excel
macro?