Hi Everyone

I am using FM 8 Pro Advanced.

I need to create a custom function that spits out a string of a bunch
of fields separated by TABs.
I found a symbol that inserts a Line feed, but havent found anything to
represent TAB.

Does anyone have a hint for that?

Thanks,

Thiago

In the calc dialog, you can just use CTRL-Tab in Windows or something 
similar in Mac.

Thiago Jorge wrote:
> Hi Everyone
> 
> I am using FM 8 Pro Advanced.
> 
> I need to create a custom function that spits out a string of a bunch
> of fields separated by TABs.
> I found a symbol that inserts a Line feed, but havent found anything to
> represent TAB.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Professional Solutions, Inc.    Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Thanks a lot, that part seemed to work, however since I copy the
strings (separated by "=B6") into a single field on the database I can't
get it to export into an excel file each field in a separate cell.

Is there a way to do that be exported correctly into an excel file or
do I have to create a layout with all the fields I need to be exported?
That would be a waste since I have 64 fields and each one will have to
be exported 7 times...That is why I was trying to use a custom function
to do that.

Thanks again

Create one calc field that combines all your fields separated by tabs. 
Then export just that one calc field as a tab-delimited file.  That 
should work for you.  Note that you cannot insert return� characters 
into the calc, as it is a different type of return then the typical 
record separator.  So once you create your special calc field for one 
record, you can export whatever found set of records you want.

Thiago Jorge wrote:
> Thanks a lot, that part seemed to work, however since I copy the
> strings (separated by "�") into a single field on the database I can't
> get it to export into an excel file each field in a separate cell.
> 
> Is there a way to do that be exported correctly into an excel file or
> do I have to create a layout with all the fields I need to be exported?
> That would be a waste since I have 64 fields and each one will have to
> be exported 7 times...That is why I was trying to use a custom function
> to do that.
> 
> Thanks again
> 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Professional Solutions, Inc.    Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

In article <1145466272.968859.232750@i39g2000cwa.googlegroups.com>,
"Thiago Jorge" <thijorge@gmail.com> wrote:

> Hi Everyone
> 
> I am using FM 8 Pro Advanced.
> 
> I need to create a custom function that spits out a string of a bunch
> of fields separated by TABs.
> I found a symbol that inserts a Line feed, but havent found anything to
> represent TAB.
> 
> Does anyone have a hint for that?

Anything you can type can be stored in a field, so a good way to get at
"special" characters is to store them in a Global field.
ie.
       g_Tab

Put this on a Layout temporarily. Type a Tab into it in Browse mode
(Ctrl-Tab for Windows or Option-Tab for Mac). Then wherever you want a
Tab in a Calculation you can use this field.
eg.
       MyString = "This is a tab:" & g_Tab & "folled by more text"




Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)

In article <1145472596.966330.119220@u72g2000cwu.googlegroups.com>,
"Thiago Jorge" <thijorge@gmail.com> wrote:

> Thanks a lot, that part seemed to work, however since I copy the
> strings (separated by "�") into a single field on the database I can't
> get it to export into an excel file each field in a separate cell.
> 
> Is there a way to do that be exported correctly into an excel file or
> do I have to create a layout with all the fields I need to be exported?
> That would be a waste since I have 64 fields and each one will have to
> be exported 7 times...That is why I was trying to use a custom function
> to do that.

I don't really understand what you're trying to do.

If you go to File and choose the Export Records command you can export
the records to a Tab delimited file (first choosing which fields you
want to export). This file can be opened in Excel and will have each
field in a separate column and each record on a seprate row.

I can't check at the moment, but I think there's also an option in the
Export Records window to use an Excel file format which does basically
the same thing.

Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)