I am currently populating a boilerplate formula in a Google Sheet after moving the rest of the data to another sheet, however the formula seems to drop the '' from '\s' in the sheet,leading to the regex detecting and replacing all S's rather than whitespace.
e.g. REGEXREPLACE(A2,"\s","") becomes REGEXREPLACE(A2,"s","")
The full code is:
descriptionSheet.appendRow(['Brand', 'Product Type', 'Product Name', 'Size', 'Colour', 'Condition', '', '=VLOOKUP(D2&" "&A2&" "&B2,Measurements!A:C,2,FALSE)', '=VLOOKUP(D2&" "&A2&" "&B2,Measurements!A:C,3,FALSE)', '=A2&" "&IF(C2="","",C2&" ")&B2&"\n\n"&D2&"\n"&E2&"\n\n"&F2&" condition - "&IF(G2="","No rips, holes or stains!",G2)&"\n\nMeasurements\n⦿ Pit to pit: "&H2&" inch\n⦿ Shoulder hem to bottom: "&I2&" inch\n\nVerified Depop Top Seller! Shop with confidence.\n\nFree Shipping on bundles.\nSame day dispatch on request.\n\n#"®EXREPLACE(A2,"\s","")&" #"®EXREPLACE(A2&B2,"-|\s","")&" #"®EXREPLACE(K2,"-|\s","")', '=CONCATENATE(A2," ",B2," ",C2)', '=REGEXREPLACE(A2,"[^A-ZÀ-Ö]","")&"-"®EXREPLACE(K2,"[^A-Z0-9]","")&"-"&D2&"-"&SUBSTITUTE(UPPER(JOIN("",ArrayFormula(left(split(F2," "),1)))),"-","")&"-"&UPPER(LEFT(E2,3))' ]);Note the \n is working as desired. Only the \s is causing an issue.
Tried using String.raw and changing code to use /\s/g instead of just \s