AnsweredAssumed Answered

Char(9) (tab) does not export

Question asked by JeffBorg on Dec 28, 2011
Latest reply on May 17, 2012 by Sorbsbuster

Title

Char(9) (tab) does not export

Post

 

I just figured out the Char() function, and every character I test exports fine, except the one I need, which is the tab character (Char(9)). It always comes out as a space character. 

Have spent hours trying different things. Am tired of my manual workarounds. 

The application du jour is to make a calculated field that rounds up several input fields and puts a tab between each, so that exporting to Excel may be faster and easier.

What is the secret to getting Char(9)? Thanks in advance.

(Mac OS 10.6.8, FMP 11)

Outcomes