Thank you for your post.
After performing a browser search for "DBF file format", I was able to locate the DBT file structure at:
I do not see any reason why that character appears every 62 to 65 characters. Since each block of memo text is 512 bytes, I cannot see a reason why there is a strange character every 62 to 65 characters.
Different lines of text are separated by carriage return and line feed which was common for MS-DOS. In Windows and Mac OS, different lines of text are separated solely by a carriage return, so this is what may cause the double-spacing.
I don't see anything in the file structure to signify loss of a dash.
Does anyone else have experience with the DBF/DBT file structure and can shed some light?
Does Lotus Approach export to any other file format?
I would like to see your DBF and associated DBT file so I can send it to our Development and Software Quality Assurance (Testing) departments for review. I have sent you a private message (top of this page - right side - X Messages) with instructions where to send the files.
Thank you for sending in your files.
I opened the DBT with a text editing program, and I definitely see the character at the end of each line. I am assuming you copied and pasted this information from Word, as this is the character used to wrap to the next line.
Try typing this information into Approach and export and then exporting. Either that, or make sure the Gettysburg address is saved as Text, and you use a text editing program to copy the information into Approach. Then again, size the field larger in Approach, and see if the character moves to a different location.
I can only get that character to display if I use import on a Mac, since that option is not available on Windows. In fact, although the Macintosh format is displayed on a Mac, when I temporarily select "MS-DOS" format, I can no longer reselect "Macintosh" format. That is because the DBF file format is a MS-DOS format. However, even when MS-DOS format selected, the strange character is simply translated to another strange character.