How do I get this Function to Work in G-Docs

Literal translation

PHP Code: 

function getNames(sPara, range) {
    var getNamesTemp = ",";
    for (var i = 0; i < range.length; i++) {
        for (var j = 0; j < range[0].length; j++) {
            var currentValue = range[i][j];
            if (currentValue.length > 0) {
                Name = currentValue.toString().split(",")[0].replace(/^\s+|\s+$/g, '');
                if (sPara.indexOf(Name) >= 0 && getNamesTemp.indexOf("," + Name + ",") === -1) {
                    getNamesTemp += Name + ",";
                }
            }
        }
    }
    return getNamesTemp.slice(1, getNamesTemp.length - 1);
} 


Really Appreciate the Translation! I'm having trouble getting it to work on Google Docs though. I entered it into script editor and hit run. Error returned : "TypeError: Cannot read property "length" from undefined. (line 3, file "GetNames")"

Line three referring to : " for (var i = 0; i < range.length; i++) { "

Are you able to get the code to run on a google spreadsheet?

Once again I am new to this and I really appreciate the help!

Yes, what did your formula look like?

Originally Posted by Kyle123

Yes, what did your formula look like?

I am plugging in the formula to Google Docs Script editor. The formula translation you provided above :

Please Login or Register  to view this content.

function getNames(sPara, range) {
var getNamesTemp = ",";
for (var i = 0; i < range.length; i++) {
for (var j = 0; j < range[0].length; j++) {
var currentValue = range[i][j];
if (currentValue.length > 0) {
Name = currentValue.toString().split(",")[0].replace(/^s+|s+$/g, '');
if (sPara.indexOf(Name) >= 0 && getNamesTemp.indexOf("," + Name + ",") === -1) {
getNamesTemp += Name + ",";
}
}
}
}
return getNamesTemp.slice(1, getNamesTemp.length - 1);
}

Please Login or Register  to view this content.

When I plug this into script editor on google spreadsheets, it says there is a problem with line three. I had my java-script-savvy friend and take a look to see if he could get it to run on google spreadsheets script editor but no luck.

I am trying to get the following excel formula to work in google docs.

Copy of wuzwrong-2.xlsm

It reads the paragraph in B1 and references it with A:A and provides the matches in Column C1. Works great on Excel but I can't figure how to get it to work on Gdocs. If there is even another method you would suggest I would be open to that. Just figured this was the easiest avenue.

Thanks again for all the Help!

Just to clarify:
To Immitate what I am doing :
open up docs.google.com
open a new spreadsheet
Open tools tab
select script editor
enter the code and press the play button.


If the code is recognized, I hope, googledocs will do the same thing I have been able to get excel to do

Thanks Norie - that's why I asked what his function looked like

Fundamental error on my part. That is great. I may need to tweek just one or two things but this is a real step forward for my efforts. Thanks so much you guys!

Is suspect that:

PHP Code: 

function getNames(sPara, range) { 
    for (var i = 0; i < range.length; i++) { 
        for (var j = 0; j < range[0].length; j++) { 
            var currentValue = range[i][j]; 
            if (currentValue.length > 0) { 
                var Name = currentValue.toString().split(",")[0].trim(); 
                if (sPara.indexOf(Name) >= 0) { 
                    return sPara;
                } 
            } 
        } 
    } 
} 


Is somewhat more efficient