A line of text have breaks ?

[tripdragon]

Continued form here

http://www.fmforums.com/threads/showflat.php/Cat/0/Number/109837/page/0/view/collapsed/sb/5/o/all/fpart/1

How can I make a line of text have breaks in it from tabs ? Please help, I am not to adapt with scripting just yet.

[-Queue-]

You can do it with a repeating calculation. Create a global number field with the number of repetitions equal to the maximum number of possible tab breaks. Put this field on a layout and format it to display all repetitions. Enter 1 in the first repetition, 2 in the second repetition, etc. Then create a calculation text field with the same number of repetitions and specify the calculation as

Middle( Extend(text), Position( "[tab]" & Extend(text) & "[tab]", "[tab]", 1, gIndex ), Position( "[tab]" & Extend(text) & "[tab]", "[tab]", 1, gIndex + 1 ) - Position( "[tab]" & Extend(text) & "[tab]", "[tab]", 1, gIndex ) - 1 )

where [tab] is a Ctrl-Tab on Windows. I'm not sure what it is on Mac. Now you can put this field on your layout and format it to display all repetitions vertically.

[tripdragon]

Ok , Lee helped me with it, But he changed it to

Middle( Extend(one), Position( " " & Extend(one) & " ", " ", 1, gIndex ), Position( " " & Extend(one) & " ", " ", 1, gIndex + 1 ) - Position( " " & Extend(one) & " ", " ", 1, gIndex ) - 1 )

New problem, haveing it like this defeats the power of being in it's own Field and haveing the search power

[Lee Smith]

Hi JT,

Using your description above, I modified the file attached in tripdragon previous thread (Is anyone else confused, or is it just me?):

http://www.fmforums.com/threads/showflat.php/Cat/0/Number/109837

Not sure if this was what you meant, but since tripdragon has a problem, here is the modified file, so that we are comparing Apples to Apples.

Lee

aUntitled.fp5.zip

[-Queue-]

Trip, the calculation Lee gave you is the same one I gave you; you just see the tabs as a solid black line in the field definition. You can still do a search in a repeating field by entering criteria in the first repetition. It will search all repetitions.

Lee, that's exactly what I meant.

[tripdragon]

ugh, it is still a mess, I do not have the power to move it around now, and makin small lines is stupid looking as a line will now go through a line on text ....

New idea, can a filemaker file display and search trough an html table ?

[-Queue-]

What do you mean 'move it around' and 'a line will now go through a line on text'? This technique was only for a report format, I thought. I wouldn't use it for data entry or searching, though you can use it for searching, as I said before, and you only need to show one repetition in a find layout.