Char(9) (tab) does not export
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)