Hello,I would like to not have a space at the beginning of each entriesI think I have to use Trim but My formulas is long and I do not know how to make sure each line and trimmed.Right now with this formulas each lines as a white space at the beginni...
I already have a formulas that work fine although i need to add “( )” around my Base field called MODELEIF(AND({PRODUIT},{MODELE}),{PRODUIT} & " - " & {MODELE} & "\n",IF({PRODUIT}, " " & {PRODUIT} & "\n") &IF({MODELE}, " " & {MODELE} & "\n"))& Right ...
I am trying to have a formula which give me the possibility to have on the same line two fields separated by a coma. This is tricky, because, i need also to have in the formula that if the field is empty if it not showing the empty space or make a br...
Hello community,My script do not work if the field is blanc there is a line break. however, i need the linebreak when there is a record.How can I do ? Thanks in advance {MARQUES} & IF({DESIGNER}, " X " & {DESIGNER}) & IF({DATATION}, " - " & {DATATION...
I do not understand where and how to use REGEX_REPLACE() to remove all white space next to a line break but I do know how to write it correctly. and what to put into () ?Can you be more specific ?thanks in advance here's what I have so far and where ...
I still have a problem i would like to use REGEX_REPLACE() to remove all white space next to a line break but I do know how to write it correctly.here's what I have so far and where should insert and write with REGEX_REPLACE (?????) IF(AND({MARQUES},...
