Re: Import text file into a field



"d-42" <db.porsche@xxxxxxxxx> schrieb im Newsbeitrag
news:1189552805.367487.78200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I need to import a text file into a field for further parsing. All to
be done via a script.

I know I can do this with Import Folder, selecting text files, but is
there a way of doing this by just naming the file?

Importing a folder (and arranging things so that there is only one
file in the folder) seems clumsy.

This is for FM8, but if 8.5 / 9.0 can do it better/differently, I am
always looking for more reasons to justify an upgrade.

-regards,
Dave


Hello Dave:

Maybe this totally different approach is what you need:

Get the free AutoIt http://www.autoitscript.com/AutoIt/index.php
and write a simple script in any text editor and compile it.

Let FMP open any text editor with the wanted file as the argument; you can
do that dynamically from FMP by passing along the filename from a field.

Now run that compiled AutoIt script from FMP:

Tell AutoIt to wait until that window has opened.
Let AutoIt copy the contents of the window to the clipboard.
Let Autoit switch back to FMP and paste that one special file's content into
that one special field of yours.

That should work.



---
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---


.

Relevant Pages

  • Re: Text File Output
    ... table you can import from any other fmp table as long as the data-types ... the same (textfield into textfield, ... create a script that imports the records. ... sourcfe and target file have the same names. ...
    (comp.databases.filemaker)
  • Re: Why does database not open to the last record visited
    ... Marc-Andre it sounds like yours is doing the same thing as mine. ... I'm not opening the file from a machine that is not the file's host, ... install FMP; or, is this really something innate with FMP8. ... rather than having to have a script and relationship in every database ...
    (comp.databases.filemaker)
  • Re: AutoIt
    ... Digging through the AutoIt Newsgroup I ... To answer your questions the script does run in SMS's context and the ... uninstall string of an application. ...
    (microsoft.public.sms.installer)
  • Re: Live byte count possible whilst *in* a field?
    ... Is it possible in FMP 6 and/or 9 to have a live byte counter? ... end loop ... I had to tinker with the script a bit and got it ... possible after the loop has been left) and needs to edit the message and to ...
    (comp.databases.filemaker)
  • Re: Lock the keyboard
    ... will let you block keyboard input and/or screen output. ... you can't use an ActiveX, you can use AutoIt's own script, which can also ... Will prevent any user input via the mouse or keyboard. ... Windows 2000 User input is blocked and AutoIt can simulate input. ...
    (microsoft.public.scripting.vbscript)