On Monday 15 September 2003 09:57, Richard Sydney-Smith wrote:
> I am outputting the following rows from a SYBASE database on W2000
> The problem is that each string is imported with the inverted commas.
>
> eg field ID = ''RK'' instead of 'RK'
>
> Can someone please help?
A short bit of perl. So
I am outputting the following rows from a SYBASE
database on W2000
3 '2' 'IBISFinancials' 'A.C.N. 072
378 815'8 'RK' 'Personal Accounts'
Using the command:
select cast(seq as integer) , id , cmpy, tr_n from
fcont; output to d:\fcont.dat format 'ascii' delimited by '\x09'
This output