cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-4990%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EFehler%20beim%20%C3%96ffnen%20der%20Datei%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4990%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3EIch%20habe%20ein%20JSL-Skript%20(JMP%209)%2C%20das%20mit%20CSV-Dateien%20in%20einem%20Verzeichnis%20arbeitet.%20Das%20Skript%20funktioniert%20einwandfrei%2C%20wenn%20es%20sich%20im%20selben%20Verzeichnis%20wie%20die%20CSV-Dateien%20befindet.%20Es%20wird%20die%20Fehlermeldung%20angezeigt%2C%20dass%20die%20Datei%20nicht%20ge%C3%B6ffnet%20werden%20kann%2C%20wenn%20sie%20sich%20nicht%20im%20selben%20Verzeichnis%20wie%20die%20CSV-Dateien%20befindet.%20Kann%20mir%20jemand%20sagen%2C%20was%20ich%20falsch%20mache%3F%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3EVorschautextfehler%3A%20Datei%20kann%20nicht%20ge%C3%B6ffnet%20werden.%3C%2FP%3E%3CP%3EText%20importieren%3A%20Trennzeichen%20konnten%20nicht%20ermittelt%20werden.%3C%2FP%3E%3CP%3EVersucht%20zu%20%C3%B6ffnen%3A%20%2FM%3A%2FOV9760%2Fxyz.csv%3C%2FP%3E%3CP%3EDie%20Tabelle%20kann%20beim%20Zugriff%20oder%20bei%20der%20Auswertung%20von%20%E2%80%9EOpen%E2%80%9C%2C%20Open(%20files1.)%20nicht%20ge%C3%B6ffnet%20werden%3CI%3E%20)%3C%2FI%3E%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3EIm%20folgenden%20Skript%20ist%20der%20Fehler%20mit%20%2F*%23%23%23*%2F%20markiert.%3C%2FP%3E%3CP%3Edir1%20%3D%20Verzeichnis%20ausw%C3%A4hlen(%20%22W%C3%A4hlen%20Sie%20den%20Ordner%20aus%2C%20in%20dem%20sich%20die%20CSV-Dateien%20befinden%22%20)%3B%3C%2FP%3E%3CP%3EopenDTs%20%3D%20%7B%7D%3B%3C%2FP%3E%3CP%3Efiles1%20%3D%20Dateien%20im%20Verzeichnis%20(dir1)%3B%3C%2FP%3E%3CP%3Estart%20%3D%20Tick%20Seconds()%3B%3C%2FP%3E%3CP%3EFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20files1%20)%2C%20i%2B%2B%2C%3C%2FP%3E%3CP%3EIf(%20endet%20mit(%20files1%3CI%3E%20%2C%20%E2%80%9E.csv%E2%80%9C)%2C%3C%2FI%3E%3C%2FP%3E%3CP%3E%C3%96ffnen%20Sie%2F*%23%23%23*%2F(Dateien1%3CI%3E%20)%3B%3C%2FI%3E%3C%2FP%3E%3CP%3Edt1%20%3D%20Aktuelle%20Datentabelle()%3B%3C%2FP%3E%3CP%3E-------------------------------------------------%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-4991%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Fehler%20beim%20%C3%96ffnen%20der%20Datei%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4991%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EIch%20denke%2C%20das%20Verzeichnis%20wird%20in%20Open()%20nicht%20gespeichert%20oder%20implizit%2C%20dh%20der%20Pfad%20muss%20angegeben%20werden.%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%20style%3D%22margin%3A%200.0px%200.0px%200.0px%200.0px%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%232800e1%3B%22%3EOffen%3C%2FSPAN%3E%3CSTRONG%3E%20(%3C%2FSTRONG%3E%20dir1%3CSPAN%20style%3D%22color%3A%20%23160091%3B%22%3E%20%7C%7C%3C%2FSPAN%3E%20Dateien1%3CSTRONG%3E%20%5Bich%3C%2FSTRONG%3E%3CSTRONG%3E%20%5D)%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20%23160091%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%20style%3D%22margin%3A%200.0px%200.0px%200.0px%200.0px%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23160091%3B%22%3E...%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Open File Error

I have a JSL script (JMP 9) that works on csv files in a directory. The script works fine if its in the same directory as the csv files. It gives a 'unable to open file' error if its not in the same directory as the csv files. Can someone tell me what I am doing wrong?

Preview Text Error: Unable to open file.

Import Text: Unable to determine delimiters.

Tried to open: /M:/OV9760/xyz.csv

Cannot open table in access or evaluation of 'Open' , Open( files1 )

In the following script, error marked by /*###*/

dir1 = Pick Directory( "Select the folder where csv files are located" );

openDTs = {};

files1 = Files In Directory( dir1 );

start = Tick Seconds();

For( i = 1, i <= N Items( files1 ), i++,

    If( Ends With( files1, ".csv" ),

        Open/*###*/(files1);

         dt1 = Current Data Table();

-------------------------------------------------

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Open File Error

I think the directory is not remembered or implicit in Open(), i.e. the path has to be included.

...

Open(dir1||files1[i]);

...

View solution in original post

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Open File Error

I think the directory is not remembered or implicit in Open(), i.e. the path has to be included.

...

Open(dir1||files1[i]);

...

Recommended Articles