# How to create the list from Table data column?

**URL:** <https://forums.eggplantsoftware.com/t/how-to-create-the-list-from-table-data-column/8185>\
**Category:** Uncategorized\
**Created:** [December 8, 2022, 10:39am UTC](https://forums.eggplantsoftware.com/t/how-to-create-the-list-from-table-data-column/8185 "2022-12-08T10:39:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thanagaraj](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/t/e495f1/32.png) [@Thanagaraj](https://forums.eggplantsoftware.com/u/Thanagaraj)\
**Post date:** [December 8, 2022, 10:39am UTC](https://forums.eggplantsoftware.com/t/how-to-create-the-list-from-table-data-column/8185/1 "2022-12-08T10:39:08Z")

</div>

Hello Team,

I have webpage contains tables with few filter option.  
The table have five columns

When we apply filter few columns ( 2 or 3 columns) data will be empty and remaining data will be populated against the column.

Eg.

* * *

## Column1| Column 2 | Column 3 | column 4 | column 5 |

```
                                      Test1 12.03.2022
                                      Test 2 14.04.2023 OK
                                       Test 3 12.01.2022

```

* * *

Now I need create the separate list for column3 & column4.

for that I used drag and drop command captured the table info into remote clipboard. But text cleaning is very challenging.

Clipboard data:

12/8/22, 11:16:39 AM Log   
\t  
\t

Test 0  
\t14.10.2021 11:27:45 \t  
\t  
\t

Test1  
\t08.11.2021 11:45:02 \t  
\t  
\t

Test2 new item  
\t06.07.2022 07:32:19 \t  
\t  
\t

Test3  
\t14.05.2021 13:35:23 \t  
\t  
\t

Test4  
\t14.10.2021 08:32:59 \t  
\t  
\t

Test 5 and R API  
\t12.10.2021 11:21:08 \t  
\t  
\t

Test 6  
\t14.10.2021 11:10:00 \t

if applying put trimall(remoteclipboarddata)  
The output combined both column data as like below  
Test014.10.202111:27:45Test108.11.202111:45:02Test2 new item06.07.202207:32:19Test314.05.202113:35:23Test414.10.202108:32:59Test5API12.10.202111:21:08Test614.10.202111:10:00

---

<div class="post-metadata">

**Author:** ![Thanagaraj](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/t/e495f1/32.png) [@Thanagaraj](https://forums.eggplantsoftware.com/u/Thanagaraj)\
**Post date:** [December 9, 2022, 3:28am UTC](https://forums.eggplantsoftware.com/t/how-to-create-the-list-from-table-data-column/8185/2 "2022-12-09T03:28:02Z")

</div>

After multiple tries got the answer:  
put 1 into count  
put [] into list\_name  
repeat with each line of remoteclipboard\_record\_dump  
put trimall(it) into line\_dump  
if count modulo 5 is zero – based on item postion either 4 or 5 or 6  
insert line\_dump into list\_name  
end if  
add 1 to count  
end repeat  
log list\_name  
result as below:

[“Test0”,“Test1”,“Test2newitem”,…]

---

<div class="post-metadata">

**Author:** ![SenseTalkDoug](https://forums.eggplantsoftware.com/user_avatar/forums.eggplantsoftware.com/sensetalkdoug/32/88_2.png) [@SenseTalkDoug](https://forums.eggplantsoftware.com/u/SenseTalkDoug)\
**Post date:** [January 3, 2023, 9:28pm UTC](https://forums.eggplantsoftware.com/t/how-to-create-the-list-from-table-data-column/8185/3 "2023-01-03T21:28:12Z")

</div>

Something along this line may also work for you:

```auto
put each line of remoteclipboard_record_dump where (the counter +1) is divisible by 5 into list_name
put list_name

```