I have several fields in a column and if the field is empty I would like that field not to show and the next field with data in it to be moved up.

Sort of like this

Field 1 125487

Field 2 (empty)

Field 3 (empty)

Field 4 258791

Field 1 125487

Field 4 258791

Is this possible?

Hi,

In define fields, create a new calculation Case(not Is Empty(your field),1,0)

Use this calc as the sort key field.

Thanks Ugo. How are you doing today. Hope all is well with you.

Yep. Take care.

are you talking fields here or sorted portals?

Ugo's calc will not work with 4 fields.

If you just want to have the empty fields removed in print, try the sliding feature in Layout mode. If you want to display the values without gaps in browse mode, set up a calc field "display" with the following formula:

If(isempty(field1)"",field1 &"q|") &

If(isempty(field1)"",field2 &"q|") &

If(isempty(field1)"",field3 &"q|") &

If(isempty(field1)"",field4).

You can adjust the line spacing & border properties in Layout mode to make this field look like seperate fields.

Christian, what is "q|"?

(Maybe that is a silly question but this is the 2nd time I've seen it from you in one day?

Bonnie

That's the paragraph symbol (the reverse 'p' when you define a calc.

Steve

Why not use

Lee,

I've seen some users saying that this character wasn't displayed properly depnding on the browser.

Well, I don't have this symbol on my keeboard I think.

Actually, I open my FM, go in calc, and copy the symbol from a calc where it is used.

Then, I paste it on the post.

Sometimes, when I'm lazy, I use the "PP" too...

Is there a easier way to do it ?

Hi Ugo,

It depends on your Keyboard setup if you can do this or not. Personally, using a British format keyboard, I cannot do this, but the keyboard shortcuts for other keyboard layouts are as follows, if none of these work then as far as I know you cannot get the symbol by using keyboard shortcuts.

Try these:

Ctrl Alt 6

Ctrl Alt P

Ctrl Alt R

Ctrl Alt ;

Shift Ctrl Alt 6

Shift Ctrl Alt P

Shift Ctrl Alt R

Shift Ctrl Alt ;

Hope one of these work for you!

Ed.

Hi Ed,

Doesn't seems to work for me. Thanks anyway.

Is this a browser problem, language, operating system, font or just Keyboard?

Hi Ugo, using the PP is common on the other lists as a substitution.

Lee

Sorry Ugo, the instructions are for a PC, are you on a Mac?

Does anyone know which key is allocated with the number 0182? On my keyboard if I do Alt+0182 it supposedly should display the Paragraph symbol.

Lee, as far as I know it is just which keyboard layout you select, but as I say I'm Windows user.

If you ARE on windows, go to Start > Programs > Accessories > System Tools > Character Map

(This may be slightly different on other Win OS -this if for 2k)

If you then click on the paragraph symbol on screen, it shows you the keystroke necessary to receive this.

On mine it shows Alt+0182 but haven't a clue what key 0182 is!

I think using "q|" for "

Excellent idea Chrisitian

Ed.

Alt 7 on a Mac gives me the carriage return.

Alt 6 on mine (French)...

I finally found it.

Does anyone know which key is allocated with the number 0182? On my keyboard if I do Alt+0182 it supposedly should display the Paragraph symbol.

It certainly works for me on a Windows 2000 PC.

Alt+0182 (on numeric keypad) results in