Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parsing file and add carriage return

Status
Not open for further replies.
elly00

elly00

Technical User
Jun 30, 2011
69
0
0
IT
Hi
I have a txt file that is all in a single line, with a " ' " as separator
Is it possibile using vbs to read this file and copy or modify it with carriage return after the " ' " ?

Thanks
 
Sort by date Sort by votes
You could simply do something like
Code: 
newTxt = Replace(txt, "'", "'" & Chr(13) & Chr(10))


"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rick_Stanich
  • Locked
  • Question
Save xls file to cvs file 1
Replies
3
Views
103
Rick_Stanich
Rick_Stanich
Palito1916
  • Locked
  • Question
Disable multiple computer accounts using TXT file with computer names
Replies
2
Views
93
Palito1916
Palito1916
paullem
  • Locked
  • Question
vbscript to read properties of JPEG file
Replies
4
Views
139
paullem
paullem
PiotrMP006
  • Locked
  • Question
How to quickly check if a file has 1 or more lines of text?
Replies
1
Views
99
combo
combo
Katto
  • Locked
  • Question
Paste picture from clipboard into aslide of an opened powerpoint file
Replies
0
Views
63
Katto
Katto

Part and Inventory Search

Sponsor

Back
Top