Forum Discussion

appeljr's avatar
appeljr
Frequent Visitor
6 years ago
Solved

Combine two or more rows between two words (datasource with random carriage returns)

I'm pulling book data from OCLC WorldCat which is uneven, at best, when it comes to the book Title. What I need is to identify the portion of the Title that is getting knocked into Column1.1 prior to...
Need Help
appeljr's avatar
appeljr
Frequent Visitor
6 years ago

Yes, Greg_Deckler and ImkeF : it's a plaintext file as formatted in the code box, and there's sadly no cleaner (fast) source for the kind of bulk pull I'm doing.

  • appeljr's avatar
    appeljr
    Frequent Visitor
    6 years ago

    Perfect! I've learned so much from your expertise!