Convert Datatable to list of strings with bullets

Help Activities
, , ,
1

Hi Everyone,

I need to convert Datatable to list of strings with bullets:

Please find the attached snap:
image

Please guide me on this.

Regards,
Sandhya.

2

You can do this using HTML, try something like this:

HTMLWithCondition.txt (336 Bytes)

3 
Assign finalString = "<UL>"
For Each Row in Datatable
 - assign finalString = finalstring + "<LI> " + CurrentRow("Name column").ToString + " - " + CurrentRow("State").ToString + " - " + CurrentRow("Program column").ToString
// end for each
Assign finalString = finalString + "</UL>"

Basically you’re just looping through the rows in the datatable and building each one into an HTML string the way you want it with the bullet at the beginning of each line.

1 Like
4

Hi @postwick,

I tried, but nothing is displayed on the screen.
Please find the attached snaps for your reference:

image
image

Regards,
Sandhya.

5

Hi @sandhya.govindharam ,

Could you let us know where do you have to display this as a Bulleted list ?
Does the Datatable contain 3 Columns and so we have 3 hyphens (-) used as separators ?

6

Hi,

I tried, but it showed results like the ones below:

image
image768×251 9.92 KB

Please explain in some depth.

Thanks,
Sandhya.

7

Hi,

No, I need to display the one-column values in one list with bullets.

We don’t know how many rows are available in that respected column.

I need to display these values in Mail.

Regards,
Sandhya.

8

Please try again with these 2 methodes. Hope it helps!

HTMLWithCondition (1).txt (604 Bytes)

9

Hi,

I solved the issue. I am able to print the values into a list using the Invoke methods with the stringbuider method.

Thanks,
Sandhya.

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.