Bold and point form

Question

Hi all

How do I make part of the string bold and break down the concatenated output into three lines?

I have concatenated three fields: [incident], [Cause] & [Solution].

example: “Incident:” +” “+ [Incident] +”  “+ “Cause:” +” “+[Cause]…

This is the output I want:

Incident: The bolt was 2mm out of spec.

Cause: obsolete drawing was issued.

Solution:  remove obsolete drawings from the system.

Sifiso · Answer

Hi FrederikE

Thanks for trying, I think my request was misleading, let me rephrase it.

I want the logic that will put the text in point form in the same cell.

Example: If this delimiter “|” is picked up then start below

Current situation

ID

Summary

0001

The bolt was 2mm out of spec. | obsolete drawing was issued. | remove obsolete drawings from the system.

Required Output

ID

Summary

0001

- The bolt was 2mm out of spec.

- obsolete drawing was issued.

- remove obsolete drawings from the system.

FrederikE · Answer

Hey @Sifiso,

In order to format your text you would need Reporting tools and write the output using a Render tool.

See the attached example WF.

e.g. as an excel:

TextFormat.yxmd