Scroll to top

Um aus einem Text bspw: [v] Name (Jahr) welches in einer Zeile steht nur den Namen zu extrahieren.

Bei einem Feld mag das noch gehen, nicht aber wenn es sich um über 500 handelt.

 

[v] Name (Jahr) [v] Name (Jahr)

Google Sheets

Select Cells -> Data -> Spilt Text to Columns -> Custom -> “]”

Select Cells -> Data -> Spilt Text to Columns -> Custom -> “(“

_

You can then Download that Sheet, as a CSV-File and Upload it to https://overflow.religionandstory.com/imdb/

Which then searched thru all the Movie Titles for you.

 

Related posts

Post a Comment

Your email address will not be published. Required fields are marked *