Remove empty rows in messages for URL

[Joxmer]

Hello, thank you in advance for your help. I am using the following expression to send messages to a URL:

"https://api.google.com/send?phone=
" & "&text=" &
ENCODEURL
("PAYMENT INFORMATION" &"
"& "*" &CONCATENATE(UPPER(TEXT([time],"DDDD")))& " " &TEXT([time],"DD/MM/YYYY HH:MM")& "*" &"

"& "*" & "TOTAL: " &TEXT([total])& "*" &"

"&IF([FP-01]=0, "", "Payment 1: " & TEXT([FP-01]))&"
"&IF([FP-02]=0, "", "Payment 2: " & TEXT([FP-02]))&"
"&IF([FP-03]=0, "", "Payment 3: " & TEXT([FP-03]))&"
"&IF([FP-04]=0, "", "Payment 4: " & TEXT([FP-06]))&"
"&
)

I am interested that when the payment value is zero, it is not displayed. But when this condition is true, there are empty rows in the message.  Are there a way to remove these empty rows?

[WillowMobileSys]

You would want to check that the text is not blank.  Something like this:

...
IF(ISNOTBLANK([FP=01]), "&IF([FP-01]=0, "", "Payment 1: " & TEXT([FP-01]))&", ""),
... 

[Joxmer]

Thanks my friend @WillowMobileSys. I found the solution:

...
IF([FP-01]=0, "", ENCODEURL("Payment 1: " & TEXT([FP-01])&"
"&)
...

In this way, having only information from Payments 1 and 3, the text message looks like this:

Payment 1: $XX

Payment 3: $XX

and not like this:

Payment 1: $XX

Payment 3: $XX