Convert table to list with a certain format

[Ionut_Frincu (Ionuţ Frincu)]

Hello guys, I want to scrape a website for multiple items with their specifications and I want to extract this type of table into a list with the following format: Jaw Depth (In.):5/8 | Jaw Height (in.):1-1/4 | Jaw Width (In.):4-1/2 | ETC…
But each item has a different number of specification:

What approach is the easiest and the best for this? Thank you

[Nithinkrishna]

Hey @Ionut_Frincu

I hope you would have already scrapped it into a table from website.

Now let’s convert it into a list,

Assuming dt_Data is your variable.

dt_Data.AsEnumerable.Select(Function(row) String.Join(":", row.ItemArray))

Hope this helps you.

Thanks
#nK

[Ionut_Frincu (Ionuţ Frincu)]

Hello @Nithinkrishna thanks for your response, what about if I want to conver this table to a string with " | " as delimiter for each row? Thank you :

[Nithinkrishna]

Hey @Ionut_Frincu

You can just replace the : from the above code snippet with |

Thanks
#nK

[Ionut_Frincu (Ionuţ Frincu)]

@Ionut_Frincu

Hello @Nithinkrishna thanks for your response, what about if I want to conver this table to a string with " | " as delimiter for each row? Thank you :

Actually I want to convert this type of table into a single line string with each row delimited by " | ":

Stock Number	11706
Weight (Lbs.)	74
Jaw Depth (In.)	2
Jaw Width (In.)	5
Opening Capacity Max (In.)	5

this format : Stock Number 11706 | Weight (Lbs.) 74 | Jaw Depth (In.) 2 | Jaw Width (In.) 5 | Opening Capacity Max (In.) 5

do you have any idea?
Thank you in advance!

[Nithinkrishna]

Hey @Ionut_Frincu

String.Join(" | ", dt_Data.AsEnumerable.Select(Function(row) String.Join(" ", row.ItemArray)))

Hope this helps

Thanks
#nK

[Ionut_Frincu (Ionuţ Frincu)]

@Nithinkrishna

String.Join(" | ", dt_Data.AsEnumerable.Select(Function(row) String.Join(" ", row.ItemArray)))

Yes, this is what I was looking for. Thank you my friend!

Best regards!

[Nithinkrishna]

Cool @Ionut_Frincu

Enjoy it

[Aleem_Khan (crazy bot)]

can you please share workflow I am getting error