Hi here,
am having an issue with importing data from a scraper software. I have about 1000 records in a csv file, and the problem involves the opening hours. In the file, the “business hours” are returned in a format such that the entry ends in: “Su 14:00-21:00”
When i look at the place listing sample / demo file, the business hours need to end with ],[“UTC”:”+0″] . So i somehow, within the same column, need to add ],[“UTC”:”+0″] to the end of the business hours entry for each listing. Is there any way i can add this to all entries at the same time, rather than individually pasting it into the end of each listing? I can see that that would take me hours! 🙁
Of course, i am aware that i would later need to change the “0” depending on which state / time zone the business is in etc, but i can do that part with the “replace” feature of excel. Thats not a problem. The issue is just adding it originally to each line in the first place.
Many thanks as usual
andrew rother 5 years, 5 months ago.
