AutoHotkey Community

[exhueydriver]

I've been lurking here for about a week, now, and I have to say,compared to the
"Other" forum I was watching for the last 4 months, this one ACTUALLY wants to
HELP newbies. (the other one's usual answer was RTFM, and I had, several times, but things are not always coherent the first few times around).
My background- 4 1/2 years scripting in FileMaker Pro(database), so I have a feeling
for the basics, just have to learn new syntax.
Which brings me to the question.
One of the limiting things about FMP is, if you want to do a "Scripted"(read: one button click)
Save a File as(or Print to *.pdf), it has to be a Known File Name & Location(i.e. C:\ThisFolder\ThisFile.txt), but if you want to do multiple reports, or invoices or whatever, you need the ability to re-name the last file dynamically, based on a "Field" value of the current record.
So, I made a field whose value is

C:\Discoes2Office\TestOne.txt, C:\Discoes2Office\TestOneCopy.txt

Then I made a FMP script that copies that to the Clipboard, then runs-
and here i have the Problem. If I understand the Clipboard(variable) correctly, the AHK script should be-

FileCopy, %ClipBoard%

BUT, the error I get is "FileCopy requires 2 or more parameters"

If I paste the file path into the AHK script(hard code it), it works fine.
I've tried-
MsgBox, %Clipboard%
to show me what is there,
and it shows what it's supposed to.
No matter what I try(and I've tried a lot), I am missing something.(is it one of those `n or `r things, and where do I put them?)
Thanks
Don

[Beastmaster]

[Torben]

I don’t know anything about FileMaker Pro, so I can’t help you with that.
But as you already realised FileCopy requires 2 or more parameters and the line “FileCopy, %ClipBoard%” does not apply to that.

There are at least 3 short cuts that probably can solve your problem.
Assuming your database always hold the filenames in the form you stated: C:\Discoes2Office\TestOne.txt, C:\Discoes2Office\TestOneCopy.txt
AND that this is the content of the clipboard
you can try these solutions:

1. the first one splits the clipboard-string by the comma

[Guest]

[exhueydriver]

Sorry it took so long, but THANKS

Beastmaster- I didn't make myself clear, I don't want to change the file TYPE
(i.e. *.txt ->*.pdf), I only want to re-name (or move) the file, with the same extension.

Torben- Reading your response #3 made me realize my problem. I
*THOUGHT* i was passing 2 parameters
(C:\Discoes2Office\TestOne.txt, C:\Discoes2Office\TestOneCopy.txt ),
but because it was in ONE variable, AHK saw it as only ONE parameter, hence the error of "FileCopy requires TWO or more parameters".
So your

FileName =%ClipBoard%
StringSplit, FileName, Filename,`,
MsgBox, %FileName1%`n%FileName2%

split my 2 parameters into 2 variables, then added them together to make it work. Thanks. Learned something, never used arrays before.

To others searching this post, this script didn't work the first time I tried it.
If you look at
C:\Discoes2Office\TestOne.txt, C:\Discoes2Office\TestOneCopy.txt
there is a space after the comma, and before the "C", AHK didn't like that.
Remove the space, and it works a treat( as the Brits say)
Don

[Chris]