Forum Discussion
anupambit1797
Aug 01, 2023Iron Contributor
How to color specific bits in all rows with a Single command or a Function?
Dear Experts, I want to color the specific bits(bit0~1, bit2~6,....) like in the attached sheet, but want to do for all rows how can this be achieved for all rows? Thanks i...
peiyezhu
Aug 02, 2023Bronze Contributor
'How about online sql?
create temp table aa as
select rowid,highfont(substr(Column1,1,2))||highfont(substr(Column1,3,3),'blue')||highfont(substr(Column1,6,5),'pink')||highfont(substr(Column1,11,2),'grey') dyn,highfont(substr(Column1,1,2)),highfont(substr(Column1,3,3),'blue'),highfont(substr(Column1,6,5),'pink'),highfont(substr(Column1,11,2),'grey') from color_the_specific_bits;
select "'"||dyn dyn from aa;