Inserting bullet point into a webi document

building reports webintelligence
1

Hello experts,

I have tried to search and am not getting the answer I was looking for. I have created a readme file in MS Word in where there is a group of instructions that are organized with bullets ansd sub-bullets

For example

*instruction
—*sub-instruction
—*sub-instruction
*instruction
—*sub-instruction
—*sub-instruction
I would like to use bullets instead of asterisk!

Is there any way I can copy this text from my Word document and get it to show in the above format in my webi document?

Thanks in advance,
Niraj

Nkakad (BOB member since 2010-09-21)

2

I would try to use image option or HTML.

Marfi :poland: (BOB member since 2006-12-18)

3

Or you could try something suggested by a fellow Bobber, here:-
https://bobj-board.org/t/142668

Mak 1 :uk: (BOB member since 2005-01-06)

4

Hello Marfi, Mak1

Thanks for the reply.

@marfi- I am not sure what you mean by using image…should I convert my word doc to an image and paste it in a free cell specifying it as image?

@mak1- I saw this thread and when I copy the text in that code:

Replace([MyText];Char(13);Concatenate(Char(13);Char(168);Char(9)))

[My Text]=the text I copied from my word doc.(approx 30 bullet and sub-bullet lines), and I dont change anything else in the variable it displays all of the variable text in the report like:

replace([…
…
…
…
…
…
…
];Char(13);Concatanate(char(13);char(168);char(9))).

Also I am unable to format it where I have the sub-bullets indented.

Hope this is clear.

Thanks,
Niraj

Nkakad (BOB member since 2010-09-21)

5

By using image I meant to include image of the bullet point in webi doc. But nevermind since Mak’s solution sounds better.

I think what you do incorrectly is that:
[MyText] should be a column with a record for each point of your text. Also every formula should start with “=” like this: =Replace([MyText]…

Marfi :poland: (BOB member since 2006-12-18)

6

Niraj,

Maybe, you should look at doing this differently? If you created this as an extra tab as a Webi table whiting out the lines e.t.c. You may be able to use the suggested formula, on a text literal.
Unsure, if you used “=” before the formula acting against your Word doc import?
Also, you could use images as Marfi suggested, however, these can be tricky to get lined up, display wise, in the report, in the first place…

Cheers,

Mark.

Mak 1 :uk: (BOB member since 2005-01-06)

7

Hello all,

Sorry for the delay in response!

I dont know if I am understanding this correctly. I have tried several options listed bellow

=replace([THis is my first bullet point text];Char(13);Concatenate(Char(13);Char(168);Char(9)))

I get an error saying that:The object ‘[THis is my first bullet point text]’ at position 9 does not exist in the report. (Error: WIS 10006).

replace([THis is my first bullet point text];Char(13);Concatenate(Char(13);Char(168);Char(9)))

Here when i go to test the formula, it automatomatically places an “=” before the fromula and also surrounds the entire formula with " "

=“replace([THis is my first bullet point text];Char(13);Concatenate(Char(13);Char(168);Char(9)))”
So when I drag this object into my horizontal or vertical table it displays the everything in the formula beginning with the word “replace”.

I never imported anything to WEBi, I just copy the text from word doc and paste it into the formula. Could this be my Problem for the error I receive?
Sorry if I am missing something trivial! :oops:
Thanks again
Niraj

Nkakad (BOB member since 2010-09-21)