Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 0.0  (0 votes)
  Discuss this Custom Function

Natalie Fleming, Fleming Consulting
Fleming Consulting

converts Fixed Field Data file to a comma delimited data format

Sample Input:
122333444455555666666777777788888888999999999101010101011111111111
Sample Output:
"1","22","333","4444","55555","55555","666666","7777777","88888888","999999999","1010101010","11111111111","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

While using the GNU AWK is most effective in converting fixed length fields to csv or any importable file format, sometimes I just can't ask clients to get into the scary terminal to prep data files for FM import.

This function is a great band aid for converting fixed length data files into a csv file for reimport into FM.

Although I do recommend GNU AWK whenever possible.


Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

I have to agree with you on AWK. Especially if you are using Filemaker Server. I process 10,000 - 4,000 character records every day, and split them into 168 fields and I can promise you than no method is faster than AWK at this process. What took a second or so per record to do on a local Filemaker install runs on my server in minutes now. The trick is to maintain your field definitions in Filemaker, and use the data from that table to build the AWK command that will execute on the server. Then whenever there is a change to the data and related field definitions, they are automatically used on the next file processing cycle.

If anyone is interested in learning more about this process, or text preprocessing for Filemaker please comment on this post. I am happy to share.

Robert Carrier, Bristol, TN
October 06, 2017 7:45am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 3 + 4 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions