Urgent......TEXT formatting

[davi123]

In a table, database feild Comments cantain following data:

*first line item. * second line item. * third line item.

I would like to display in crystal report this data as;

first line item.
second line item.
third line item.

There can any number of line items in Comments database feild. there can be one, two,three, anynumber seperated by *. Comments is a VARCHAR2 field which is storing the data as text.

Please let me know some solution
Thanks

 

[pgtek]

hi
create a group for the content

cheers

pgtek

 

[davi123]

Can you please let me know how?

Thanks in advance

 

[pgtek]

hi
just click on the tool bar insert and then group
select the comment field
and then keep group together and repeat group header on new page

cheers

pgtek

 

[lbass]

The following works in 8.0.

space(1) + replace(replace({table.string},"*"," &quot,".", "." + chr(13))

Please note that I used a " " (including an empty space) instead of "" in the replace function because the replace function doesn't work correctly using "" in 8.0 (or in mine without hotfixes, anyway). You can try "" if you wish. I had to add the space(1) at the beginning in order to get the lines to align properly, but you may or may not need that.

You MUST format the formula to "can grow" in order to see all lines of the text.

-LB

 

[davi123]

lbass,

Thank you very much. Your solution is really helpful for me. This is what exactly I was looking for.

space(1) + replace(replace({table.string},"*"," &quot,".", "." + chr(13))

In place of space I need a bullet(.) in front of each line. Can you pls tell me how I can do that.

Again thanks for your help.

 

[lbass]

Then you could use the asterisk as the bullet by using this instead:

space(1) + replace({table.string},".", "." + chr(13))

-LB