carriage return in set field?

[Rod Haden]

I want to put a carriage return into a text field using set field, like this:

$currentRecord->setField('tActivity_Log', $text . "Carriage Return");

What do I use in place of the "Carriage Return"?

Thanks!

[JesseSFR]

$text . "¶" or $test . "n"

Edited August 19, 2009 by Guest

[Rod Haden]

Thanks. Neither of those puts a carriage return into the Filemaker field, though.

[TheTominator]

I would try putting in a vertical tab.

That is ASCII 11 in decimal.

FileMaker uses a vertical tab in the data it exports to text files to represent a carriage return in the text field. Perhaps this is the internal representation too.

[JesseSFR]

Sorry Harden... I assumed that would work because I do something similar in ruby. Have you tried just copying and pasting a carriage return into your code. It's a little ridiculous but it may work.

I think I remember having a variable defined for just this problem at one point when I was doing some php work.

[Baloo]

$currentRecord->setField('tActivity_Log', $text . "nr");

[Rod Haden]

Tried copy and paste on ALT-20. Tried "nr"

No dice. I'll just use another separator instead. Thanks!

[Baloo]

interesting because the code I posted worked for me with the following setup.

PHP running on a LAMP server and FMSA10 running on W2K3 IIS

What configuration are you using??

edited to add -

Whenever text doesn't appear to function correctly I start thinking it may be an encoding issue. Try adding the following to the header of the page that generates the data

you could also try 

$currentRecord->setField('tActivity_Log', $text . chr(13));

Edited August 26, 2009 by Guest