Import Text File Questions
-
- Posts: 29
- Joined: Tue Oct 10, 2017 12:44 pm
Import Text File Questions
Kathleen,____I am attempting to use the Import Text File function and I have a problem and some questions, all related.____1) When printing a plain .txt file with CRLF at the end of every line, R&R ignores them and wraps at will. I have selected "pc" and "ANSI" and there is no difference in behaviour.____the on-line help says:__"If you are using an Xbase memo editor (for example, the dBASE III or IV editor) to create/edit a table memo field, indicate where you want line endings to occur in your memo text by placing a carriage return at the end of each line. Report Designer maintains these line endings when it formats the memo field."____This is not what I see. Is this referring to a "soft" or "hard" carriage return. The text uses hard CRLF combo and was created using any normal editor, like EDIT, Word, saved as text, etc.____I have a sneaky suspicion that that you are not treating this as a memo field, but a text field and may be telling me that we need to enter a <r> at the end of every line...That will not please me as we have 100^s of these that must be done if that^s the case.______2) Assuming issue #1 can be resolved, is there some way I can pass the name of the text file to the report at runtime?? It could be any one of several files depending on which user is doing the printing for which Boss who wants his/her own tweak.____I know I can do this by setting up temporary databases, but that^s ugly. ____3) if all else above fails, I suppose I can write another dll to transfer the lines back within the 8000 byte limit. If I pad this with spaces, will RR automagically trim it? or must i do it manually in my function?____BTW, it would be nice to be able to import an RTF into a region for purposes like this. Any thoughts or plans for this kind of capability? Version 10 maybe?____Thanks____-Steve____
=> RE: Import Text File Questions
Sorry to report that it is the <r>^s..__You could however put text into a database memo field and link that table to the report to get memo field behavior.____At runtime you can use the RI_MEMO field to specify the name/location for the text file used in the report.____So it is not all bad news.____Kathleen__R&R Support