[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Exporting data from GRev using Porter (AREV Specific) ====
=== At 30 AUG 1999 03:48:55PM Michelle Bull wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I'm trying to extract data from a GRev system, using the Porter product, and running into two problems.

1)Null fields are not identified at all; i.e., if a field has no data in it, I don't get anything for that field, not even a delimiter. This really screws up the columns when imported to Excel.

2)Some of the fields I'm trying to export are multi-line (not multi-value) fields, and I don't know how to put the lines together into one long string.

Is there another product I can use besides Porter?  Or is there a way around these problems within Porter?  Thanks.


</QUOTE>
----

=== At 30 AUG 1999 05:07PM Richard Wilson wrote:  ===

<QUOTE>when ever I want to do a quick & dirty and not fiddle with porter I just create a symbolic dict item and send it to disk using pdisk

assume fields f0,f1,f2,f3,f4

 

@ANS={F0}:CHAR(9):{F1}:CHAR(9):{F2):CHAR(9):{F3}:CHAR(9):{F4)

 

and then just do a list with lptr. note you may need to oconv some

items it they are date or dollars or whatever

 

Note: I dont use porter and developed my own delim'd download routine which I can use on other pick-like platforms

</QUOTE>

----

=== At 31 AUG 1999 02:30PM Michelle Bull wrote:  ===

<QUOTE>Richard  --  Thanks for the info.  What is the CHAR(9) that you include in your formula?

</QUOTE>

----

=== At 31 AUG 1999 03:13PM Richard Wilson wrote:  ===

<QUOTE>CHAR(9) is the TAB character. excel likes them along with most other packages you might import into

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=06718E6AE541ED57852567DD006CD987|View this thread on the  forum...]]