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.
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:
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. |
User | Count |
---|---|
91 | |
79 | |
62 | |
36 | |
36 |