I need to enter a tab character into a field result. I see there is a \r for return. Is there something similar to that for tabs. I’ve tried \t but to no avail.
I’m a newbie / MS Access refugee, so may be clinging on to old habits ;)
Thanks.
Hi Chas,
What is the purpose of wanting the tab character in your formula? If you want space between values, just use spaces surrounded with quotes. E.g. First Name + " " + Last Name
Although you could do it with a Script field instead of a Calculation field:
function Script() {
// Replace with your own code
var hello_world = "Hello\t\t\tWorld!";
return hello_world;
}
Script();
Thanks Brendan,
My purpose is to include formatting characters which are present when using in an IoS Pages mail merge to make information readable. The information is being assembled into a one page, easily readable summary of a passenger list and itinerary for use on a phone.
I have discovered an additional problem which is that when exporting the .csv file to Numbers it loses the return character which I managed to divine how to work, and even then it needs to be a new line operator. Pages will not connect to a csv.
All in all, I suspect that Pages and Tap are not sufficiently compatible at this point. So I’m going to have to think about another route. Tap Forms is excellent at data capture, but very limited in output (albeit I’m still pretty new to it). Any suggestions would be welcome :)
Chas
Did you try all variations of the newline character to see how Pages handles them? \r or \n or both?
Tap Forms Mac can actually do mail merge itself when generating a PDF file. On a custom layout you just have to insert a static text block and insert your field names into it surrounded by square brackets.
For example:
[First Name] [Last Name]
[Address]
[City], [Province] [Postal Code]
[Country]
Then when you print, Tap Forms will fill in the data from the records.
.
