File path

[Salesman0Gil]

Hello All

This should be easy, but I can't seem to get it.

I need filemaker to open a text file, based on the current record. There will be thousands of records, so I do not want to add a data source for each one.

The best way I've found is using the send event script step. This will allow me to open the file based on the record.

Here is the problem. This is the path: \\192.168.2.83\HerdArc\WMIC\SERVER12-PC\systeminfo.txt

The "Server12-PC" changes based on record, and systeminfo.txt changes based on which script parameter is passed by the button.

I can use this path as straight text in the send event, and it works perfectly, but I can not calculate it out. Filemaker really does not like the "\\" part. It drops the first "\". I even had it calculated out some, so the variable reads correctly, but Filemaker sends an error 100, (can't find specfied file). Again though if I type the text into send event it works.

also using File:\\192.168.2.83\HerdArc\WMIC\SERVER12-PC\systeminfo.txt does not work.

By the way, I can not use a mapped drive letter, it will be run from multiple locations with no consistent mapping.

Any help would be great...

Gil

[Salesman0Gil]

I got it. Sure you spend three hours or so working on something, finally post, and then you get it 15 min later.

This is what I did. Somehow this worked....I made a calc field Path = "192.168.2.83HerdArcWMICSERVER12-PC"

The made another calc field that references Path called PAth_Fixed. Path Fixed = Left(Path, 28), which takes out the computer name

Then I made a variable that is equal to Path_Fixed$Comp_Name&File_Name

It worked then... How odd.

[comment]

Filemaker really does not like the "" part. It drops the first "".

The backslash is an escape character. To have a calculation return "192…" use =

"192…"

[Salesman0Gil]

Thanks. I figured that out, but forgot to include..