Try "Text line" & Char ( 9 ) & "text" & Char (9)
Char ( 9 ) returns the horizontal tab character.
A useful resource is to look up "codes" in filemaker help for a list of character codes.
It's not quite working the way I'd hoped. It doesn't insert a tab. Instead it inserts a space.
Here's what the calculation says:
And here's the txt it generates:
Name Tracks Start End
Is this because I'm on a mac?
Are you viewing this result in a field where you've set tab stops?
Try using the tabs section under the Appearance tab in the Inspector to set some tab stops and see if you get the text to alighn to the tab stops.
I don't need to view the results in filemaker; I need to export the tabs as part of a tab delimited file for import into an Avid editing system.
So if this is impossible I will simply replace Char(9) with some unique text string and create a macro to convert it.
Thanks for your help regardless--your help is top knotch at all times!
That doesn't answer my question. Does your posted text represent what you get in a filemaker field or after you export it? If after export, what export options are you using? It could be the tab character is being converted back to space during the export.
I CAN see the effect of tabs in my layout (I just have it as the only field in a header--it works fine)
But when I export as Tab Delimited Text--no dice. Tabs become spaces.
When you export as tab-delimited text, tabs in fields are converted to spaces. This is done on purpose, so that tabs in fields do not create additional columns. You are trying to fool the system and that won't work.
You can achieve your purpose in one of two ways:
• compile your entire report in a global text field, then export field contents;
• export as XML using a custom XSL style sheet.