Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Formating a Text file

Comment:

Hi, I have a Text file where I have a big data base of Client details. Details are stored in the file in the following way. ~<Client Details>~ ~<Client Details> and so on. So, every details starts with "~" and ends with "~". Now I want to break it in new line when a new client details is starting. I mean intead of this :: ~<Client Details>~ ~<Client Details>~ I want it in this format :: ~<Client Details>~ ~<Client Details>~ So, is it possible to format it with a Batch file. Though I can paste it in MS-Word and if you prefer a Macro them I will also take that. Waiting for your kind response.

Name: Jennifer SUMN
Date: June 17, 2008 at 07:26:29 Pacific

Reply:

Would opening it in Word and using the Find/Replace option help? Life's more painless for the brainless.

0

Power Point Help

Excel Macro

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I am having a problem with a text file that I am trying to import into Access. The file is on a CD from one of our vendors that we load into a mainframe. I am trying to take this data and put it ...

Summary: Hello Everyone, I need to export a cell range that a user specifies to a text file delimited by a coma. They may select for example two columns, and x number of rows and run a macro that will export o...

Summary: Hi, Are all the workbooks identical in structure, number of worksheets, worksheet names and the addresses of cells to be formatted? How do you specify what formatting is to be applied? Is the formatti...