[B! sed] wlbhiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

wlbhiro id:wlbhiro

sedã«é–¢ã™ã‚‹wlbhiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

2.9. sed â€” ã©ã‚“ãã‚Šã®æ£®ã¨å¤ã„åœ°å›³
2.9. sed# sed ã¯æ–‡å—åˆ—å¤‰æ›ã‚’è¡Œã†ãŸã‚ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã® 1 ã¤ã§ã™ã€‚sed ã¯ awk ã¨åŒæ§˜ã«ã€ã‚³ãƒžãƒ³ãƒ‰ã‚„ bash ãªã©ã¨çµ„ã¿åˆã‚ã›ã¦åˆ©ç”¨ã§ãã¾ã™ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã®å†…å®¹ã«å¯¾ã—ã¦ã€ç‰¹å®šã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç½®æ›ã—ãŸã‚Šã€ç‰¹å®šã®è¡Œã‚’å‰Šé™¤ã—ãŸã‚Šã¨ã„ã£ãŸå‡¦ç†ãŒå¯èƒ½ã§ã‚ã‚Šã€ç°¡ä¾¿ã§ã‚ã‚ŠãªãŒã‚‰å¼·åŠ›ãªæ–‡å—åˆ—å‡¦ç†æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ 2.9.1. åŸºæœ¬æ–‡åž‹# sed ã¯åŸºæœ¬çš„ã«ã€æŒ‡å®šã—ãŸè¡Œï¼ˆã‚¢ãƒ‰ãƒ¬ã‚¹ï¼‰ã«å¯¾ã—ã¦æŒ‡å®šã—ãŸå‡¦ç†ã‚’è¡Œã†ã€ã¨ã„ã†æ–‡åž‹ã‚’ã¨ã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€ã‚¢ãƒ‰ãƒ¬ã‚¹ 1 ã«å¯¾ã—ã¦ã‚³ãƒžãƒ³ãƒ‰ 1 ã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã¯ã€æ¬¡ã®ã‚ˆã†ã«è¨˜è¿°ã—ã¾ã™ã€‚
wlbhiro 2021/12/05
linux

DNS

sed
ãƒªãƒ³ã‚¯
Ansibleã§ãƒ•ã‚¡ã‚¤ãƒ«ã®è¡Œã‚’æ›¸ãæ›ãˆã‚‹3ã¤ã®æ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
wlbhiro 2020/12/12
ansible

sed

replace
ãƒªãƒ³ã‚¯
sed - ãƒžãƒƒãƒã—ãŸæ–‡å—åˆ—ã‚’å†åˆ©ç”¨ã™ã‚‹ - è¡Œæœ«ã«æ–‡å—åˆ—ã‚’è¿½åŠ ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
wlbhiro 2019/11/24
sed

