Formula help

[2328]

I have a text like this stored in a field ,CR 10 VStudio

[Maaac Ddddddd]
---------------------

sssssssssssssssssssssssssssssss.

[N/A Criteria]
----------------

Ffffffffffffffffffff

[Cn Criteria]

------------------------

abcdkkkkkkkkkkkkkkkkkkkkkkkkkkkkk.

I have to bold the text in square brackets and if possible remove square brackets.

Thanks in advance

 

[lbass]

Create a formula to replace the field:

if instr({table.field},"[") > 0 then
"<b>"+replace(replace({table.field},"[",""),"]","")+"</b>" else
{table.field}

Then right click on the formula->format field->paragraph->text interpretation->HTML text.

-LB

 

[2328]

Thanks Lbass, thank you very much.

The above formula , converting every thing into bold and concatenation all the lines stored in that field.
its should show the blank lin

Maaac Ddddddd ?--------------------- ?ssssssssssssssssssssssssssssssss?. ?N?/?A Criteria ?---------------- ?TFfffffffffffffffffff ?Cn Criteria ?----------- ?abcdkkkkkkkkkkkkkkkkkkkkkkkkkkkkk.-?

 

[lbass]

I have no idea what you mean. Please try again.

-LB

 

[2328]

This is the text in the field

[?Metric Definition]?
---------------------?
Confirmation that the form has been uploaded to WebEx by WTIS?/?Exp Coordinator identifying WTIS?/?Exp Coordinator and HPC resources?.?

[?N?/?A Criteria?]?
----------------?
This metric is applicable to ALL facilities?.?

[?Completion Criteria?]?
------------------------?
Status ?= ?COMPLETE if form has been uploaded to WebEx?. ?All fields in form do NOT have to be complete?.?

[?Process?]?
-----------?
HDM?-?01?

[?Information Source?]?
------------------------?
Directory?: ?WTIS Expansion Contacts?

[?Deployment Specialist?]?
---------------------------?
E?-?CAT?


This is the output from your formula


Metric Definition ?--------------------- ?Confirmation that the form has been uploaded to WebEx by WTIS?/?Exp Coordinator identifying WTIS?/?Exp Coordinator and ?
HPC resources?. ?N?/?A Criteria ?---------------- ?This metric is applicable to ALL facilities?. ?Completion Criteria ?------------------------ ?Status ?= ?COMPLETE if form has been ?
uploaded to WebEx?. ?All fields in form do NOT have to be complete?. ?Process ?----------- ?HDM?-?01 ?Information Source ?------------------------ ?Directory?: ?WTIS Expansion ?
Contacts Deployment Specialist ?--------------------------- ?E?-?CAT?

 

[2328]

Thank Lbass,
There are no question marks on the above text.
I copied and pasted the text.

 

[lbass]

You still have not identified the issue, but let me guess--the returns have been eliminated and you want them back in? I don't understand why you are showing the question marks. What character is in that position? A space?

-LB

 

[lbass]

I think I see now. I didn't realize that what you were showing me was all one instance of the field. Try the following instead:

replace(replace(replace({table.string},"[","<b>"),"]","</b>"),chr(13),"<br>")

Be sure to format it to HTML Text interpretation. If that doesn't work, replace chr(13) with chr(10).

-LB

 

[2328]

Thanks , even I was try the same way,
Any how Thank you very much , it works.
Once again thanks