Formatting VARCHAR fields

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Jane_Blyth
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

Formatting VARCHAR fields

Post by Jane_Blyth » 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.

Post Reply