AnsweredAssumed Answered

new line character inside a text field when exporting it

Question asked by GianandreaGattinoni on Sep 13, 2011
Latest reply on Dec 8, 2011 by TSGal

Summary

new line character inside a text field when exporting it

Product

FileMaker Pro

Version

11.03

Operating system version

w7

Description of the issue

I'm exporting a text field that contains new line characters.

Instead of using the standard LF (0A hex) or CR (0D hex), I found that Filemaker as new line character uses VT (0B hex).

This character is causing a lot of problems because the application that read the text does not recognize it.

I tried to substitute the 0B chars in the text field, but it seems that FM does not look at these chars.

Is there any way to set up a standard LF or CR char in a text field?

Many thanks



Gianandrea

Steps to reproduce the problem

create a simple db  with just one text field
insert at lest 2 lines of data into the text field
export it

Expected result

I'm expected to have the char 0A HEX (line feed) or 0D HEX (carriage return)

Actual result

look into the exported file and you will see that the separator for the lines is tha char 0B HEX

Exact text of any error message(s) that appear

none

FM_text_export.PNG

Outcomes