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!

  • Congratulations Chris Miller 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

Technical User
Jun 30, 2011
69
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top