How to split the field string and display in the same field?

[narayanaqlik]

Hi All,

Have a nice day..!

i have one field in one of my report with huge length like <affhgg="123"Id="123gvn7558"><fujhhfjsh="0878"><invoice id="72468hjj">... so on nearly 10 to 15 times are there

So i want to display all values in the same field and same row but those are one by one like wrap text

InvoiceID

ID	Invoice ID
1	<affhgg="123"Id="123gvn7558"> <fujhhfjsh="0878"> <invoice id="72468hjj">
2	<affhgg="123"Id="123gvn7558"> <fujhhfjsh="0878"> <invoice id="72468hjj">

<fujhhfjsh="0878">

<invoice id="72468hjj">

...

...

...

so on so How ?

Thanks in advance

[tresesco]

Try incorporating new line character chr(10), like:

=Replace([Invoice ID], '><', '>'&chr(10)&'<')

and then use ,multi-line header setting in the chart.

[olivierrobin]

hello

if '>' is the ending delimiter of the strings

try to replace '>' by '>' & chr(10)

so that each string appears on one line