77342_en-US

liliconcom

Trouble Finding columns

Hi,

 

My goal is a script that loads all the csv files in a directory and then does name clean up.  Previously I had developed a script that worked on a single file and I am looking to expand it to batch loading.  I found a script on the board combining txt tables.jsl and added in the code so it works on the Mac and inserted my settings for the txt import.  That seems to work.

 

I am now working on the column clean up and this is the script.  It has trouble finding the "Column 3".  Up til then it executes.  Now the odd thing rhese lines were copied from my original script.

If I highlight the line with the column 3 rename in the new script and hit run (so only that line executes) I get an error.  If I highlight the same line in my original script and execute it works as intended.  I have literally copied and pasted (command-C and command-V) between the scripts.

 

What am I missing?

And yes Column 3 exists.

 

Andy

dt=current data table();

dt<<DELETE columns=""></DELETE>

Re: Trouble Finding columns

Though I am curious why if worked in my first script without the colons.

 

Andy

Re: Trouble Finding columnsThanks.

It is working.

AndyRe: Trouble Finding columns

There is a error with your use of Name().  This is a special syntax function.  It requires a ":" in front of the function,.......:Name()