importing data from txt file with carriage return in one text fiel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have upgraded from office 2000 to 2003. Since the upgrade I can no
longer import my textfile into Excel or Outlook, because any carriage return
in a text field (text is marked with "", fields are separated with ;) will be
recognized as end of line / paragraph mark, consequently all following fields
are in the wrong order.

Does anyone know the trick to train the import function not to look for
carriage return marks in text fields?

Thank you!
 
Hi, I have upgraded from office 2000 to 2003. Since the upgrade I can no
longer import my textfile into Excel or Outlook, because any carriage return
in a text field (text is marked with "", fields are separated with ;) will be
recognized as end of line / paragraph mark, consequently all following fields
are in the wrong order.

Does anyone know the trick to train the import function not to look for
carriage return marks in text fields?
Click to expand...

You could remove the <CR> s from the text file. Would that do the job ?

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Thank you for the suggestion, Bruce. Unfortunately this will disrupt the
content of the text field and information would get lost.

Does someone have another idea?
 
Back
Top