[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] (no subject)
- Subject: RE: [sqr-users] (no subject)
- From: "the dragon" <ceprn@hotmail.com>
- Date: Wed, 10 Jan 2007 05:57:57 -0600
- Bcc:
- Delivery-date: Wed, 10 Jan 2007 07:01:26 -0500
- In-reply-to: <741585.91139.qm@web50901.mail.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
You can read any type of file, I believe, but whether the data will be in a
type of input to be usable, that's the real question. Or more bluntly, you
can, but you don't want to.
this is what the inside of an rtf file looks like in a text editor...
{\rtf1\ansi\ansicpg1252\uc1
\deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose
02020603050405020304}Times New Roman;}{\f6\fmodern\fcharset0\fprq1{\*\panose
00000000000000000000}Courier;}
{\f45\fswiss\fcharset0\fprq2{\*\panose 020b0a04020102020204}Arial
Black;}{\f69\froman\fcharset238\fprq2 Times New Roman
CE;}{\f70\froman\fcharset204\fprq2 Times New Roman
Cyr;}{\f72\froman\fcharset161\fprq2 Times New Roman Greek;}
{\f73\froman\fcharset162\fprq2 Times New Roman
Tur;}{\f74\froman\fcharset177\fprq2 Times New Roman
(Hebrew);}{\f75\froman\fcharset178\fprq2 Times New Roman
(Arabic);}{\f76\froman\fcharset186\fprq2 Times New Roman Baltic;}
{\f429\fswiss\fcharset238\fprq2 Arial Black
CE;}{\f430\fswiss\fcharset204\fprq2 Arial Black
Cyr;}{\f432\fswiss\fcharset161\fprq2 Arial Black
Greek;}{\f433\fswiss\fcharset162\fprq2 Arial Black
Tur;}{\f436\fswiss\fcharset186\fprq2 Arial Black Baltic;}}
{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;
\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\ql
\li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0
\fs20\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \snext0
Normal;}{\*\cs10 \additive Default Paragraph Font;}}{\info{\title
test}{\author Clark 'the dragon' Willis}{\operator Clark 'the dragon'
Willis}{\creatim\yr2007\mo1\dy10\hr5\min49}
{\revtim\yr2007\mo1\dy10\hr5\min50}{\version1}{\edmins1}{\nofpages1}{\nofwords0}{\nofchars0}{\*\company
Dragon Enterprises}{\nofcharsws0}{\vern8269}}
\widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dghspace180\dgvspace180\dghorigin1701\dgvorigin1984\dghshow0\dgvshow0\jexpand\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\nolnhtadjtbl
\fet0\sectd
\linex0\endnhere\sectdefaultcl
{\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta
.}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta
.}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4
\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta
)}}{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta
)}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta
)}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}
{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb
(}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb
(}{\pntxta )}}\pard\plain \ql
\li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0
\fs20\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {test\tab test
\par }{\f6 test
\par
\par }{\f45 test
\par
\par }{\f45\fs36 test
\par }\pard \ql
\li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0
{\f45\fs36
\par }}
As you vcan see, there is a lot of formatting crap, because rtf stands for
rich text format. I believe it was designed to allow word documents to be
imported and exported between word editors before companies started
providing APIs. (http://en.wikipedia.org/wiki/Rtf)
(http://en.wikipedia.org/wiki/API)
The words you're looking for are "test". If you want to put in coding to
wade through all the extraneous stuff, have fun, but it seems like a waste
of time to me - have the file created as .txt, or .csv or something that
would be considered a "flat" file.
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.
I work to live; I don't live to work.
"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you." -- Carl Sandburg (1878 - 1967)
It is impossible to defeat an ignorant man in argument. -- William G. McAdoo
Religion is regarded by the common people as true, by the wise as false, and
by the rulers as useful. -- Seneca
----Original Message Follows----
Does anyone know if reading RTF file allowed in SQR V. 6.0?
_________________________________________________________________
Get FREE Web site and company branded e-mail from Microsoft Office Live
http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users