# Formula for concatenating multiple fields with "commas" to seperate values

Gurus,

I could use some help figuring out how to write a formula for this problem:

I have 6 separate currency fields to concatenate in one field.  I have to eliminate values of 0.

I wrote a formula like this:
if isnull({field 1}) or {field 1} <= 0 then "" else Cstr({field 1}, 0, "") & "% Fiber"

I can't figure out how to include the commas (,) to separate more than one value or eliminate the comma if there's only one value.

The result would display something like this:
10% Fiber, 5% Protein

...or in cases where there's only one value:
10% Fiber

Can you help?

Steve
LVL 7
###### Who is Participating?

Commented:
Try this formula

``````Local StringVar strOut;

if Not(isnull({field 1})) AND  {field 1} > 0 then
strOut := " " & Cstr({field 1}, 0, "") & "% Fiber";
if Not(isnull({field 1})) AND  {field 2} > 0 then
strOut := ", " & Cstr({field 2}, 0, "") & "% Protein";
if Not(isnull({field 1})) AND  {field 3} > 0 then
strOut := ", " & Cstr({field 3}, 0, "") & "% String3";
if Not(isnull({field 1})) AND  {field 4} > 0 then
strOut := ", " & Cstr({field 4}, 0, "") & "% String4";
if Not(isnull({field 1})) AND  {field 5} > 0 then
strOut := ", " & Cstr({field 5}, 0, "") & "% String5";
if Not(isnull({field 1})) AND  {field 6} > 0 then
strOut := ", " & Cstr({field 6}, 0, "") & "% String6";

Mid(strOut,2)
``````

mlmcc
0

Author Commented:
Thanks SO much mlmcc!

I needed them to all be added together so I just added a "strOut"

strOut := strOut + ", " & Cstr({field 2}, 0, "") & "% Protein";

Thanks for pointing me in the right direction!!!

Steve
0

Author Commented:
Thanks mlmcc!!!
0

Commented:
Sorry, that should have been in the solution

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.