Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

Text.ReplaceNewline

Replaces newline characters.

Component Version macOS Windows Linux Server iOS SDK
Text 2.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Text.ReplaceNewline"; Text; Mode { ; Wrap } )   More

(old name: String.ReplaceNewline)

Parameters

Parameter Description Example Flags
Text The text to process. "Hello World"
Mode The operation mode. First a value for the output newline type:
0: nothing
1: CR (Mac)
2: LF (Unix)
3: CRLF (Windows)
4: <br> for html
5: <br /> for xml

Second you can add 8 to remove duplicate newlines.
Wrap Optional whether to wrap lines longer than given number of characters. Default is 0 for no wrap. 80 Optional

Result

Text with modified newline characters.

Description

Replaces newline characters.
Can remove, convert to Mac, Windows and Linux specific end of line characters. Also can remove duplicates.
FileMaker uses Mac line endings on all platforms.

Like ReplaceLineEndings in Xojo.
This function works on pure text, so any text style is lost. And it truncates on first NULL byte.

Examples

Remove newlines from field:

MBS( "Text.ReplaceNewline"; Test Database::TextField; 0 )

Replaces newlines from field with Mac newlines:

MBS( "Text.ReplaceNewline"; Test Database::TextField; 1 )

Replaces newlines from field with Mac newlines and remove duplicates:

MBS( "Text.ReplaceNewline"; Test Database::TextField; 1+8 )

Write UTF-8 CRLF file:

Set Variable [ $text ; Value: "Joe,1234 Main St.¶John Glen,3132 Elm¶Johnson,5233 Wreybird¶Ray,263 Birch¶äöü" ]
Set Variable [ $path ; Value: "/Users/cs/Desktop/test.txt" ]
Set Variable [ $text ; Value: MBS( "Text.ReplaceNewline"; $text; 3) // CRLF ]
Set Variable [ $r ; Value: MBS( "Text.WriteTextFile"; $text; $path; "UTF8" ) ]

Change line endings for a text file:

Set Variable [ $path ; Value: "/Users/cs/Desktop/test.txt" ]
Set Variable [ $text ; Value: MBS("Text.ReadTextFile"; $path; "UTF-8") ]
Set Variable [ $text ; Value: MBS("Text.ReplaceNewline"; $text; 3)
// 1 = CR for Mac
// 2 = LF for Linux
// 3 = CRLF for Windows ]
Set Variable [ $r ; Value: MBS("Text.WriteTextFile"; $text; $path; "UTF-8") ]

See also

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 2nd October 2023


Text.ReplaceAll - Text.Reverse