create a bullet list in a field 2

[hatemgamil]

hi all

i have a field name "Main Causes" and it's value in my report always looks like that

Main Casuses
---------------------------------------
brake defect,wrong signal,kkllk,dd

i want to make it looks like a bullet list
•brake defect
•wrong signal
•kkkllkl
•dsd

i want some help to do so

thnx

 

[hatemgamil]

i have did something that gives what i am looking for

creating a formula

"• "&replace({dt.MainCauses_En},',',chr(13)&"•")

chr(13) which means Enter button
but the problem in this solution that it adds
a bullet like this:
•brake defect
•wrong signal
•kkkllkl
•dsd
•

 

[fisheromacse]

maybe something like this...

IF not(onlastrecord)
then
"• "&replace({dt.MainCauses_En},',',chr(13)&"•")
else
"• "&replace({dt.MainCauses_En},','," ")

 

[BobSuruncle]

Is there a final comma at the end of the list? (you don't show one in your example)
If so, then strip it off and then do the replace.

Local stringVar x := {dt.MainCauses_En} ;
if Right(x,1) = "," 
then "• " & Replace ( Left(x,Length(x) -1),"," , chr(13)&"• " )
else "• " & Replace (x ,"," , chr(13)&"• " )

Should be close to being right.


Bob Suruncle

 

[lbass]

stringvar x := "• " & replace({dt.MainCauses_En},',',chr(13)+"• ");
left(x,len(x)-3)

-LB

 

[chelseatech]

Use Mid(x,3) to remove the first few characters.

If you don't enter a length on the mid function it takes from that position to the end of the string.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[hatemgamil]

thnx all

thnx lbass i did what u sent and it works perfectly