AnsweredAssumed Answered

removing leftmost pattern in calculation

Question asked by JulienBeauviala on Oct 25, 2010
Latest reply on Oct 26, 2010 by LaRetta_1

Title

removing leftmost pattern in calculation

Post

Hello all,

in a calculation field, I have the following :

¶ &

If ( (periodicite ≠ "")     ; ". - " & periodicite ; "" ) &
If ( (note_generale ≠ "")   ; ". - " & note_generale ; "" ) &
If ( (note_titre ≠ "")      ; ". - " & note_titre ; "" ) &
If ( (note_edition ≠ "")    ; ". - " & note_edition ; "" ) &
If ( (note_adresse ≠ "")    ; ". - " & note_adresse ; "" ) &
If ( (note_collection ≠ "") ; ". - " & note_collection ; "" ) &
If ( (note_reliure ≠ "")    ; ". - " & note_reliure ; "" ) &
If ( (note_contenu ≠ "")    ; ". - " & note_contenu ; "" )

&
¶ &

which is simple and serves it's purpose but leaves me with an
extra '. - ' at the beginning of that block of text.

I'm trying to get rid of that initial '. - ', but I'm having
problems expressing that in filemaker speak (using text functions).

Ideally I'd put the whole string into a variable, then split
the variable on the first occurence of '. - ' and use the
second part as what to display (well, thats what I would do
if I was in php, but here in FileMaker, I'm not sure it
would be the right way).

Would someone have a pointer for me ?

Thanks !

Outcomes