Skip to main content
Solved

Impossible to combine fields and line break if empty fields

  • October 8, 2023
  • 3 replies
  • 36 views
N
Forum|alt.badge.img+4

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 break line.

Right now I have this, 

IF({MARQUES}, " " & {MARQUES} & "\n") &
IF({DESIGNER}, " , " & {DESIGNER} & "\n") &
IF({DATATION}, "  " & {DATATION} & "\n") &
IF({COLLECTION}, " " & {COLLECTION} & "\n") &
IF({FABRICATION}, " " & {FABRICATION} & "\n") &
IF({PRODUIT}, " " & {PRODUIT} & "\n") &
IF({MODELE}, " - " & {MODELE} & "\n") &
IF({MATIERES}, " " & {MATIERES} & "\n") &
IF({COULEURS}, " " & {COULEURS} & "\n") &
IF({DETAIL}, " " & {DETAIL}) &
IF({GRIFFES}, " , " & {GRIFFES} & "\n") &
IF({PROVENANCE}, " " & {PROVENANCE} & "\n") &
IF({TAILLES}, " " & {TAILLES} & "\n") &
IF({CONDITION REPORT}, " " & {CONDITION REPORT} & "\n") &
IF({ICONOGRAPHIES}, " " & {ICONOGRAPHIES}
 
and it is showing this for the moment
MARQUES
X DESIGNER
 
I would like to have MARQUES X DESIGNER
 If i do correction and  write 
IF({MARQUES}, " " & {MARQUES}) &
IF({DESIGNER}, " X " & {DESIGNER} & "\n") &
 
Then I will have 
MARQUES X DESIGNER
 
But If I do so, and if the field MARQUES is EMPTY it create a empty field with a ,
I will have 
, DESIGNER
 
 
 

Best answer by NICK75

Thanks that is great

3 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • October 8, 2023

To check two fields and branch conditionally, use the AND function.

How to use Like this.

IF( AND({MARQUES},{DESIGNER}), {MARQUES} & " X " & {DESIGNER} & "\n", IF({MARQUES}, " " & {MARQUES} & "\n") & IF({DESIGNER}, " " & {DESIGNER} & "\n") )

 

N
Forum|alt.badge.img+4
  • NICK75
  • Author
  • Inspiring
  • Answer
  • October 9, 2023

Thanks that is great

N
Forum|alt.badge.img+4
  • NICK75
  • Author
  • Inspiring
  • November 30, 2023

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},{DESIGNER}),
{MARQUES} & " X " & {DESIGNER} & "\n",
IF({MARQUES}, " " & {MARQUES} & "\n") &
IF({DESIGNER}, " " & {DESIGNER} & "\n"))&
IF({FABRICATION}, " " & {FABRICATION} & "\n") &
IF(AND({DATATION},{COLLECTION}),
{DATATION} & " - " & {COLLECTION} & "\n",
IF({DATATION}, " " & {DATATION} & "\n") &
IF({COLLECTION}, " " & {COLLECTION} & "\n"))&
IF(AND({PRODUIT},{MODELE}),
{PRODUIT} & " - " & {MODELE} & "\n",
IF({PRODUIT}, " " & {PRODUIT} & "\n") &
IF({MODELE}, " " & {MODELE} & "\n"))&
IF({MATIERES}, " " & {MATIERES} & "\n") &
IF({COULEURS}, " " & {COULEURS} & "\n")&
IF({DETAIL}, " " & {DETAIL} & "\n")&
IF({GRIFFES}, " " & {GRIFFES} & "\n") &
IF({PROVENANCE}, " " & {PROVENANCE} & "\n") &
IF({TAILLES}, " " & {TAILLES} & "\n") &
IF({CONDITION REPORT}, " " & {CONDITION REPORT} & "\n") &
IF({ICONOGRAPHIES}, " " & {ICONOGRAPHIES} & "\n") &
IF({CITES}, " " & {CITES})
Terms & ConditionsAccessibility statement