Calculation Problem with carriage returns

[whun450]

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, 2008 by Guest

[_henry_]

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?

[whun450]

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

[Lee Smith]

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

[_henry_]

Hi William,

You're welcome ;-]