[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Re: Creating delmiter separated file
- Subject: Re: [sqr-users] Re: Creating delmiter separated file
- From: Les Hancock <les_hanc@yahoo.com>
- Date: Fri, 7 Apr 2006 06:27:06 -0700 (PDT)
- Delivery-date: Fri, 07 Apr 2006 09:29:26 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=YcPptascKp08aQImzqJMRqy1tr+k2nhkjR1hWibBjY7Z4MRw8JL2OKmjFKjG4hfYwiQZ9ZheGTeLQ4PjTrQWlfYO2qfMMPr+nxEegBJfenf1/yeq/oqG3Lw8uBu6xWNgYP+0Z+O5fWNxxDDtWcAEiRbsddKzeEVf0AnhxRP90ro=;
- In-reply-to: <E9A8630947C17449B2E7CE5B385ED1FA0817C9@and09.drc.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Take a look at:
http://www.ontko.com/sqr/csv.html
Les
"White . Denise" <DWhite@drc.com> wrote:
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"
Subject: Re: [sqr-users] Creating delmiter separated file
To: "This list is for discussion about the SQR database reporting
language from Hyperion Solutions."
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 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
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users