Exporting data from GRev using Porter (AREV Specific)
At 30 AUG 1999 03:48:55PM Michelle Bull wrote:
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.
At 30 AUG 1999 05:07PM Richard Wilson wrote:
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
At 31 AUG 1999 02:30PM Michelle Bull wrote:
Richard – Thanks for the info. What is the CHAR(9) that you include in your formula?
At 31 AUG 1999 03:13PM Richard Wilson wrote:
CHAR(9) is the TAB character. excel likes them along with most other packages you might import into