トップ > スプレッドシートで奈良県の包括免許とフェムトセルを取得

スプレッドシートで奈良県の包括免許とフェムトセルを取得

docs.google.com

fetch

  • A1

=IMPORTDATA("https://www.tele.soumu.go.jp/musen/list?ST=1&DA=1&SC=1&DC=1&OF=1&OW=FB_H&IT=E&NA=%8Ay%93V%83%82%83o%83C%83%8B")

musen

  • A1

=TRANSPOSE(SPLIT(fetch!Z2, "\n\n",FALSE))

musen-split

=TRANSPOSE(SPLIT(SUBSTITUTE(SUBSTITUTE(CONCATENATE(musen!A2:A),"\n","")," ",""), ")",FALSE))

femtocell

  • A1

=TRANSPOSE(SPLIT(fetch!Z3, "\n\n",FALSE))

femtocell-split

  • A1

=TRANSPOSE(SPLIT(SUBSTITUTE(SUBSTITUTE(CONCATENATE(femtocell!A2:A),"\n","")," ",""), ")",FALSE))