topic Re: Renaming multiple data table from last word of current table name in Discussions

Renaming multiple data table from last word of current table name

UserID16644 — Tue, 07 Nov 2023 01:23:58 GMT

Hi, I am trying to rename multiple data table because my data table name are in directory forms. I would want to rename them according to their folder names (will be getting from the last character of the directory)

Sample data table name:

C:\Users\Desktop\Table1

C:\Users\Desktop\Table2

C:\Users\Desktop\Table3

I tried using Word function to get the last word from the file name, but doesn't work. Please help

For (w = 1, w <= N Table(), w++,
		dtName = Word(-1, Data Table(w), "\"),
		Data Table(w) << Set Name(dtName);
);

The resulting data table names should be: Table1, Table2, Table3

Re: Renaming multiple data table from last word of current table name

txnelson — Tue, 07 Nov 2023 01:25:41 GMT

You need to retrieve the data table name

For (w = 1, w <= N Table(), w++,
		dtName = Word(-1, Data Table(w) << get name, "-"),
		Data Table(w) << Set Name(dtName);
);

Re: Renaming multiple data table from last word of current table name

UserID16644 — Tue, 07 Nov 2023 01:45:54 GMT

Why does it prompt an error like this?

too many arguments{40} in access or evaluation of 'For' , For/*###*/(w = 1, w <= N Table(), w++, dtName = Word(
-1,
Data Table( w ) << get name,
"-"
), Data Table( w ) << Set Name( dtName ))

--- EDIT ---

I replaced the comma after the Word function with ; and is working now

For (w = 1, w <= N Table(), w++, dtName = Word(-1, Data Table(w) << get name, "-"); Data Table(w) << Set Name(dtName); );