empty field

[leelou]

hi got a question how to make a calculation that dont give a carriage return where there is no data in a field

got different field to export

like this:

 

name

firstname

adres

zip

city

phone

fax

number( this is ok)

 

but when there is no fax number or phone the exported field give me that

name

firstname

adres

zip

city

 

fax

number (this is not good) have to ressemble city an fax?

and i want that al text get together like the first that i write

this is the calculation:

 

"@BAR:"&@BAR:&¶&"@ENT:"&@ENT:&¶&"@NUM:"&@NUM:&¶&"@NOM:"&@NOM:&¶&"@SPE:"&@SPE:&¶&"@ADR:"&@ADR:&¶&TELEFOON 1&¶&FAX 1&¶&MOBILE 1&¶&BIJZET&¶&"@HOR:"&@HOR:&¶&"@COD:"&@COD:&¶

 

thx

[Fitch]

Use something along these lines:

 

Case( not IsEmpty( @BAR ) ; "@BAR:" & @BAR & ¶ ) &

Case( not IsEmpty( @ENT ) ; "@ENT:" & @ENT & ¶ ) &

etc.

[leelou]

HI FITCH

Thank for answers but when i export the file whit your calculation i got this

 

@BAR:123456678900

@ENT:RAEPSAET Paul

@NUM:1.14212.54.004

@NOM:Dr. RAEPSAET Paul

@SPE:

@ADR:Dorpsstraat 102

2940 STABROEK

 

GSM: 0486/70.35.41

 

 

@HOR:

@COD:123456678900

 

not good space inside line our carriage return

 

AND I NEED

To be export like this

 

@BAR:123456678900

@ENT:RAEPSAET Paul

@NUM:1.14212.54.004

@NOM:Dr. RAEPSAET Paul

@SPE:

@ADR:Dorpsstraat 102

2940 STABROEK

GSM: 0486/70.35.41

@HOR:

@COD:123456678900

that is the good result not space line our carriage return

and when there is no text like see first post the fax line in formule

he set me a space our carriage return and text is not thogether

thank you