regex
ãƒªãƒ³ã‚¯
viã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ æ–‡å—åˆ—ç½®æ›
viã§ã®ç½®æ›ã¯:sã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ :%s/ç½®æ›å‰ã®æ–‡å—åˆ—/ç½®æ›å¾Œã®æ–‡å—åˆ—/gã€€ã§é–‹ã„ã¦ã„ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«å…¨ã¦ã«ãŠã„ã¦ç½®æ›ã‚’ã—ã¾ã™ã€‚ç½®æ›ã‚’ã™ã‚‹ã‹ã©ã†ã‹ã‚’ç¢ºèªã—ãŸã„å ´åˆã¯ä»¥ä¸‹ã®ã‚ˆã†ã«cã‚’ã¤ã‘ã¾ã™ã€‚ ï¼š%s/ç½®æ›å‰æ–‡å—åˆ—/ç½®æ›å¾Œæ–‡å—åˆ—/gc ãƒ‘ã‚¹åãªã©ã‚’å¤‰æ›´ã™ã‚‹éš›ã«ã¯/ã‚’åŒºåˆ‡ã‚Šæ–‡å—ã«ä½¿ã†ã®ã§ã¯ãªãã€;ãªã©ã‚’åŒºåˆ‡ã‚Šæ–‡å—ã«ä½¿ã†ã¨ä¾¿åˆ© %s;/var/home;/home;gc æ–‡ç« å…¨ä½“ã§ãªãã€ç‰¹å®šç¯„å›²ã®ã¿ç½®æ›ã—ãŸã„å ´åˆã¯ç½®æ›ã—ãŸã„è¡Œã®ç¯„å›²ã‚’æŒ‡å®šã™ã‚Œã°ã‚ˆã„ã€‚ [ä¾‹] - 63è¡Œç›®ã‹ã‚‰79è¡Œç›®ã¾ã§ã§beautyã‚’hairnailã«ä¸€æ‹¬ç½®æ› :63,79s /beauty/hairnail/g ãƒžãƒƒãƒãƒ³ã‚°ã‚’åˆ©ç”¨ã—ãŸç½®æ›ã¯æ£è¦è¡¨ç¾ã‚’ä½¿ã„ã¾ã™ã€‚ [ä¾‹] :s /$$.*$/$form->{'\1'}/g ãƒžãƒƒãƒã—ãŸéƒ¨åˆ†$.*$ã¯\1ã«å…¥ã‚‹ã®ã§ã€ä¾‹ãˆã°$certCompanyEngã¯$form->{'
wlbhiro 2018/06/11
regex

vim

sed

Linux
ãƒªãƒ³ã‚¯
sedã®æœ€çŸä¸€è‡´
ã“ã‚Œã¯ã€è¤‡æ•°ã®ãƒžãƒƒãƒãƒ³ã‚°ãŒè€ƒãˆã‚‰ã‚Œã‚‹å ´åˆãªã‚‹ã¹ãé•·ã„ã‚‚ã®ã«ãƒžãƒƒãƒã™ã‚‹ï¼ˆæœ€é•·ä¸€è‡´ï¼‰ã‹ã‚‰ã§ã‚ã‚‹ã€‚ã“ã®æ€§è³ªã¯sedã«é™ã£ãŸã“ã¨ã§ã¯ãªãã¦æ£è¦è¡¨ç¾å…¨èˆ¬ã«è¨€ãˆã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æœ€é•·ä¸€è‡´ã§ã‚ã‚‹ã€‚ æœ€çŸä¸€è‡´ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒã¤è¨€èªžã‚‚ã‚ã‚‹ãŒã€sedã«ã¯ç„¡ã„ã®ã§ä½•ã‚‰ã‹ã®å·¥å¤«ãŒå¿…è¦ã¨ãªã‚‹ã€‚ä»Šå›žã®å ´åˆã¯ã€é–‰æ‹¬å¼§ãŒç¾ã‚ŒãŸæ™‚ç‚¹ã§ä¸€æ—¦ãƒžãƒƒãƒãƒ³ã‚°ã‚’ã‚„ã‚ã‚‹ã‚ˆã†ã«ã™ã‚Œã°ã„ã„ã®ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ã«æ›¸ãã¨æ€æƒ‘ã®ãƒ‡ãƒ¼ã‚¿ãŒãˆã‚‰ã‚Œã‚‹ã€‚
wlbhiro 2016/07/01
Linux

sed
ãƒªãƒ³ã‚¯
MySQL ã‹ã‚‰ Excel ã§ä½¿ãˆã‚‹ CSV ã‚’ä½œæˆã—ã¾ã™ï¼ã§ãã‚‹ã ã‘ç°¡å˜ã«â™ª
MySQL ã«ã¯ CSV å‡ºåŠ›ã™ã‚‹æ©Ÿèƒ½ãŒå‚™ã‚ã£ã¦ã„ã‚‹ã“ã¨ã«ã€åˆã‚ã¦æ°—ãŒã¤ãã¾ã—ãŸã€‚ å–œã³å‹‡ã‚“ã§è©¦ã—ã¦ã¿ãŸã‚‚ã®ã®ã€Excel ã§ã¯ã©ã†ã«ã‚‚ã†ã¾ãèªã¿è¾¼ã‚ã¾ã›ã‚“ã€‚ç‰¹ã«ã€ã‚»ãƒ«å†…ã§æ”¹è¡ŒãŒã‚ã‚‹ã¨ã€æ¬¡ã®è¡Œã¨ã„ã†æ‰±ã„ã«ãªã£ã¦ã—ã¾ã†ã®ã§ã™ã‚ˆãã€‚ã€‚ã€‚ ãã“ã§ã€ä½•ã¨ã‹ã—ã¦ã¿ãŸãƒ¡ãƒ¢ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒˆ ä»Šæ™‚ãªã®ã§ MySQL ã¯ UTF-8 ã§ã™ã€‚Excel ã§èªã‚€ãŸã‚ã« Shift-JIS ã«å¤‰æ›´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚»ãƒ«å†…ã§ã®æ”¹è¡Œã¯ LFã€è¡Œæœ«ã®æ”¹è¡Œã¯ CRLF ã«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚»ãƒ«ã‚’ã€Œâ€ã€ã§å›²ã‚€å ´åˆãŒã‚ã‚‹ãŸã‚ã€ã€Œâ€ã€ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚„ã£ã¦ã¿ãŸ ã¾ãšã¯ CSV å‡ºåŠ›ã™ã‚‹ MySQL ã§ã™ã€‚2ç¨®é¡žã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã¯ SELECT ã‚’ä½¿ã†æ–¹æ³•ã§ã™ã€‚ mysql> SELECT * FROM wp_posts INTO OUTFILE "/tmp/wp_posts.csv
wlbhiro 2016/06/24
MySQL

SQL

CSV

Excel

sed
ãƒªãƒ³ã‚¯
é€†å¼•ãUNIXã‚³ãƒžãƒ³ãƒ‰/sedã§æŒ‡å®šã—ãŸè¡Œã‚’å‰Šé™¤ã™ã‚‹æ–¹æ³• - Linuxã¨éŽã”ã™
sedã‚³ãƒžãƒ³ãƒ‰ã§å…ˆé ã‹ã‚‰ä½•è¡Œã‚’å‰Šé™¤ã™ã‚‹â€ ä»¥ä¸‹ã®æ›¸å¼ã§æŒ‡å®šè¡Œã‚’å‰Šé™¤ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ sed -e 'é–‹å§‹è¡Œ,å‰Šé™¤è¡Œd' ãƒ•ã‚¡ã‚¤ãƒ«å ã¾ãŸã¯ cat ãƒ•ã‚¡ã‚¤ãƒ«å | sed -e 'é–‹å§‹è¡Œ,å‰Šé™¤è¡Œd' å®Ÿè¡Œçµæžœ 1è¡Œç›®ã‹ã‚‰10è¡Œç›®ã¾ã§å‰Šé™¤ã•ã‚Œã¦ã„ã¾ã™ã€‚ $ sed -e '1,10d' text.txt 11 12 13 14 15 16 17 18 19 20 â†‘ sedã‚³ãƒžãƒ³ãƒ‰ã§æŒ‡å®šè¡Œã‹ã‚‰æŒ‡å®šè¡Œã¾ã§ã‚’å‰Šé™¤ã™ã‚‹â€ ä¸Šè¨˜ã¨åŒã˜ã§é–‹å§‹è¡Œã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šç¯„å›²æŒ‡å®šã§ãã¾ã™ã€‚ sed -e 'é–‹å§‹è¡Œ,å‰Šé™¤è¡Œd' ãƒ•ã‚¡ã‚¤ãƒ«å ã¾ãŸã¯ cat ãƒ•ã‚¡ã‚¤ãƒ«å | sed -e 'é–‹å§‹è¡Œ,å‰Šé™¤è¡Œd' å®Ÿè¡Œçµæžœ 5è¡Œç›®ã‹ã‚‰15è¡Œç›®ã‹ã‚‰æœ€çµ‚è¡Œã¾ã§å‰Šé™¤ã•ã‚Œã¦ã„ã¾ã™ã€‚ $ cat text.txt | sed -e '5,15d' 1 2 3 4 16 17 18 19 20 â†‘
wlbhiro 2016/06/17
Linux

sed
ãƒªãƒ³ã‚¯
sedã§è¡Œé ã®ç©ºç™½ã‚’é™¤åŽ»ã™ã‚‹ - Study Memo
æ£è¦è¡¨ç¾ã§ã„ã‘ã‚‹ã‹ãªã£ã¦æ€ã£ãŸã‚‰ã¡ã‚‡ã£ã¨ã¯ã¾ã£ãŸã€‚ æœ€åˆã€sedã§è¡Œé ç©ºç™½ã‚’é™¤åŽ»ã™ã‚‹ãŸã‚ã«ã€æ¬¡ã®sedã‚’æ›¸ã„ã¦ã¿ãŸã€‚ sed -e 's/^\s+//g' hogehoge.txt ã§ã‚‚ã€ã©ã†ã‚‚ã“ã‚Œã¯ãƒ€ãƒ¡ã‚‰ã—ãã€æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ãŸã‚‰ã†ã¾ãã„ã£ãŸã€‚ sed -e 's/^[ ]*//g' hogehoge.txt
wlbhiro 2016/05/31
Linux

sed
ãƒªãƒ³ã‚¯
é€†å¼•ãUNIXã‚³ãƒžãƒ³ãƒ‰/æŒ‡å®šã—ãŸç¯„å›²ã®è¡Œã‚’å–å¾—ã™ã‚‹æ–¹æ³• - Linuxã¨éŽã”ã™
æŒ‡å®šã—ãŸç¯„å›²è¡Œã®ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹æ–¹æ³•â€ ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã®ä½•è¡Œç›®ã‹ã‚‰ä½•è¡Œç›®ã¾ã§ã¨æŒ‡å®šã—ãŸç¯„å›²ã®ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’ä»¥ä¸‹ã«è¨˜ã—ã¾ã™ã€‚ sedã‚³ãƒžãƒ³ãƒ‰ã€headã¨tailã‚³ãƒžãƒ³ãƒ‰ã®çµ„ã¿åˆã‚ã›ã§å–å¾—ã™ã‚‹2ã¤ã®ä¾‹ã‚’è¨˜ã—ã¾ã™ã€‚
wlbhiro 2016/03/21
æŒ‡å®šã—ãŸè¡Œã‚’å–ã‚Šå‡ºã™æ–¹æ³•ã€‚

Shell Script

sed
ãƒªãƒ³ã‚¯
ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§ãŠæ‰‹è»½å®Ÿè¡Œå¯èƒ½ãªsedå…¥é–€ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
wlbhiro 2015/05/22
Linux

sed
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
wlbhiro 2015/05/22
htmlã‚¿ã‚°é™¤åŽ»

Linux

sed
ãƒªãƒ³ã‚¯
sed é€£ç¶š (ç©ºç™½|ã‚¹ãƒšãƒ¼ã‚¹) ç½®æ›
é€£ç¶šã—ãŸç©ºç™½(ã‚¹ãƒšãƒ¼ã‚¹)ã‚’ã‚³ãƒãƒ³ã«ç½®æ› æˆåŠŸã—ãŸä¾‹(OK): $ sed 's/Â Â */:/g' hoge.txt $ sed 's/\s\s*/:/g' hoge.txt $ sed 's/[[:blank:]][[:blank:]]*/:/g' hoge.txt å¤±æ•—ã—ãŸä¾‹(NG): $ sed 's/ +/:/g' hoge.txt $ sed 's/\s+/:/g' hoge.txt $ sed 's/[[:blank:]]+/:/g' hoge.txt ä½•æ•…ï¼Ÿ
wlbhiro 2015/04/05
è¤‡æ•°ã‚¹ãƒšãƒ¼ã‚¹ã‚’ç½®æ›ã™ã‚‹æ–¹æ³•

Linux

sed
ãƒªãƒ³ã‚¯
1