Export Problem

[racer25]

Guys,

I have a list of account numbers.

A0010
N0103
C0123

etc. etc.

All in field in DB. called CLI_CLIENTCODE

I would like to output them into a text file as "A0010", "N0103", "C0123"

Background is that I have set up a DB that connects to an Oracle DB and where we have an email address for a client it emails a PDF file to that client.

Prior to this emailing we used Crystal and we will continue to do so for those without email, the format above is Crystal Filter and I can copy paste the above straight into a filter blocking them from creating a printed statement.

Your assistance would be appreciated.

Cheers,

Rob

 

[neileg]

Sure, use the export wizard. Should give you what you want.

 

[racer25]

Neileg

Forgive me for being stupid (please).... but will an export not put this in list format rather than row format and also not put the speech marks and comma's in place.

Thanks for the reply,

Rob

 

[Dennisk]

You can export to a text file using differnet formats. the transfertext method has a number of diferent options ie CSV (comma seperated values) or fixed width format.

Each row will be output as a seperate line. If you require each row to be a column then you will have to perform some pre-processing and possibly store the results in a temp table then output that.

 

[racer25]

Thanks for that delimited text file is close, I was hoping to get from my column format to row format.

I now have something I can play around with so thanks for your help.


Cheers,

Rob

 

[neileg]

Have you checked to see whether Crystal will accept the file with the CR/LF in place?