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:
WW | Member | Highlight |
---|---|---|
WW25 | MemA | GREEN
|
WW25 | MemB | RED
|
Experimental but cannot work as expected:
continuous following up from this question:
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.
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
Or even mark "Green" as with color green.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.