AnsweredAssumed Answered

Importing flat text file without delimiters into Filemaker Pro

Question asked by croffice on Oct 9, 2014
Latest reply on Oct 10, 2014 by philmodjunk

Title

Importing flat text file without delimiters into Filemaker Pro

Post

I want to know if there is way to import text files into Filemaker Pro Advance if the file does not have any delimiters. 

Here is an example of one record:

2014100921003456John Doe                        David Smith                1000   230923201409242014

20141009 - 1 through 8 will go into Field 1

21003456 - 9 through 16 will go into Field 2

John Doe                        - 17 through 47 will go into Field 3

David Smith                   - 48 through 78 will go into Field 4

1000 - 79 through 82 will go into Field 5

   23 - 83 through 86 will go into Field 6

09232014 - 87 through 94 will go into Field 7

09242014 - 95 through 102 will go into Field 8

Outcomes