DICTIONARY FOR A CONSTANT

[jlogdup]

Hello, I am trying to put a comma character as separator on my reports
but is not working as simple as listing ","

Example,
I want something like:


LIST MYFILE field1 "," field2 "," field3


but the outout still the same:

1 100001 MIKE W
2 100002 SAM W
3 100003 NICK C

And I do want
1 , 100001 , MIKE , W
2 , 100002 , SAM , W
3 , 100003 , NICK , C

How I can put the character comma beetwen the fields ?

Thanks

[Daniel Klein]

You will need to create a dictionary item that concatenates the
fields that you want.

Dan

[John Fenlon]

You could also use

SQLSELECT field1, ',', field2, ',', field3 FROM MYFILE

(btw - don't use double quotes use single one as per example)

To remove headings etc see the doco for environmental settings.

john

[Simon Verona]

I've not read the full thread, but you could create a dictionary that displays a comma...

eg  ED DICT MYFILE COMMA
001 S
002 0
003 \
004
005
006
007 A;","
008
009 L
010 1

Then you can do :  

LIST MYFILE FIELD1 COMMA FIELD2 COMMA FIELD3 COMMA FIELD4

not mega elegant but should work.

regards
Simon

[Artiom Popov]

SELECT MYFILE SAVING EVAL 'field1:",":field2:",":field3'
LIST MYFILE