SUBSTITUTE is not a function

[Ujval_Shah]

let old = query[i].field_data;
let new = old.SUBSTITUTE(’\n’,’ \n’);

Results in “SUBSTITUTE is not a function”

[kuovonne]

Ujval_Shah:

SUBSTITUTE

It looks like you are writing a script versus writing an Airtable formula. Scripts are written in JavaScript, formula fields are written in Airtable’s formula field language. SUBSTITUTE is a function in the Airtable formula field language. It is not a function in the JavaScript language. You might want the JavaScript string function .replace().

You also need to make sure that you are using .replace() on the proper data type. It also seems like you are trying to replace a newline character with another newline character, which wouldn’t have any effect.

[Ujval_Shah]

let old = query[i].field_data;
let new = old.replace(’\n’,’
’);

replace() does work but its working for the first occurrence only. I have a following string,

"One \n - Two \n - Three"

need this as,

"One </br> - Two </br> - Three"

[kuovonne]

If you want a JavaScript global replace you need to use a regular expression with the global flag.

w3schools.com

JavaScript String replace() Method

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

[Alexey_Gusev]

Hi,
for those (like me) too lazy to learn regex for now, you can use split-join.
example, used in html txt parsing to get text from tag A to tag Z excluding all occurrences of tag X inside.

const cutter=(txt,pattern)=>txt.split(pattern).join(’’);
const cut=(txt,a,z,x)=>cutter((txt.split(a,2).pop().split(z,2).shift()), x);

but anyway, i’m going to start learning regex one day…

[kuovonne]

Alexey_Gusev:

for those (like me) too lazy to learn regex for now, you can use split-join.

You can use the string .replace method with minimal to no regex knowledge. The webpage I linked to has an example of a global replace with static strings.