Is there a way to reformat text currently in column format to horizontal. For example I have data such as:
Denver
Dallas
New Orleans
Baton Rouge
Seattle
I would like to re-format the data to:
Denver, Dallas, New Orleans, Baton Rouge, Seattle
Thank you in advance
Thanks for the responses, the example data is just an example. The data is actually an ldf file and I am trying to prepare the file for import, so the data is constantly changing.
Is there a way to insert a vbCrLf and a hyphen in a text file using VBScript?
The text file is formatted as the following:
SampleData: Data
SampleData2: Data2
MoreSampelData::
qwerrttyuiopassddffgjdjdjdjshjfjkhdhfjd
qwerrttyuiopassddffgjdjdjdjshjfjkhdhfjd...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.