| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Can anybody give me some info. on extracting data from a focus file
to be used in DECalc? Can a hold file be used with delimiters?
Has anybody tried this?
Thanks Dave
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 129.1 | FOCUS may already have the utility | AKOV88::SHEPRO | Good enough for Gov't Work | Thu Sep 15 1988 11:29 | 5 |
My wife, who uses FOCUS on a PC, says there is a utility that will
extract FOCUS data into a LOTUS 1-2-3 format. If this utility exists
on the VMS version, from there, you can convert the 1-2-3 file to
DeCalc with XWAY. There are no provisions, though, to convert from
1-2-3 back to FOCUS.
| |||||
| 129.2 | 5.2 lotus hold option | ILO::MCKNIGHT | Michael Mcknight 890-2516 IRM,Mervue,Ireland | Thu Sep 15 1988 13:25 | 7 |
Hello, In FOCUS 5.2 there is an ON TABLE HOLD FORMAT LOTUS option. Rgds Michael | |||||
| 129.3 | FORMAT LOTUS | THRILL::WILS | Joris Wils | Tue Aug 08 1989 13:30 | 14 |
You can directly put a FOCUS extract into a format readable by DECcalc
( and most other spreadsheets) by doing a
TABLE FILE FOOBAR
ON TABLE HOLD AS FILENAME FORMAT LOTUS
END
This creates a comma-separated file with strings encapsulated in
quotes.
(Foc manual 5.2 ch 9.1 "The HOLD File")
Joris
| |||||