AnsweredAssumed Answered

Problem with data import of basic width delimited txt file

Question asked by JRemsen on Sep 2, 2009
Latest reply on Sep 4, 2009 by JRemsen

Title

Problem with data import of basic width delimited txt file

Post

I am relatively new to the scripting side of filemaker pro but I or it seem to be missing something. Why doesn't filemaker pro allow the import of data from a basic width delimited text file? I was pretty sure all database software could carry this out since early 90's. Is there some reason why its hidden or not in the package? More importantly if it is not what is the workaround.

 

Text file framework:

 

text:10 text:3 text:20 text:20 text:20 text:20 text:8 text:10

 

so

 

"date-sec-comment-comment-comment-comment-file#-comment"

 

excluding the "-"

 

To be fed into field 1, field 2, field 3, field 4....field 8

 

How do I bring this in to Filemaker Pro without using Excel or Access to process it first? I want to take out the middle man and go from TXT right into the database so I can automate the updates I need.

 

I spent roundabout 4 hours today trying to make the above basic function happen using different scripting methods that were available in Filemaker.   

 

Thanks,

 

Jay

Outcomes