Hello,
I thought I had made progress using:
CPYTOIMPF FROMFILE(&INFPS) TOSTMF(&OUTFPS) +
MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +
RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM(*NONE)
But this only worked on a physical file with DDS definition.
I am using a single record file of 2000 char, this did not work.
This is a portion of the file.
0,0,0,995,0,0,=(""),=("") ,=(""),=("")
170,0,0,=(""),=("") ,=(""),=("")
0,0,1082,0,0,=(""),=("") ,=(""),=("")
0,0,0,0,1170,0,0,=(""),=("") ,=(""),=("")
0,1082,0,0,=(""),=("") ,=(""),=("")
082,0,0,=(""),=("") ,=(""),=("")
1170,0,0,=(""),=("") ,=(""),=("")
995,0,0,=(""),=("") ,=(""),=("")
0,0,0,0,1170,0,0,=(""),=("") ,=(""),=("")
95,0,0,=(""),=("") ,=(""),=("")
1170,0,0,=(""),=("") ,=(""),=("")
0,0,0,=(""),=("") ,=(""),=("")
1170,0,0,=(""),=("") ,=(""),=("")
0,1170,0,0,=(""),=("") ,=(""),=("")
0,995,0,0,=(""),=("") ,=(""),=("")
Thanks,
Alan
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John
Yeung
Sent: 05 April 2018 16:14
To: Midrange Systems Technical Discussion
Subject: Re: CSV File Creation to include Excel formula
Oops! I misspoke!
On Thu, Apr 5, 2018 at 11:04 AM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:
On Thu, Apr 5, 2018 at 10:45 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:
Otherwise, I think I
can say that if the cell gets stored in a comma-delimited CSV as follows:
...,"=("""")",...
Then Excel will treat it as the text value for the cell.
Correct.
Actually, Excel is pretty aggressive about trying to treat things NOT as
text, if it can get away with it. It manages to strip away one layer of
quote-escaping, and ultimately loads the formula anyway.
I believe you can get the undesired effect you're looking for with more
quoting, but I'm doing some testing before posting, to make sure I don't
screw up yet again.
John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
