Using string function inside google sheet script

Question

How to extract substring from string and length of a string?

score 1 · Answer 1 · answered Sep 30 '21 at 20:04

1

Well you can use the MDN website to search for those but here is what you asked for :

extract substring from string

The substring() method returns the part of the string between the start and end indexes, or to the end of the string.

const str = 'Stephano';

console.log(str.substring(1, 3));
// "te"
console.log(str.substring(2));
// "ephano"

length of a string

The length property of a String object contains the length of the string :

let string = "This is text !"
console.log(string.length)
// 14

answered Sep 30 '21 at 20:04

Staxlinou

thank you!! This is my code that doesn’t work function cat(ma) { l= ma.lenght return l; } – Stefano Piccioli Oct 03 '21 at 11:57
The function works? The problem isn't on the function itself but on how you use it. Try `cat('Test')` – Staxlinou Oct 03 '21 at 17:54

score 1 · Answer 2 · answered Oct 05 '21 at 09:31

This is the file with the example functions. Now it works, thanks to the valuable advice

function cat(ma)
{
    ll = ma.length;
        
    return ll;
}

function tr(m)
{
    lll = m.substring(2,9);
        
    return lll;
}

2 Answers2