Re: Export text from tabbed field
Thanks to Eric, Robert, Andu, Phil and Richard for your replies. Your replies all seem to confirm that the columns originating from the tab stops will not be maintained when read to a file without much customizing and extra scripting. So without putting too much energy into it, I have found a solution, which is not 100% satisfactory, but it will do for me. The output file will be read by various teachers on various platforms, so there is no way to change their Word settings and I would not want to ask them to change font to a monofont either. My data in the scrolling field can be exemplified as: Date Code Student name Score Jan 02 11:30 3A1.1 Anne Lund Pedersen 37 % Jan 02 09:30 11D1.12 Randi Holt 8 % Jan 02 10:37 3A1.1 Arve Pedersen 17 % Jan 02 11:31 11D1.12 Anne Holt-Rasmussen 98 % Particularly 'Student name' will vary in length whereas 'Date' is fixed since it is read from a server. 'Code' will vary from 5 to 7 characters, so I add 2 extra spaces at the end of each code. Originally I used both1 and 2 digits for 'Score' (1,299), but at least I can add 0 in front of 1 to 9. Then as a last change in my data I place 'Score' in front of 'Student name'. What you write about not being able to change their Word settings in not quite true. If you use the RTF format for distribution instead of tabbed text, you can define the custom tab settings to be in effect when the file is opened in Word or another word processing program. These settings are file specific. I have tried changing the text to rtfText before writing it out as a RTF file to no avail. How do you define these settings in MC? I would appreciate more details. Thanks in advance. -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutttel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe Marie Sanne wrote: Your replies all seem to confirm that the columns originating from the tab stops will not be maintained when read to a file without much customizing and extra scripting. I'm quite certain I missed something: if your data contains ASCII 9, why is that not evident in the other programs you read the data with? Hello Richard, I have tested same type of data in a new stack, and there are still problems with the tab stops in the Word file. But in order to answer your question the scenario is as follows: Students do exercises. A result file for each exercise is uploaded to a server. The name of the file contains all the essential data: code (for which test has been taken), student name, score (for instance "4B2.2#Pettersen Anne#53"). A MC stack (on the various teachers' computers) takes care of reading the content of the folder on the server, manipulates the data (for instance with MactoIso or vice versa depending on which platform the teacher works on) and sorts the content of the data into columns. So far the data looks fine. Then there is a button with "Print out to paper" and that's where the problems arise. -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutttel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Thanks to Eric, Robert, Andu, Phil and Richard for your replies. Your replies all seem to confirm that the columns originating from the tab stops will not be maintained when read to a file without much customizing and extra scripting. So without putting too much energy into it, I have found a solution, which is not 100% satisfactory, but it will do for me. The output file will be read by various teachers on various platforms, so there is no way to change their Word settings and I would not want to ask them to change font to a monofont either. My data in the scrolling field can be exemplified as: Date Code Student name Score Jan 02 11:30 3A1.1 Anne Lund Pedersen 37 % Jan 02 09:30 11D1.12 Randi Holt 8 % Jan 02 10:37 3A1.1 Arve Pedersen 17 % Jan 02 11:31 11D1.12 Anne Holt-Rasmussen 98 % Particularly 'Student name' will vary in length whereas 'Date' is fixed since it is read from a server. 'Code' will vary from 5 to 7 characters, so I add 2 extra spaces at the end of each code. Originally I used both1 and 2 digits for 'Score' (1,299), but at least I can add 0 in front of 1 to 9. Then as a last change in my data I place 'Score' in front of 'Student name'. What you write about not being able to change their Word settings in not quite true. If you use the RTF format for distribution instead of tabbed text, you can define the custom tab settings to be in effect when the file is opened in Word or another word processing program. These settings are file specific. In your case, producing an RTF file is quite simple. Robert Brenstein ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe Marie Sanne wrote: > Your replies all seem to confirm that the columns originating from the tab > stops will not be maintained when read to a file without much customizing and > extra scripting. I'm quite certain I missed something: if your data contains ASCII 9, why is that not evident in the other programs you read the data with? -- Richard Gaskin Fourth World Media Corporation Developer of WebMerge 2.1: Publish any database on any site ___ [EMAIL PROTECTED] http://www.FourthWorld.com Tel: 323-225-3717 AIM: FourthWorldInc ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Title: Re: Export text from tabbed field Signe You will have to translate the fld's text before export, inserting the correct number spaces ( based on length of the text in ea. column & the tab stops of the fld.) To display correctly, such that text aligns according to tabs, the text will need to be set to a mono font such as Monaco on Mac or Courier New on PC. Thanks to Eric, Robert, Andu, Phil and Richard for your replies. Your replies all seem to confirm that the columns originating from the tab stops will not be maintained when read to a file without much customizing and extra scripting. So without putting too much energy into it, I have found a solution, which is not 100% satisfactory, but it will do for me. The output file will be read by various teachers on various platforms, so there is no way to change their Word settings and I would not want to ask them to change font to a monofont either. My data in the scrolling field can be exemplified as: Date Code Student name Score Jan 02 11:30 3A1.1 Anne Lund Pedersen 37 % Jan 02 09:30 11D1.12 Randi Holt 8 % Jan 02 10:37 3A1.1 Arve Pedersen 17 % Jan 02 11:31 11D1.12 Anne Holt-Rasmussen 98 % Particularly 'Student name' will vary in length whereas 'Date' is fixed since it is read from a server. 'Code' will vary from 5 to 7 characters, so I add 2 extra spaces at the end of each code. Originally I used both1 and 2 digits for 'Score' (1,299), but at least I can add 0 in front of 1 to 9. Then as a last change in my data I place 'Score' in front of 'Student name'. Thanks again for all suggestions. -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutt tel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway
Re: Export text from tabbed field
- Original Message - From: "Robert Brenstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 5:26 AM Subject: Re: Export text from tabbed field > >>Signe Marie Sanne wrote: > >> > >>> Is it possible to export a field with fixed tab stops to a text file > >>> with the tab stops being maintained in the file? I have used: put fld > >>> 1 into url tUrl. > >> > >>Try: > >> > >> put fld 1 into url ("file:"&tUrl) > > > >Thanks for the prompt reply. > >I already had "file" implemented in the path (just omitted it in my > >posting). The text file (both in Word and plain text) shows tabs, > >but instead of being placed in a fixed place, the tabs all seem to > >just introduce a certain number of spaces where the tab stops are, > >but since the text in each column varies, the original columns in > >the fields are not maintained. Other clues? > > > > That is normal. A tab is simply a character that says > hop-to-the-next-tab-stop. What that means is dependent on the program > opening the file. Word by default has typewriter tabs > (evenly-spaced). If you select the text and set custom tabs, then you > get the columnar alignment that you seem to expect, although it may > still may not work as you expect if some text is long enough that > requires wrapping. In that case, you can use the convert text to > table tool which will use tabs to break each line into cells of a > table. If you need a completely automated solution, it's probably possible to get the tabstops of your field, convert them to Word tab positions (this would require knowledge of Word's tab positioning scheme), and put the new tab position info into a VBA script that you create in Rev; then save the VBA script as a file, and run it from within Word. It could open your text file and apply the info to the tab bar of your file. At least it seems possible on a conceptual level, especially since I'm not the one struggling with it! ;o) I do hope you find something that works adequately. Phil Davis > > Robert > ___ > metacard mailing list > [EMAIL PROTECTED] > http://lists.runrev.com/mailman/listinfo/metacard ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe You will have to translate the fld's text before export, inserting the correct number spaces ( based on length of the text in ea. column & the tab stops of the fld.) To display correctly, such that text aligns according to tabs, the text will need to be set to a mono font such as Monaco on Mac or Courier New on PC. Eric Thinker Toys,Inc. ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe Marie Sanne wrote: > I already had "file" implemented in the path (just omitted it in my posting). > The text file (both in Word and plain text) shows tabs, but instead of being > placed in a fixed place, the tabs all seem to just introduce a certain number > of spaces where the tab stops are, but since the text in each column varies, > the original columns in the fields are not maintained. Other clues? Sounds more like a problem with the reading of the file than the writing of it then. You might try "binfile" instead of "file" to make exta sure no translation is being done by Rev. -- Richard Gaskin Fourth World Media Corporation Developer of WebMerge 2.1: Publish any database on any site ___ [EMAIL PROTECTED] http://www.FourthWorld.com Tel: 323-225-3717 AIM: FourthWorldInc ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe Marie Sanne wrote: Is it possible to export a field with fixed tab stops to a text file with the tab stops being maintained in the file? I have used: put fld 1 into url tUrl. Try: put fld 1 into url ("file:"&tUrl) Thanks for the prompt reply. I already had "file" implemented in the path (just omitted it in my posting). The text file (both in Word and plain text) shows tabs, but instead of being placed in a fixed place, the tabs all seem to just introduce a certain number of spaces where the tab stops are, but since the text in each column varies, the original columns in the fields are not maintained. Other clues? That is normal. A tab is simply a character that says hop-to-the-next-tab-stop. What that means is dependent on the program opening the file. Word by default has typewriter tabs (evenly-spaced). If you select the text and set custom tabs, then you get the columnar alignment that you seem to expect, although it may still may not work as you expect if some text is long enough that requires wrapping. In that case, you can use the convert text to table tool which will use tabs to break each line into cells of a table. Robert ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
--On Friday, January 03, 2003 13:27:26 +0100 Signe Marie Sanne <[EMAIL PROTECTED]> wrote: MC 2.5B1 - buildnumber 3 - MacOS 9.2, Windows 2000 Happy new year to all from Norway Is it possible to export a field with fixed tab stops to a text file with the tab stops being maintained in the file? You can save the tabs but not the graphical representation of the stops, there is no such character as a tabstop. You could write a converter to html tables and save that if that's what you're looking for. I have used: put fld 1 into url tUrl. I have as well tried the stack "Print field" but the paper print shows the same negative result. -- Try printing the card with the field, it should show the tabstops. Unfortunately, I forgot to say that it is a scrolling field, so that won't do. -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutttel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Title: Re: Export text from tabbed field Signe Marie Sanne wrote: > Is it possible to export a field with fixed tab stops to a text file > with the tab stops being maintained in the file? I have used: put fld > 1 into url tUrl. Try: put fld 1 into url ("file:"&tUrl) Thanks for the prompt reply. I already had "file" implemented in the path (just omitted it in my posting). The text file (both in Word and plain text) shows tabs, but instead of being placed in a fixed place, the tabs all seem to just introduce a certain number of spaces where the tab stops are, but since the text in each column varies, the original columns in the fields are not maintained. Other clues? -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutt tel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway
Re: Export text from tabbed field
--On Friday, January 03, 2003 13:27:26 +0100 Signe Marie Sanne <[EMAIL PROTECTED]> wrote: MC 2.5B1 - buildnumber 3 - MacOS 9.2, Windows 2000 Happy new year to all from Norway Is it possible to export a field with fixed tab stops to a text file with the tab stops being maintained in the file? You can save the tabs but not the graphical representation of the stops, there is no such character as a tabstop. You could write a converter to html tables and save that if that's what you're looking for. I have used: put fld 1 into url tUrl. I have as well tried the stack "Print field" but the paper print shows the same negative result. -- Try printing the card with the field, it should show the tabstops. 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutttel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard Regards, Andu Novac ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Re: Export text from tabbed field
Signe Marie Sanne wrote: > Is it possible to export a field with fixed tab stops to a text file > with the tab stops being maintained in the file? I have used: put fld > 1 into url tUrl. Try: put fld 1 into url ("file:"&tUrl) -- Richard Gaskin Fourth World Media Corporation Developer of WebMerge 2.1: Publish any database on any site ___ [EMAIL PROTECTED] http://www.FourthWorld.com Tel: 323-225-3717 AIM: FourthWorldInc ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
Export text from tabbed field
MC 2.5B1 - buildnumber 3 - MacOS 9.2, Windows 2000 Happy new year to all from Norway Is it possible to export a field with fixed tab stops to a text file with the tab stops being maintained in the file? I have used: put fld 1 into url tUrl. I have as well tried the stack "Print field" but the paper print shows the same negative result. -- 1. amanuensis Signe Marie Sanne e-mail: [EMAIL PROTECTED] Romansk Institutttel: +47 55 58 21 27 Oysteins gt. 1 5007 Bergen http://www.hf.uib.no/hfolk/mlab/hjem/default.html Norway ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard