In principle that's correct, as long as # and $ do not appear in your data
and you use Word's text file converter to get the data.
However, you will also get problems if there are any double-quote characters
in your data and they are not being used as the "text delimiter", i.e. to
surround complete fields, and there may be other similar issues.
I would be inclined to wrap up every field that might contain #,$," or enter
in double-quotes and double up any double-quotes in the data. I don't think
it will make much difference which field and record delimiters you use after
that and comma and enter will probably be fine.
e.g. instead of
ID#name#address$1#us#11 "The Maltings"
in the middle of the street
ourtown$
try
ID,name,address
1,"us","11 """The Maltings""
in the middle of the street
ourtown"
etc.
Are there any other output format options that you can choose in the
Progress Repoert Builder (whatever that may be) ?
Peter Jamieson
> Hi
> I'm trying to import a text file created using the Progress Report
[quoted text clipped - 7 lines]
>
> Any help please.
Steve - 15 Feb 2007 14:30 GMT
Thanks for that. I've realised what it is now. Each record can have
a random number of lines in the text file, anything from 10 to 30. So
if the first record in the text file contains 30 records, any
subsequent record with less than that number of records produces the
'record n contained too few data fields' errors.
So the first record in my text file will have to be a dummy record
with the maximum number of possible lines and merging to a new
document means that I will get this error for each record in the text
file. As there might be up to 1,000 record in this file, does anyone
know how to turn this message off?
On 14 Feb, 17:43, "Peter Jamieson" <p...@KillmapSpjjnet.demon.co.uk>
wrote:
> In principle that's correct, as long as # and $ do not appear in your data
> and you use Word's text file converter to get the data.
[quoted text clipped - 38 lines]
>
> - Show quoted text -
Peter Jamieson - 15 Feb 2007 14:55 GMT
Do you still see this problem if you enclose your multiline fields in double
quotes? And can you do that?
Peter Jamieson
> Thanks for that. I've realised what it is now. Each record can have
> a random number of lines in the text file, anything from 10 to 30. So
[quoted text clipped - 57 lines]
>>
>> - Show quoted text -