Re: [sqr-users] Creating delmiter separated file

["jiju vengal" <jijucvengal@gmail.com>]

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
>

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