Export to CSV allowing "£" to show as "£&quot

Jock

Hi Folks

Im trying to export a report to a CSV file. I can successfully export but if the field has a "£" sign in it, it shows as example "Postage charge where value of total order > œ15" the "œ" being the "£" i know i need to use convertstr and format(chr) but i have no idea where to place it in the code. :-k
See an example of the code below:

outstr := outstr + '"' + Item.Description + ' ' + Item."Description 2" + extradesc + purchasedesc + '"' + ','

Any Help appreciated [-o<

nunomaia

Navision exports data in ANSI. When you import it into another program such as Excel, Word, etc. You must make right conversion or you will have wrong chars.

kriki

This might help : http://www.mibuso.com/forum/viewtopic.php?t=1774

Kowa

nunomaia wrote:

Navision exports data in ANSI.

Navsioin exports ( and imports) in ASCII, not ANSI.