I have a list of videos for which I want to easily see the number of views. Is there a way to do that with REGEXREPLACE, or some other way?

CodePudding user response：

try:

=REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(A1)); 
 "where Col1 starts with 'viewCount'"; ); "\d ")*1