Count fields in script

[#1]

In the load script how to count the number of Fields on a table with name (so headers, not content) started by "abc" for example?

[datanibbler]

Use a WHERE clause - if the searched-for letters are always the first ones in the string - nothing easier. Use a LEFT() function.

HTH

Best regards,

DataNibbler

[#3]

But I want to count the number of columns named something, not the contents as I explained before.

Thanks,

Miguel

[datanibbler]

Hi Miguel,

that is also possible. I'm not quite sure how, but there are the so-called "table functions" (look for them in the help file) that can be used in the script to get information about the currently loaded table. You can go from there (NoOfFields is probably the right one, combined with a WHERE_clause)

[rustyfishbones]

Add a text object with

[sivarajs]

You can try this

LET vnew=NoOfFields('Tablename'); //you should use after the table is loaded.