[sqr-users] Re: Creating delmiter separated file

["White . Denise" <DWhite@drc.com>]

You could also use a STRING command:

string &col1 &col2 &col3 &col4 by '!' into $rec
write 1 from $rec

HTH,

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
------------------------------

Message: 2
Date: Thu, 6 Apr 2006 19:05:33 +0530
From: "jiju vengal" <jijucvengal@gmail.com>
Subject: Re: [sqr-users] Creating delmiter separated file
To: "This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions." <sqr-users@sqrug.org>
Message-ID:
        <4e7371dd0604060635o5a9e05c8t8d67f74f3ed21d27@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi Manoj,

Go for an explicit 'write' statement while generating CSV files....
Concatenate your column variables with whatever delimiter you want....

Like...Let $string = $col1||'!'||$col2||','||$col3

and then write to your CSV file....like:-

write 10 from $string

That should just be fine...

Regards,

Jiju
Peoplesoft Practice Group
Cognizant Technology Solutions



On 4/6/06, Manoj Mangla <Manoj.Mangla@headstrong.com> wrote:
>
> Hi
>
> I am new to sqr. I have seen lot of discussion regarding creating csv 
> file. But I have data in which commas are already there. I need a 
> mechanism wherein the delimiters can be somethine else (say '!' or
'|').
> How do I do that? I have a code written already by someone which I 
> need to modify. The code looks like:
>
>
>
> begin-select
>
> col1               (+1,5,3)
>
> col2               (0,+1,02)
>
> col3               (0,+1,2)
>
> col4               (0,+1,12)
>
>
>
> ....and so on..
>
>
>
> Any help would be welcome.
>
>
>
> Thanks
>
> Manoj

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users