| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
