FMPRO-L Archives

August 2011, Week 5

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Lee Hoong <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Wed, 31 Aug 2011 12:50:41 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (48 lines)
Sue,

If you're using FileMaker 10 or later, you can use:

Name & Char ( 9 ) & birthday

HTH.

Lee.
=================
Binary Assist
220 Gaines Oak Way
Suwanee, GA 30024
Voice: (678) 313-5604
Internet: [log in to unmask]
Website: www.binaryassist.com

FileMaker Certified Developer







On Aug 31, 2011, at 12:19 PM, Sue wrote:

> Does anyone know a way to include a tab in a concatenated text calculation?
> 
> I have several situations where it would be nice to have a field of text that includes tabs so that the beginning letter of various parts of the calculated field line up.  E.g.  I have a field that returns a name and a birthday.  I would like the name and birthday values to be separated by a tab instead of a set number of spaces so that I could use the List function to give me an output that looks like:
> 
> Joe Smith        January 1
> Sarah Johnson    January 20
> 
> instead of
> 
> Joe Smith        January 1
> Sarah Johnson        January 20
> 
> I tried creating a calculation looking at length of the name and returning a variable number of spaces which I then included in the calculation--eg Name & Tabcalc & birthday, but that didn't work quite right--maybe due to the different kerning for different letters (eg an i perhaps uses less space than m)?
> 
> That leaves me out of ideas.  Maybe it isn't possible, but if it is, I would like to know how to do it.
> 
> Thanks in advance for any suggestions.
> 
> Sue
> 

ATOM RSS1 RSS2