Snowflake UDF & Javascript - Issue with JavaScript compilation error: Uncaught SyntaxError

Question

Disclaimer: I'm new to JavaScript & new to writing JavaScript UDFs in Snowflake.

I'm attempting to build a UDF which will "clean" the string of any characters where the ascii code is not between 32 & 127. When I attempt to use this function, I get the error:

Reason:
SQL Error [100131] [P0000]: JavaScript compilation error: Uncaught SyntaxError: missing ) after
argument list in CLEAN at '    FOR (i = 0; i < value.length; i++) {' position 13

After searching around for what in the syntax could be causing this problem, I'm no further along. The value being input is a length 3 string, with the following ascii codes: 0, 13, 0

CREATE OR REPLACE FUNCTION clean(value STRING)
    RETURNS string LANGUAGE JAVASCRIPT
    AS 
    $$ 
    var i = 0;
    var letter = "";
    var newValue = "";
    FOR (i = 0; i < value.length; i++) {
        letter = value[i].charCodeAt(0)
        IF ( letter >= 32 && letter <= 126) {
            newValue += value[i];
        } elseif (letter = 0) {
            newValue += value[i];
        }
    }
RETURN newValue
$$;

Simon D · Accepted Answer · 2020-01-01 16:38:14Z

1

Two things:

1) JavaScript is a case sensitive so keywords like FOR, IF and WHILE need to be lowercased. (Thanks to @waldente for that answer)

Also:

2) Change all references to the input parameter from lowercase value to uppercase VALUE. For example change value.length in your for loop to VALUE.length

In the documentation on JavaScript UDFs there is this part that says:

Note that the JavaScript code must refer to the input parameter names as all upper-case, even if the names are not uppercase in the SQL code

edited Jan 1, 2020 at 16:38

answered Jan 1, 2020 at 16:00

Simon D

6,3752 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lee_Str Over a year ago

Unfortunately, that didn't work. I'm still getting the same error.

waldente Over a year ago

Make FOR, IF and RETURN lowercase

Simon D Over a year ago

@waldente is right - JavaScript is case sensitive so that will probably fix your issue. I'll update my answer to include that

Collectives™ on Stack Overflow

Snowflake UDF & Javascript - Issue with JavaScript compilation error: Uncaught SyntaxError

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related