Sorry typo, should be chr(039) Sort!
> -----Oorspronkelijk bericht----- > Van: [email protected] [mailto:active-server- > [EMAIL PROTECTED] Namens zonnykft > Verzonden: Friday, July 08, 2005 12:37 PM > Aan: [email protected] > Onderwerp: [ASP] Single quote problem > > Hi all, > > I'm creating ASP application to write into a tab-delimited file to be > read by Excel. This is the requirement, don't ask me why :-) > > The desired output should be something like: > XYZ 0002393 > > The problem is when I open the output file using Excel, it becomes: > XYZ 2393 > > I know that in Excel we need to put single quote to explicitly > indicate a value as a string. But when I purposely throw single quote > in the ASP code, it becomes: > XYZ '0002393 > > The single quote is also displayed! > > In either case, that's not the desired outcome. > > Is there anything I can do? > > thanks! > > > > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
