{"blog_title":"\u30aa\u30fc\u30ed\u30e9\u3055\u3093\u306e\u52c9\u5f37\u5e33","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/auroralights/20220327/20220327195200.png","blog_url":"https://auroralights.jp/","title":"\u3010Excel\u3011LEN\u30fbLENB\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5168\u89d2\u30fb\u534a\u89d2\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u65b9\u6cd5\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e \uff5e\u60c5\u30b7\u30b9\u3042\u308b\u3042\u308b\u3002Excel\u306e\u7533\u8acb\u66f8\u30fb\u4f9d\u983c\u66f8\u3067\u4f7f\u3048\u308b\u77e5\u8b58\uff5e","type":"rich","url":"https://auroralights.jp/entry/2022/03/28/214500","version":"1.0","author_name":"auroralights","description":"\u60c5\u30b7\u30b9\u3067\u50cd\u3044\u3066\u3044\u308b\u3068\u3001Excel\u306e\u7533\u8acb\u66f8\u30fb\u4f9d\u983c\u66f8\u3067\u30e6\u30fc\u30b6\u304b\u3089\u4f9d\u983c\u304c\u304f\u308b\u30b1\u30fc\u30b9\u306f\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002\u307e\u305f\u3001\u767b\u9332\u30fb\u66f4\u65b0\u3059\u308b\u30c7\u30fc\u30bf\u304c\u5165\u529b\u3055\u308c\u305fExcel\u3084CSV\u30d5\u30a1\u30a4\u30eb\u304c\u6dfb\u4ed8\u3055\u308c\u3066\u4f9d\u983c\u304c\u304f\u308b\u3088\u3046\u306a\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002\u305d\u306eExcel\u3092\u57fa\u306b\u30b7\u30b9\u30c6\u30e0\u306e\u7ba1\u7406\u8005\u753b\u9762\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u76f4\u63a5SQL\u3067\u767b\u9332\u3084\u66f4\u65b0\u3092\u884c\u3046\u306e\u3067\u3059\u304c\u3001\u30e6\u30fc\u30b6\u304b\u3089\u9001\u4ed8\u3055\u308c\u305fExcel\u306e\u30c7\u30fc\u30bf\u306b\u4e0d\u5099\u304c\u591a\u3044\u3053\u3068\u591a\u3044\u3053\u3068\u3002 \u5168\u89d2\u3001\u534a\u89d2\u306e\u30eb\u30fc\u30eb\u304c\u5b88\u3089\u308c\u3066\u3044\u306a\u304b\u3063\u305f\u308a\u3001\u5fc5\u9808\u9805\u76ee\u306e\u5165\u529b\u304c\u6f0f\u308c\u3066\u3044\u305f\u308a\u3001\u6587\u5b57\u6570\u304c\u8d85\u904e\u3057\u3066\u3044\u305f\u308a\u3002\u4eca\u56de\u306f\u305d\u3093\u306a\u3068\u304d\u306b\u4f7f\u3048\u308b\u5168\u89d2\u30fb\u534a\u89d2\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3044\u305f\u3057\u307e\u3059\u3002 LEN\u95a2\u6570\u3001LENB\u95a2\u6570\u306e\u8aac\u660e LEN\u95a2\u6570 LENB\u95a2\u6570 LE\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fauroralights.jp%2Fentry%2F2022%2F03%2F28%2F214500\" title=\"\u3010Excel\u3011LEN\u30fbLENB\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5168\u89d2\u30fb\u534a\u89d2\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u65b9\u6cd5\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e \uff5e\u60c5\u30b7\u30b9\u3042\u308b\u3042\u308b\u3002Excel\u306e\u7533\u8acb\u66f8\u30fb\u4f9d\u983c\u66f8\u3067\u4f7f\u3048\u308b\u77e5\u8b58\uff5e - \u30aa\u30fc\u30ed\u30e9\u3055\u3093\u306e\u52c9\u5f37\u5e33\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/auroralights/","width":"100%","provider_url":"https://hatena.blog","published":"2022-03-28 21:45:00","height":"190","categories":["Excel"]}