FILTER command to allow Carriage Return and Tab

[djc728]

Hello All:

 

I have a text field that I'd like to filter on taking only characters A-Z, 0-9 and some special characters like "@#$%, carriage returns and tabs.  My problem is I don't know how to specify the Special Characters, Carriage Return and Tab in the Filter script.

 

Anyone?

 

Dom

[Wim Decorte]

Char(10), Char(13)

[eos]

Use the Char() function to pass the matching ASCII values / Unicode code points; in this case, that would be Char(9) and Char(13),

[djc728]

Wim, EOS:

 

Thank you both.  Had a blonde moment there.  ( lol )

 

Dom

[comment]

Filemaker has a special symbol for the carriage return: ¶ There's even a button in the Specify Calculation window for inserting the symbol. Alternatively, you can use Char (13).

 

Regarding the tab, you can either type* or paste an actual tab into the formula (there's no way to type it, AFAIK) or - preferably - use Char (9).

 

---

(*) Using Ctrl+Tab on Windows, Option+Tab on OS X.

Edited September 12, 2014 by comment

[Raybaudi]

(there's no way to type it, AFAIK)

 

On Windows you can type CTRL + TAB

[comment]

On Windows you can type CTRL + TAB

 

I stand corrected. I am not sure when this started, but I see that you can type a tab on a Mac too, using Option+Tab.

[djc728]

Thanks all.  I learned something new today.  Appreciate all the help.