Hello all, I know this has to be simple but I'm having a calculation issue and I guess I'm thinking to hard. Basically I want a calculation field that takes multiple fields and make it comma separated. So what I would like to create a calculation with static labels for the first row and calculations for the other rows that create something like:

Name,Address,Phone

Bill Smith, 211 Main st,5551234567

Steve Jones, 300 W. Jackson,5553456789

I am using this calculation:

Name,Address,Phone

Namefld1 & "," & Addressfld1 & "," & Phonefld1¶

Namefld2 & "," & Addressfld2 & "," & Phonefld2¶

But that just isn't working. Can someone please help me with the format. Thanks so much,

William

Edited July 7, 200817 yr by Guest

Hi William,

Name,Address,Phone

Bill Smith, 211 Main st,5551234567

Steve Jones, 300 W. Jackson,5553456789

I am using this calculation:

Name,Address,Phone

Namefld1 & "," & Addressfld1 & "," & Phonefld1¶

Namefld2 & "," & Addressfld2 & "," & Phonefld2¶

Try to put this "&" before "¶" like this:

Namefld1 & "," & Addressfld1 & "," & Phonefld1 & ¶ &

Namefld2 & "," & Addressfld2 & "," & Phonefld2 & ¶ 

Is that what you want to achieve?

Henry,

It's amazing how we stare so hard we miss how simple it is

That did it! Thanks so much for your help!!

William

Use _henry_ calculation, however you don't need the second Pilcrow (paragraph symbol), unless there is more to this. Also, and I would put a space behind each of the comma to make it more readable.

Question.

What do you want to see if one or more of the fields are empty?

Lee

Hi William,

You're welcome ;-]