I would like to change some specific string to a specific format like "line break" or "bullet" or "color text". Example: Original Table: WWMemberHighlightWW25MemAGREEN || ProjectA || Description-AWW25MemBRED || ProjectB || Description-B SQL Expected result: WWMemberHighlightWW25MemAGREEN * ProjectA* Description-A WW25MemBRED * ProjectB* Description-B Experimental but cannot work as expected: * REPLACE(T1.'Highlight',"||",FORMATWIKI("\n"+ "* " + "\n") ) as 'Hightlight-formated' continuous following up from this question: how to merge row cell by SQL Thanks

Hi @huangbin chen , We can suggest the following SQL query for your table: SELECT *, FORMATWIKI(REPLACE(T1.'Highlight',"||", "\n"+ "* " + "\n")) as 'Hightlight-formated' FROM T* I'm afraid that the multiple-level bullets that are shown on your screenshot are not possible to implement.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to repalce a string with specific format by SQL

huangbin chen_f0oevs

I would like to change some specific string to a specific format like "line break" or "bullet" or "color text".

Example:

Original Table:

WW	Member	Highlight
WW25	MemA	GREEN \|\| ProjectA \|\| Description-A
WW25	MemB	RED \|\| ProjectB \|\| Description-B

SQL Expected result:

Member

Highlight

WW25

MemA

GREEN

ProjectA
- Description-A

WW25

MemB

RED

ProjectB
- Description-B

Experimental but cannot work as expected:

REPLACE(T1.'Highlight',"||",FORMATWIKI("\n"+ "* " + "\n") ) as 'Hightlight-formated'

continuous following up from this question:

how to merge row cell by SQL

Thanks

Accepted answers

Katerina Kovriga _Stiltsoft_

Hi @huangbin chen ,

We can suggest the following SQL query for your table:

SELECT *,
FORMATWIKI(REPLACE(T1.'Highlight',"||", "\n"+ "* " + "\n")) as 'Hightlight-formated'
FROM T*

Tue 5-1.png

I'm afraid that the multiple-level bullets that are shown on your screenshot are not possible to implement.

All comments

Katerina Kovriga _Stiltsoft_

Hi @huangbin chen ,

We can suggest the following SQL query for your table:

SELECT *,
FORMATWIKI(REPLACE(T1.'Highlight',"||", "\n"+ "* " + "\n")) as 'Hightlight-formated'
FROM T*

Tue 5-1.png

I'm afraid that the multiple-level bullets that are shown on your screenshot are not possible to implement.

huangbin chen_f0oevs

Thanks @Katerina Kovriga _Stiltsoft_ ,

Is is possible to have "color text" or "bold type" at specific separate char?

Source Example: Green || Project A >> Description-A

Expected result:

Green

Project A
Description-A

Or even mark "Green" as with color green.

Katerina Kovriga _Stiltsoft_

The FORMATWIKI function works with the contents of the cell as a whole unit: you can color/make bold all the text but not specific strings (that are also different for every cell).

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

sql

jira

jira-server