insert a backspace character in a wrapped around line in MS Word 2

[Hamp]

I would like to insert a backspace at the start of a wrap around line to form
one line out of 2 in a database in Word which I will later import into Excel

 

[Jezebel]

This makes no sense. Are you trying to delete the linebreak?

 

[hp]

reply to Jezebel:
These are database records with ideally all fields on one line with the
source being a unix file converted to a text file with Kermit to pc utility.
The date on each record and a charge amount is wrapped around to a 2nd line.
By backspacing on the first chararcter of the 2nd line the paragraph symbol
at the end of the first line is deleted and the entire 2nd line will append
to the first line. This ends up with all fields on one line in each record. I
can't search and delete paragraph symbols as there would be a continuous line
not separated records. Also there is a paragraph symbol at the end of the 2nd
line which would also be chosen by a find command. The other complicating
factor is that not all records in this database have a wrap around line with
a date and a charge amount.
ho

 

[Jezebel]

That doesn't explain what you're trying to do with the backspace character.

You can use Find and replace to insert ^008 within your line, but it won't
help you -- reading the text into the database isn't going to "backspace" at
that point: it will simply take the backspace character as a literal
character. You'll still have multi-line input.

Better is to format your text properly for whatever the input process
requires. Usually, this means replacing the paragraph marks with the field
delimiter character.

 

[Helmut Weber]

Hi hp,

whatever database you use, if you export data in text-format,
you will very likely get as many field delimiters as there are fields.
If, very unlikely, there is no record delimiter, but only
field delimiters, then the last field delimiter would serve
as record delimiter as well. If you have e.g. 8 fields,
delimited by chr$(13), you have to replace every first 7
chr$(13) by whatever you like, and keep every 8th chr(13).

By the way, with Word in mind, you are talking about paragraphs
rather than about lines. So the question in terms of Word
would be, how to transform 8 consecutive paragraphs into
1 paragraph throughout a document, the number of
paragraphs of which is a multiple of 8.

HTH

Greetings from Bavaria, Germany

Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org