Keyword Counter - FWIMC

Hello!

It has been asked for a keyword counter on upload page. Although it appears to happen soon, I found a way to sort out the problem:

For all my footage I use an OpenOffice Calc datasheet with clip name, title, description, keywords etc. I just found a way to count the words in a cell by placing in the cell next to the right of the keywords cell the following formula:

=IF(LEN(TRIM(A1))=0;0;LEN(TRIM(A1))-LEN(SUBSTITUTE(A1;" ";""))+1)

Excel users must replace the semi-colons ";" with commas "," .

Then replace A1 with the ID of the first keywords cell and drag down the counter cell.

I have got the formula from this page:

http://www.suite101.com/content/spreadsheet-formula-to-count-words-in-cell-a110720

Regards,
Christian

The url is linking to your hard drive:)

Fixed the error. Now it should work! I apologize for any inconvenience.
Christian