Formatting VARCHAR fields
Posted: Wed Jun 02, 2010 8:56 pm
Hello, In Report Writer (v10) i have two varchar fields__1)for sort codes nnnnnn, which I^ve split down into seperate components and concatenated with a dash in a new field using SUBSTR e.g. nn-nn-nn. When this field is exported as a .csv file, any sort code that looks like a date is displayed as a date (e.g. 01/07/26) and any it can^t it leaves them how I want them to be (E.g.64-34-10). I can^t find anyway to format the original fields or the concatenated field so that it stays like the output in report writer when it is exportedm into a .csv file. __2) The second problem is still a varchar field which in Report Writer displays a leading zero and I need this leading zero to still be displayed when exported to a .csv file. Again I can^t find a way to format the Varchar fields in Report Writer.__Any help would be greatly appreciated. Thank you, Jane.