Hi Folks -
One of our customer has a value of 53¼ × 79½ in a field called Width which is of data type Text. When they export this field via dataport it exports it like looks like 53< X 79} in the notepad when they open the file. All other fields are fine.
Does anyone know any solution for this. Any help is highly appreciated.
Thanks
I believe the datatype which you’ve given as Text and value which you’ve entered is not formatting for that datatype.
Hello,
I think your problem is the Encoding.
FreddyDk has a blog post about this.
blogs.msdn.microsoft.com/…/
regards,
I think Thomas are right. Except in your case using dataports, there is a different way to do.
The reason is that NAV natively only handles the ASCII character set, whereas Windows expect it to be in ANSI format. So you need a function to convert the text before exporting it.
You can see how to do it this old post from 2004:
[View:~/nav/f/users/5404/how-to-use-the-asci2ansi-converter-in-a-dataport:320:50]
There is even a link to the function at Mibuso. [:)]
Many Thanks Thomas and Erik, that post was helpful and it works now.