Hello everyone. I have a project where I scraped a ton of data into separate lists. I then write the lists to excel...no problem...works great. The problem I have come across is the final list of data. It was a bear to scrape and as it turns out it scraped in list form (which is what I wanted) but ONE list item equals 8 lines of text in the list. So my question is, how do I sort the list into groups of 8 lines (or 8 list items as it is read) to add 8 lines into one spreadsheet cell? Any help would be greatly appreciated! Thank you.
John
Hello John,
You first read the file as Text Content, and you can then use the split text action, and use a Standard Delimiter to separate New Lines, (where you make sure you enter x8 to separate the content into a List (where each item of the list will have 8 lines)
Hope this works for you. Let me know if you find any difficulties.
:)
Samantha
Rome wasn't built in a day..
Rome wasn't built in a day..