Adding Comma To End Of Line & Concatenating Lines

WeaponX

Aug 14 2005, 12:37 PM

I have a huge word document that I want to be able to add a comma to the end of each line and then concatenate the whole document together. For example:

test
testing 1
test 23 4

I want that to be something like:

test,testing 1,test 23 4

I tried doing this using a macro (not very good at), but couldn't get them to come out right. Basically I want to make sure that each line connects to the previous one followed by a comma at the end. My document so far has over 4,300 lines now and growing.

Any VBA experts out there or does anyone else know of an easier way to do this?

Thanks.

Comment/Reply (w/o sign-up)

calixt

Aug 14 2005, 04:48 PM

QUOTE (WeaponX @ Aug 14 2005, 02:37 PM)

I have a huge word document that I want to be able to add a comma to the end of each line and then concatenate the whole document together. For example:

WeaponX,
have you tried replacing paragraphs with commas using Edit->Replace?
To search for a paragraph mark, write "^p" into the input field
(at least, it's like that in my German Word-version).
Calixt

Comment/Reply (w/o sign-up)

WeaponX

Aug 14 2005, 05:18 PM

Thanks Calixt, I never thought of that before. That will connect all of those lines together? How about the commas? Any easy way to do this? So far, I'm just creating two macros:

1. One is to add a comma to the end of a line.
2. The second one is basically mimicking what I did with #1 above except I'm running it through a few pages of lines first.

Then I save the second macro and run the second macro many times so it gets to the very end.

Comment/Reply (w/o sign-up)

WeaponX

Aug 20 2005, 05:45 PM

Is there a program that will allow me to have one HUGE line without any limits? I have thousands of lines of text in a Word document and I used the replacement method for paragraphs and that did part of the work. But I still have a lot of lines leftover. I want them ALL to be in one very lone single line only. Word seems to limit this and I tried using other text editors and they were about the same (still have many lines leftover).

Comment/Reply (w/o sign-up)

calixt

Sep 5 2005, 11:11 PM

QUOTE (WeaponX @ Aug 20 2005, 07:45 PM)

Is there a program that will allow me to have one HUGE line without any limits? I have thousands of lines of text in a Word document and I used the replacement method for paragraphs and that did part of the work. But I still have a lot of lines leftover. I want them ALL to be in one very lone single line only. Word seems to limit this and I tried using other text editors and they were about the same (still have many lines leftover).

WeaponX,
I am not sure but the reason for your "leftovers" may be that not every line-break is a "paragraph". I understand that the replacement method works well but covers not all the line-breaks in your documents. Maybe there are some "manual line breaks" in your docs which do not have the field code "^p" but "^l".
A nice list of field codes you will find at http://chiron.valdosta.edu/wbfredenberger/edit.htm.

Comment/Reply (w/o sign-up)

(G)Ankit Jain

Jun 1 2009, 03:43 AM

search for ^p and replace it with blank space and comma. For manual line breaks, replace ^l with blank space and comma