spacing problems

[rezdragon]

date1 & "   " & ref1_1 & "   " & ref2_1 & "   " & charges1 & "   " & credit1 & "   " & ref3_1 & "   " & C & "   " & SYS & "¶" & 

date2 & "   " & ref1_2 & "   " & ref2_2 & "   " & charges2 & "   " & credit2 & "   " & ref3_2 & "   " & C2 & "   " & SYS_2 & "¶" & 

date3 & "   " & ref1_3 & "   " & ref2_3 & "   " & charges3 & "   " & credit3 & "   " & ref3_3 & "   " & C3 & "   " & SYS_3 & "¶" & 

date4 & "   " & ref1_4 & "   " & ref2_4 & "   " & charges4 & "   " & credit4 & "   " & ref3_4 & "   " & C4 & "   " & SYS_4 & "¶" & 

date5 & "   " & ref1_5 & "   " & ref2_5 & "   " & charges5 & "   " & credit5 & "   " & ref3_5 & "   " & C5 & "   " & SYS_5 & "¶" & 

date6 & "   " & ref1_6 & "   " & ref2_6 & "   " & charges6 & "   " & credit6 & "   " & ref3_6 & "   " & C6 & "   " & SYS_6 & "¶" & 

[color:red]causes...



09/01/2005   Ad   2.0   12748a1719   $280.00            

09/01/2005   Credit   Inc  Interest Credit      $62.67         

09/08/2005   Ad   2.0   12749a1719   $280.00            

09/15/2005   Ad   2.0   12750a1719   $280.00            

09/22/2005   Ad   2.0   12751a1719   $280.00            

09/27/2005   Payment         $1140.00   76846      

09/29/2005   Ad   2.0   12752a1719   $280.00            

09/30/2005   Int   Overdue- 1141.05 -.0175   $19.97  



[color:red]

and it should be more like...

09/01/2005   Ad   2.0   12748a1719   $280.00            

09/01/2005   Credit   Inc             Interest Credit      $62.67         

09/08/2005   Ad   2.0   12749a1719   $280.00            

09/15/2005   Ad   2.0   12750a1719   $280.00            

09/22/2005   Ad   2.0   12751a1719   $280.00            

09/27/2005   Payment                 $1140.00   76846      

09/29/2005   Ad   2.0   12752a1719   $280.00            

09/30/2005   Int   Overdue-          1141.05 -.0175   $19.97  

[color:red]seperated more into the coloums we are putting them into. Any ideas how to format this better?

[Lee Smith]

This seems a like a continuation of the other question you asked, and I responded to. You don't need to start a new thread every time your question evolves. Just continue the original thought until you get your solution.

These Columns you are creating, are they in FileMaker, or in an external file?

Have you tried inserting a tab instead of the spaces.

If this is to set up an export, have you tried to export using the Tabs Delimited Text format?

HTH

Lee

[rezdragon]

sorry about that!

the feilds are imported from a comma delimited txt file. and then i use that calculation to put them into one feild so i can save space and be able to scroll with all of them in there.

*Problem* if there is no entry in a certain field then the feilds smoosh all to the left and are hard to read as well as being able to tell what the heck somthign is.

[Lee Smith]

Can you attach a copy of your file and a copy of your import text document?

[rezdragon]

OK ATTACHED ARE THE FILES,

just use Admin to log into them

TESTER.zip

[Lee Smith]

Here is your file back. I made two adjustments.

I changed your calculation by replacing your spaces between fields to tabs. I change the dates field by including tabs.

BTW, I think I would have done this using a self relationship instead.

Lee

test.fp7.zip

[rezdragon]

BTW, I think I would have done this using a self relationship instead.

not sure what you mean by this?

[Lee Smith]

BTW = By the way.

I meant that the data you are reflecting with your "dates" field, is the kind you would see in a line item report, and commonly viewed in a portal.

Lee

[rezdragon]

yeah i tried a portal but couldn't get all the info to display in the portal the way i wanted it to...

unless you have a sugestion as to how i can accomplish that i am open to ideas

[bruceR]

OK ATTACHED ARE THE FILES,

just use Admin to log into them

Yes, you DEFINITELY need to get the relational bit figured out. This file is a disaster. You have 483 fields when you really need about 10; and all your problems are ocurring because of this design issue.

[bruceR]

Your file should look more like this.

test.zip