{"id":16341,"date":"2024-04-15T14:56:44","date_gmt":"2024-04-15T05:56:44","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16341"},"modified":"2025-09-15T17:44:38","modified_gmt":"2025-09-15T08:44:38","slug":"textfinder-class-%eb%a9%94%ec%86%8c%eb%93%9c-%ec%86%8c%ea%b0%9c","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/04\/15\/textfinder-class-%eb%a9%94%ec%86%8c%eb%93%9c-%ec%86%8c%ea%b0%9c\/","title":{"rendered":"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc758 TextFinder class \uba54\uc18c\ub4dc \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"\n1. \uc694\uc57d<\/a>
\n2. TextFinder Class \uc54c\uc544\ubcf4\uae30<\/a>
\n 2.1 findAll()<\/a>
\n 2.2 findNext()<\/a>
\n 2.3 findPrevious()<\/a>
\n 2.4 matchCase()<\/a>
\n 2.5 matchEntireCell()<\/a>
\n 2.6 matchFormulaText()<\/a>
\n 2.7 replaceAllWith()<\/a>
\n 2.8 useRegularExpression()<\/a>
\n\n\n\n

1. \uc694\uc57d<\/h2>\n\n\n\n

\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 textFinder Class \uc758 \ub2e4\uc591\ud55c \uba54\uc18c\ub4dc\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4. createTextFinder\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0 \uc54c\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 \ub2e4\uc74c\uc758 \uc5f0\uc7ac \ud3ec\uc2a4\ud305\uc744 \ucc38\uc870\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

Spreadsheet class\uc758 createTextFinder()<\/a><\/p>\n\n\n\n

Sheet class\uc758 createTextFinder()<\/a><\/p>\n\n\n\n

Range class\uc758 createTextFinder()<\/a>
<\/p>\n\n\n\n

2. TextFinder Class \uc54c\uc544\ubcf4\uae30<\/h2>\n\n\n\n


TextFinder\uc758 \uba54\uc18c\ub4dc\ub4e4\uc744 \uccb4\uc774\ub2dd \ubc29\uc2dd\uc73c\ub85c \ud638\ucd9c\ud558\uc5ec \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud83d\udca1 \uccb4\uc774\ub2dd \ubc29\uc2dd\uc774\ub780?<\/strong>
\uccb4\uc774\ub2dd \ubc29\uc2dd\uc740 \ud55c \uc904\uc5d0 \uc5ec\ub7ec \uba54\uc18c\ub4dc \ud638\ucd9c\uc744 \uc5f0\uacb0\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uba54\uc18c\ub4dc \ud638\ucd9c \ud6c4 \ubc18\ud658\ub41c \uac1d\uccb4\ub97c \ub2e4\uc74c \uc5f0\uacb0\ub41c \uba54\uc18c\ub4dc\uc758 \ud638\ucd9c \ub300\uc0c1\uc73c\ub85c \uc0ac\uc6a9\ud558\uc9c0\uc694. \uc911\uac04 \ub2e8\uacc4\uc758 \uacb0\uacfc\ub97c \ubcc0\uc218\uc5d0 \ud560\ub2f9\ud558\uc9c0 \uc54a\uace0\ub3c4 \uba54\uc18c\ub4dc\ub97c \uc5f0\uc18d\uc801\uc73c\ub85c \ud638\ucd9c\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \ucf54\ub4dc\uac00 \uac04\uacb0\ud574\uc9c0\uba70 \uac00\ub3c5\uc131\uc774 \ub192\uc544\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc758 \ucf54\ub4dc\ub294 \uc2dc\ud2b8\uc758 \uc9c0\uc815\ub41c \ubc94\uc704\uc758 \uac12\uc744 \uac00\uc838\uc624\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

function getDataFromSpreadsheet() {\n  \/\/ \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.\n  const SPREADSHEET = SpreadsheetApp.getActiveSpreadsheet();\n  const SHEET = spreadsheet.getActiveSheet();\n  \n  \/\/ \uc2dc\ud2b8\uc758 \ubc94\uc704\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \n  const range = sheet.getRange(\"A1:B5\");\n\n  \/\/ \ud574\ub2f9 \ubc94\uc704\uc758 \uac12\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.\n  const data = range.getValues();\n  \n  \/\/ \uac00\uc838\uc628 \ub370\uc774\ud130\ub97c \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4.\n  Logger.log(data);\n}<\/code><\/pre>\n\n\n\n
\uc774 \ucf54\ub4dc\ub97c \uccb4\uc774\ub2dd \ud558\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<\/p>\n\n\n\n
function getDataFromSpreadsheet() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  const data = SHEET.getRange(\"A1:B5\").getValues();\n  Logger.log(data);\n}<\/code><\/pre>\n\n\n\n
\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ubd88\ub7ec\uc624\uace0, \ud65c\uc131\ud654\ub41c \uc2dc\ud2b8\ub97c \ubd88\ub7ec\uc624\ub294 \ucf54\ub4dc\ub97c 1\uc904\ub85c \ucd95\uc57d\ud558\uc600\uace0, \ub370\uc774\ud130 \ubc94\uc704\ub97c \uc9c0\uc815\ud558\uace0 \ud574\ub2f9 \ubc94\uc704\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ucf54\ub4dc\ub3c4 1\uc904\ub85c \uc904\uc600\uc2b5\ub2c8\ub2e4. \uc774\uc640 \uac19\uc774 \uccb4\uc774\ub2dd \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uba74 \ucf54\ub4dc\ub97c \uac04\uacb0\ud558\uac8c \uc791\uc131\ud560 \uc218 \uc788\uc73c\uba70, \uc5f0\uc18d\uc801\uc778 \uc791\uc5c5\uc744 \ubcf4\ub2e4 \uc27d\uac8c \ud45c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.

<\/p>\n\n\n\n
<\/p>\n\n\n\n
3.1 findAll()<\/h2>\n\n\n\n

\uc124\uc815\ud55c \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\uc640 \uc77c\uce58\ud558\ub294 \ubaa8\ub4e0 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uace0 Range\ub97c \ubc30\uc5f4 \ud615\uc2dd<\/strong>\uc73c\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4.
<\/p>\n\n\n\n
\uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

<\/h5>\n\n\n\n
function findText() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\ucc3e\uace0\uc790 \ud558\ub294 \ud14d\uc2a4\ud2b8\").findAll();\n}<\/code><\/pre>\n\n\n\n

\uc608\uc2dc

<\/h5>\n\n\n\n
\uc544\ub798\uc758 \uace0\uac1d \ubaa9\ub85d\uc5d0\uc11c, \u2018\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>\u2019 \uace0\uac1d\uc744 \ubaa8\ub450 \ucc3e\uae30 \uc704\ud574 findAll()<\/code><\/mark><\/strong>\uc744 \uc0ac\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud558\uac8c, \ucc3e\uc740 \uac12\uc758 \uc704\uce58\ub97c Logger.log()<\/mark><\/code><\/strong>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc8fc\uc758\ud574\uc57c \ud558\ub294 \uc810\uc740 findAll\uc740 \ucc3e\uc740 \uac12\uc758 \ubc94\uc704\ub97c \ubc30\uc5f4 \ud615\uc2dd\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.

<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\ucf54\ub4dc

<\/h5>\n\n\n\n
\n\t\t\n\t\t\t
<\/div>\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t
1<\/div>
2<\/div>
3<\/div>
4<\/div>
5<\/div>
6<\/div>
7<\/div>
8<\/div>
9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
function<\/span> <\/span>findAll<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
  <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
  <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“\uc624\ud1a0\uc624\ud53c\uc2a4”<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
 <\/div>
  <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>text<\/span> =><\/span> <\/span>{<\/span><\/div>
    <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>text<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
    <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span><\/div>
  <\/span>}<\/span>)<\/span>;<\/span><\/div>
}<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

\ucf54\ub4dc \uc124\uba85

<\/h5>\n\n\n\n
    \n
  1. SHEET.createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\").findAll()<\/mark><\/code><\/strong>: \uac00\uc838\uc628 \uc2dc\ud2b8\uc5d0\uc11c “\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>“\ub77c\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uae30 \uc704\ud574 createTextFinder()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec TextFinder<\/mark><\/code><\/strong> \uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c findAll()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc694\uc18c\ub97c \ucc3e\uc2b5\ub2c8\ub2e4. \uadf8 \uacb0\uacfc\ub97c textFinder<\/mark><\/code><\/strong> \ubcc0\uc218\uc5d0 \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
  2. textFinder.forEach(text => { ... })<\/mark><\/code><\/strong>: textFinder<\/mark><\/code><\/strong><\/code>\uc5d0\ub294 findAll()<\/mark><\/code><\/strong><\/code>\uc5d0 \uc758\ud574 \ubc18\ud658\ub41c \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uacb0\uacfc\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
    \ud83d\udca1 findAll()<\/mark><\/code><\/strong><\/code><\/code> \uba54\uc18c\ub4dc\ub294 \ubc30\uc5f4\uc744 \ubc18\ud658\ud558\uae30 \ub54c\ubb38\uc5d0 \ubc30\uc5f4\uc744 \uc21c\ud68c\ud558\uba74\uc11c \uac01 \uc694\uc18c\ub97c \ucc98\ub9ac\ud574\uc57c \ud558\ubbc0\ub85c forEach<\/mark><\/code><\/strong>\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
      \n
    1. let row = text.getRow()<\/mark><\/code><\/strong>: text<\/code><\/strong> <\/mark>\ubcc0\uc218\ub294 \uac01 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uacb0\uacfc(\ubc94\uc704)\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. getRow()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \ud589 \ubc88\ud638\ub97c \uac00\uc838\uc624\uace0, \uc774\ub97c row<\/code><\/strong> <\/mark>\ubcc0\uc218\uc5d0 \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
    2. Logger.log()<\/mark><\/code><\/strong>: \ub85c\uadf8\uc5d0 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uacb0\uacfc\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4.
      <\/li>\n<\/ol>\n\n\n\n
      \ud55c\ubc88 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?<\/p>\n\n\n
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      \ubaa8\ub4e0 \uac12\uc744 \ucc3e\uc544\ub0c8\uace0, \ub85c\uadf8\uc5d0 \uc798 \uc800\uc7a5\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c findNext() \uba54\uc18c\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

      <\/p>\n\n\n\n
      3.2 findNext()<\/h2>\n\n\n\n

      \uc774 \uba54\uc18c\ub4dc\ub294 \uac80\uc0c9 \uae30\uc900\uacfc \uc77c\uce58\ud558\ub294 \ub2e4\uc74c \uc140\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.

      <\/p>\n\n\n\n
      \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

      <\/h5>\n\n\n\n
      function findNext() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\ud14d\uc2a4\ud2b8\");\n  let foundCell = textFinder.findNext();\n}<\/code><\/pre>\n\n\n\n

      \uc608\uc2dc

      <\/h5>\n\n\n\n
      \uc774\ubc88\uc5d0\ub294 \uc544\ub798\uc758 \uace0\uac1d \ubaa9\ub85d\uc5d0\uc11c \u2018\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>\u2019 \uace0\uac1d\uc744 \ubaa8\ub450 \ucc3e\uae30 \uc704\ud574 findNext()\ub97c \uc0ac\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ucc3e\uc740 \uac12\uc758 \uc704\uce58\ub97c Logger.log()\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

      <\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      \ucf54\ub4dc

      <\/h3>\n\n\n\n
      function findNext() {\n  let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\");\n\n  let occurrence;\n  while (occurrence = textFinder.findNext()) {\n    let row = occurrence.getRow();\n    Logger.log(`\uac80\uc0c9 \uacb0\uacfc: ${row}\ud589\uc744 \ucc38\uc870\ud558\uc138\uc694`)\n  }\n}<\/code><\/pre>\n\n\n\n

      \ucf54\ub4dc \uc124\uba85

      <\/h3>\n\n\n\n
        \n
      1. SHEET.createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\")<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec “\uc624\ud1a0\uc624\ud53c\uc2a4”\ub77c\ub294 \ubb38\uc790\uc5f4\uc744 \ucc3e\uae30 \uc704\ud55c TextFinder<\/code><\/strong> <\/mark>\uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
      2. while<\/mark><\/code><\/strong> \ub8e8\ud504\ub97c \uc0ac\uc6a9\ud558\uc5ec textFinder.findNext()<\/strong><\/mark><\/code>\ub97c \ud638\ucd9c\ud569\ub2c8\ub2e4. \uc774 \uba54\uc18c\ub4dc\ub294 \u2018\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>\u2019 \ubb38\uc790\uc5f4\uc744 \ucc3e\uc740 \uacbd\uc6b0 \ud574\ub2f9 \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\ub294 Range<\/code><\/strong> <\/mark>\uac1d\uccb4\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
      3. \ub8e8\ud504 \ub0b4\ubd80\uc5d0\uc11c\ub294 \ubc1c\uacac\ub41c \ubb38\uc790\uc5f4\uc758 \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\ub294 Range<\/code><\/strong> <\/mark>\uac1d\uccb4\uc5d0\uc11c \ud589 \ubc88\ud638\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. getRow()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud589 \ubc88\ud638\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
      4. \uac00\uc838\uc628 \ud589 \ubc88\ud638\ub97c \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud558\uc5ec \uac80\uc0c9\ub41c \uacb0\uacfc\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4.
        <\/li>\n<\/ol>\n\n\n\n
        \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?
        <\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        \ubaa8\ub4e0 \uac12\uc744 \ucc3e\uc544\ub0b4\uc11c \uc798 \ucd9c\ub825\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740, \ubc18\ub300\ub85c findPrevious\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

        <\/p>\n\n\n\n
        3.3 findPrevious()<\/h2>\n\n\n\n

        \uac80\uc0c9 \uae30\uc900\uacfc \uc77c\uce58\ud558\ub294 \uc774\uc804 \uc140\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. findPrevious()\ub294 \uac80\uc0c9 \uacb0\uacfc\ub85c\ubd80\ud130 \uc5ed\ubc29\ud5a5\uc73c\ub85c \uac80\uc0c9\uc744 \uc2dc\uc791\ud569\ub2c8\ub2e4.

        <\/p>\n\n\n\n
        \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

        <\/h5>\n\n\n\n
        function findPrevious() {\n  let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\uac80\uc0c9 \ud14d\uc2a4\ud2b8\");\n  let occurrence = textFinder.findPrevious();\n}<\/code><\/pre>\n\n\n\n

        \uc608\uc2dc

        <\/h5>\n\n\n\n
        \uc774\ubc88\uc5d0\ub294 \uc544\ub798\uc758 \uace0\uac1d \ubaa9\ub85d\uc5d0\uc11c \u2018\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>\u2019 \uace0\uac1d\uc744 \ubaa8\ub450 \ucc3e\uae30 \uc704\ud574 findPrevious()<\/strong>\ub97c \uc0ac\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ucc3e\uc740 \uac12\uc758 \uc704\uce58\ub97c Logger.log()<\/strong>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

        <\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n


        \ucf54\ub4dc

        <\/h5>\n\n\n\n
        function findPrevious() {\n  let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\");\n\n  let occurrence;\n  while (occurrence = textFinder.findPrevious()) {\n    let row = occurrence.getRow();\n    Logger.log(`\uac80\uc0c9 \uacb0\uacfc: ${row}\ud589\uc744 \ucc38\uc870\ud558\uc138\uc694`);\n  }\n}<\/code><\/pre>\n\n\n\n

        \ucf54\ub4dc \uc124\uba85

        <\/h5>\n\n\n\n
          \n
        1. SHEET.createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\")<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec “\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>“\ub77c\ub294 \ubb38\uc790\uc5f4\uc744 \ucc3e\uae30 \uc704\ud55c TextFinder<\/mark><\/code><\/strong> \uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
        2. while<\/mark><\/code><\/strong> \ub8e8\ud504\ub97c \uc0ac\uc6a9\ud558\uc5ec textFinder.findPrevious()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \ud638\ucd9c\ud569\ub2c8\ub2e4. \uc774 \uba54\uc18c\ub4dc\ub294 “\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>” \ubb38\uc790\uc5f4\uc744 \ucc3e\uc740 \uacbd\uc6b0 \ud574\ub2f9 \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\ub294 Range<\/code><\/strong> <\/mark>\uac1d\uccb4\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.
          <\/li>\n<\/ol>\n\n\n\n
          \ud83d\udca1 \uc5ec\uae30\uc11c findPrevious()<\/code><\/strong><\/mark>\ub294 \u2018\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>\u2019 \ud14d\uc2a4\ud2b8\ub97c \ub9c8\uc9c0\ub9c9\ubd80\ud130 \uac80\uc0c9\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubc18\ubcf5\ubb38\uc5d0 \uc758\ud574 2\ubc88\uc9f8\ubd80\ud130 findPrevious()<\/code><\/strong><\/mark>\uac00 \uc2e4\ud589\ub420 \ub54c\uc5d0\ub294 \uc774\uc804 \uac80\uc0c9 \uacb0\uacfc\ubd80\ud130 \uc5ed\uc21c\uc73c\ub85c \uac80\uc0c9\uc744 \uc2dc\uc791\ud558\ubbc0\ub85c \uac80\uc0c9 \uacb0\uacfc \uac12\uc774 findNext()<\/code><\/strong><\/mark>\ub97c \uc0ac\uc6a9\ud560 \ub54c\uc640\ub294 \ubc18\ub300 \ubc29\ud5a5\uc73c\ub85c \uc120\uc5b8\ub429\ub2c8\ub2e4.
          <\/p>\n\n\n\n
            \n
          1. \ub8e8\ud504 \ub0b4\ubd80\uc5d0\uc11c\ub294 \ubc1c\uacac\ub41c \ubb38\uc790\uc5f4\uc758 \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\ub294 Range<\/code><\/strong><\/mark>\uac1d\uccb4\uc5d0\uc11c \ud589 \ubc88\ud638\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. getRow()<\/code><\/strong><\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud589 \ubc88\ud638\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
          2. \uac00\uc838\uc628 \ud589 \ubc88\ud638\ub97c \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud558\uc5ec \uac80\uc0c9\ub41c \uacb0\uacfc\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4.
            <\/li>\n<\/ol>\n\n\n\n
            \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?
            <\/p>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            \ubaa8\ub4e0 \uac12\uc744 \uc798 \ucc3e\uc544\ub0b4\uace0 \uc788\ub124\uc694. \uc720\uc758\ud560 \uc810\uc740 findPrevious()\ub97c \uc0ac\uc6a9\ud558\uc600\uae30 \ub54c\ubb38\uc5d0 \ub9c8\uc9c0\ub9c9 \uac80\uc0c9 \uacb0\uacfc\ub85c\ubd80\ud130 \uc5ed\uc21c\uc73c\ub85c \uacb0\uacfc \uac12\uc774 \ucd9c\ub825\ub418\uace0 \uc788\ub2e4\ub294 \uc810\uc774\uc9c0\uc694.

            <\/p>\n\n\n\n
            3.4 matchCase()<\/h2>\n\n\n\n

            matchCase() \uba54\uc18c\ub4dc\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc744 \ub54c \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud560\uc9c0 \uc5ec\ubd80\ub97c \uc9c0\uc815\ud558\ub294 \ubd88\ub9ac\uc5b8(boolean) \uac12\uc785\ub2c8\ub2e4. \uc989, matchCase(true)\ub85c \uc124\uc815\ub418\uba74 \uac80\uc0c9\ud560 \ub54c \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uace0, matchCase(false)\ub85c \uc124\uc815\ub418\uba74 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c matchCase(false)\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.

            <\/p>\n\n\n\n
            \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95
            <\/h5>\n\n\n\n
            function matchCase() {\n  let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\ud14d\uc2a4\ud2b8\").matchCase(true);\n}<\/code><\/pre>\n\n\n\n

            \uc608\uc2dc

            <\/h5>\n\n\n\n
            \uc544\ub798 \uc608\uc2dc\uc5d0\ub294 \u2018autooffice\u2019\uc640 \u2018AUTOOFFICE\u2019 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4. findAll()\uba54\uc18c\ub4dc\uc640 matchCase()\ub97c \ud65c\uc6a9\ud558\uc5ec \uc18c\ubb38\uc790 \ud615\uc2dd\uc758 \ub370\uc774\ud130\ub9cc \ucc3e\uc544\ub0b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. findAll\uc5d0\uc11c matchCase()\uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \uae30\ubcf8\uc801\uc73c\ub85c\ub294 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84 \uc5c6\uc774 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ucc3e\uc544\ub0c5\ub2c8\ub2e4.

            <\/p>\n\n\n
            \n
            \"\"<\/figure>\n<\/div>\n\n\n

            \uba3c\uc800, matchCase()\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 findAll()\uc744 \uc0ac\uc6a9\ud558\uc5ec \u2018autooffice\u2019\ub97c \uac80\uc0c9\ud558\uba74 \uc5b4\ub5a4 \uacb0\uacfc\uac00 \ub098\uc624\ub294\uc9c0 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
            <\/p>\n\n\n\n
            \n\t\t\n\t\t\t
            <\/div>\n\t\t\t
            \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
            \n\t\t\t\t\t
            1<\/div>
            2<\/div>
            3<\/div>
            4<\/div>
            5<\/div>
            6<\/div>
            7<\/div>
            8<\/div>
            9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
            function<\/span> <\/span>findAll<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
              <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
              <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“autooffice”<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
             <\/div>
              <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span><\/div>
              <\/span>}<\/span>)<\/span>;<\/span><\/div>
            }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

            createTextFinder()\ub294 \uae30\ubcf8\uc801\uc73c\ub85c matchCase\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uace0 \ud14d\uc2a4\ud2b8\uac00 \uc77c\uce58\ud558\ub294 \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc758 \ub85c\uadf8\ub97c \ubcf4\uba74 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uace0 \u2018autooffice\u2019 \ud14d\uc2a4\ud2b8\uac00 \uc874\uc7ac\ud558\ub294 \ubaa8\ub4e0 \ud589 \uc704\uce58\ub97c \ubc18\ud658\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.
            <\/p>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            \uc774\uc81c matchCase()\ub97c \ud65c\uc6a9\ud558\uc5ec \uc18c\ubb38\uc790\ub85c \uae30\uc785\ub41c \u2018autooffice\u2019 \uac12\uc744 \ucc3e\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
            <\/p>\n\n\n\n
            \ucf54\ub4dc

            <\/h5>\n\n\n\n
            \n\t\t\n\t\t\t
            <\/div>\n\t\t\t
            \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
            \n\t\t\t\t\t
            1<\/div>
            2<\/div>
            3<\/div>
            4<\/div>
            5<\/div>
            6<\/div>
            7<\/div>
            8<\/div>
            9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
            function<\/span> <\/span>matchCase<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
              <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
              <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“autooffice”<\/span>)<\/span>.<\/span>matchCase<\/span>(<\/span>true<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
             <\/div>
              <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span><\/div>
              <\/span>}<\/span>)<\/span>;<\/span><\/div>
            }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

            \ucf54\ub4dc \uc124\uba85

            <\/h5>\n\n\n\n
              \n
            1. createTextFinder(\"autooffice\")<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14d\uc2a4\ud2b8 \ucc3e\uae30 \ub3c4\uad6c(TextFinder)\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
            2. matchCase(true)<\/strong><\/mark><\/code>\ub97c \ud638\ucd9c\ud558\uc5ec \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc5ec \uac80\uc0c9\ud558\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
            3. findAll()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc140\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n
            4. forEach()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01\uac01\uc758 \ubc1c\uacac\ub41c \ud56d\ubaa9\uc5d0 \ub300\ud574 \ubc18\ubcf5\ud558\uace0, \uac01 \ud56d\ubaa9\uc758 \ud589\uc744 \uac00\uc838\uc640 \ub85c\uadf8\uc5d0 \ud574\ub2f9 \ud589\uc744 \ucc38\uc870\ud558\ub294 \uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
              <\/li>\n<\/ol>\n\n\n\n
              \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

              <\/p>\n\n\n
              \n
              \"\"<\/figure>\n<\/div>\n\n\n

              \ub300\ubb38\uc790\ub85c \uc785\ub825\ub418\uc5c8\ub358 \u2018AUTOOFFICE\u2019 \ud14d\uc2a4\ud2b8\ub97c \uc81c\uc678\ud558\uace0, \uc18c\ubb38\uc790\ub85c \uc785\ub825\ub41c \u2018autooffice\u2019 \ub370\uc774\ud130\ub9cc \uac80\uc0c9\ud558\uc600\uc2b5\ub2c8\ub2e4.

              <\/p>\n\n\n\n
              3.5 matchEntireCell()<\/h2>\n\n\n\n

              \uc774 \uba54\uc18c\ub4dc\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc744 \ub54c \uc140 \uc804\uccb4\uc5d0 \ub300\ud574 \uc77c\uce58 \uc5ec\ubd80\ub97c \uacb0\uc815\ud558\ub294 \uc635\uc158\uc744 \uc124\uc815\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c matchEntireCell(false)\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc744 \ub54c \uc140 \uc804\uccb4\uc5d0 \ub300\ud55c \uc77c\uce58 \uc5ec\ubd80\ub97c \uace0\ub824\ud558\uc9c0 \uc54a\uace0 \ud14d\uc2a4\ud2b8\uc758 \uc77c\ubd80\ubd84\ub9cc \uc77c\uce58 \uc5ec\ubd80\ub97c \ud310\ub2e8\ud569\ub2c8\ub2e4. \uc804\uccb4 \ud14d\uc2a4\ud2b8\uac00 \uc77c\uce58\ud558\ub3c4\ub85d \uc870\uac74\uc744 \uc8fc\uae30 \uc704\ud574\uc11c\ub294 matchEntireCell(true)\ub85c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.
              <\/p>\n\n\n\n
              \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

              <\/h5>\n\n\n\n
              function matchEntireCell() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\ud14d\uc2a4\ud2b8\").matchEntireCell(true);\n}<\/code><\/pre>\n\n\n\n

              \uc608\uc2dc
              <\/h5>\n\n\n\n
              \uc544\ub798 \ucf54\ub4dc\uc5d0\ub294 \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019,\u2019\uc624\ud1a0\uc624\ud53c\uc2a42\u2019,\u2019\uc624\ud1a0\uc624\ud53c\uc2a43\u2019 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc635\uc158\uc5d0 \ub530\ub77c \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019\ub77c\ub294 \ub2e8\uc5b4\uac00 \ud3ec\ud568\ub41c \uc140\uc744 \uac80\uc0c9\ud560 \uc218\ub3c4 \uc788\uace0, \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019\ub77c\ub294 \ub2e8\uc5b4\uac00 \uc140\uc758 \uc804\uccb4 \ub0b4\uc6a9\uacfc \uc77c\uce58\ud558\ub294 \uc140\uc744 \uac80\uc0c9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
              <\/p>\n\n\n
              \n
              \"\"<\/figure>\n<\/div>\n\n\n

              \uba3c\uc800, matchEntireCell()\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 findAll()\uc744 \uc0ac\uc6a9\ud558\uc5ec \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019\ub97c \uac80\uc0c9\ud558\uba74 \uc5b4\ub5a4 \uacb0\uacfc\uac00 \ub098\uc624\ub294\uc9c0 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
              <\/p>\n\n\n\n
              \n\t\t\n\t\t\t
              <\/div>\n\t\t\t
              \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
              \n\t\t\t\t\t
              1<\/div>
              2<\/div>
              3<\/div>
              4<\/div>
              5<\/div>
              6<\/div>
              7<\/div>
              8<\/div>
              9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
              function<\/span> <\/span>findAll<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“\uc624\ud1a0\uc624\ud53c\uc2a4”<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
               <\/div>
                <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                  <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                  <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span><\/div>
                <\/span>}<\/span>)<\/span>;<\/span><\/div>
              }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

              createTextFinder()\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uc140\uc744 \ucc3e\uc544\uc624\uae30 \ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc774 \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub418\uc5b4\uc788\ub294 \ubaa8\ub4e0 \uc140\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.
              <\/p>\n\n\n
              \n
              \"\"<\/figure>\n<\/div>\n\n\n

              \uc774\uc81c matchEntireCell()\ub97c \ud65c\uc6a9\ud558\uc5ec \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019 \ud14d\uc2a4\ud2b8\uc640 \uc140\uc774 \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \ub370\uc774\ud130\ub9cc \ucc3e\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

              <\/p>\n\n\n\n
              \ucf54\ub4dc

              <\/h5>\n\n\n\n
              \n\t\t\n\t\t\t
              <\/div>\n\t\t\t
              \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
              \n\t\t\t\t\t
              1<\/div>
              2<\/div>
              3<\/div>
              4<\/div>
              5<\/div>
              6<\/div>
              7<\/div>
              8<\/div>
              9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
              function<\/span> <\/span>matchEntireCell<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“\uc624\ud1a0\uc624\ud53c\uc2a4”<\/span>)<\/span>.<\/span>matchEntireCell<\/span>(<\/span>true<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
               <\/div>
                <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                  <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                  <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span><\/div>
                <\/span>}<\/span>)<\/span>;<\/span><\/div>
              }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

              \ucf54\ub4dc \uc124\uba85
              <\/h5>\n\n\n\n
                \n
              1. createTextFinder(\"\uc624\ud1a0\uc624\ud53c\uc2a4\")<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14d\uc2a4\ud2b8 \ucc3e\uae30 \ub3c4\uad6c(TextFinder)\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
              2. matchEntireCell(true)<\/strong><\/mark><\/code>\ub97c \ud638\ucd9c\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\uac00 \uc140 \uc804\uccb4\uc5d0 \uc815\ud655\ud788 \uc77c\uce58\ud574\uc57c\ub9cc \ud574\ub2f9 \uc140\uc774 \ubc18\ud658\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
              3. findAll()<\/mark><\/strong><\/code> \uba54\uc11c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc140\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. TextFinder.findAll()<\/strong><\/mark><\/code>\uc774 \ud638\ucd9c\ub418\uace0, \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc140\uc758 \uc704\uce58\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
              4. forEach()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01\uac01\uc758 \ubc1c\uacac\ub41c \ud56d\ubaa9\uc5d0 \ub300\ud574 \ubc18\ubcf5\ud558\uace0, \uac01 \ud56d\ubaa9\uc758 \ud589\uc744 \uac00\uc838\uc640 \ub85c\uadf8\uc5d0 \ud574\ub2f9 \ud589\uc744 \ucc38\uc870\ud558\ub294 \uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
                <\/li>\n<\/ol>\n\n\n\n
                \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
                <\/p>\n\n\n
                \n
                \"\"<\/figure>\n<\/div>\n\n\n

                \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019 \ud14d\uc2a4\ud2b8\uc640 \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uac12\ub9cc \ucd9c\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4.
                <\/p>\n\n\n\n
                3.6 matchFormulaText()<\/h2>\n\n\n\n

                \uc774 \uba54\uc18c\ub4dc\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc744 \ub54c \uc140\uc774\ub098 \ubc94\uc704\uc758 \uc218\uc2dd\uc5d0 \ub300\ud55c \uc77c\uce58 \uc5ec\ubd80\ub97c \uacb0\uc815\ud558\ub294 \uc635\uc158\uc744 \uc124\uc815\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c matchFormulaText(false)\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc744 \ub54c \uc140\uc758 \uac12\ub9cc \uace0\ub824\ud558\uace0, \uc218\uc2dd \ud14d\uc2a4\ud2b8\ub294 \uace0\ub824\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
                <\/p>\n\n\n\n
                \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

                <\/h5>\n\n\n\n
                function matchFormulaText() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\uc218\uc2dd\").matchFormulaText(true);\n}<\/code><\/pre>\n\n\n\n

                \uc608\uc2dc

                <\/h5>\n\n\n\n
                \uc544\ub798\uc758 \uc608\uc2dc\uc5d0\uc11c A12 \uc140\uc5d0\ub294 \u2018=TODAY()\u2019\ub77c\ub294 \uc218\uc2dd\uc774 \uc785\ub825\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. matchFormulaText()\ub97c \ud65c\uc6a9\ud558\uba74 \uc218\uc2dd\uc774 \uc0ac\uc6a9\ub41c \uc140\uc744 \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                <\/p>\n\n\n
                \n
                \"\"<\/figure>\n<\/div>\n\n\n

                \uc774\uc81c matchFormulaText()\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc218\uc2dd\uc744 \uac80\uc0c9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
                <\/p>\n\n\n\n
                \ucf54\ub4dc
                <\/h5>\n\n\n\n
                \n\t\t\n\t\t\t
                <\/div>\n\t\t\t
                \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
                \n\t\t\t\t\t
                1<\/div>
                2<\/div>
                3<\/div>
                4<\/div>
                5<\/div>
                6<\/div>
                7<\/div>
                8<\/div>
                9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
                function<\/span> <\/span>matchFormulaText<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                  <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                  <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“TODAY()”<\/span>)<\/span>.<\/span>matchFormulaText<\/span>(<\/span>true<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
                 <\/div>
                  <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                    <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                    <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span>;<\/span><\/div>
                  <\/span>}<\/span>)<\/span>;<\/span><\/div>
                }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

                \ucf54\ub4dc \uc124\uba85
                <\/h5>\n\n\n\n
                  \n
                1. createTextFinder(\"TODAY()\")<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14d\uc2a4\ud2b8 \ucc3e\uae30 \ub3c4\uad6c(TextFinder)\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c “TODAY()”\ub294 \uac80\uc0c9\ud560 \uc218\uc2dd\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n
                2. matchFormulaText(true)<\/strong><\/mark><\/code>\ub97c \ud638\ucd9c\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\uac00 \uc140\uc758 \uc218\uc2dd\uc5d0 \uc77c\uce58\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc \ud574\ub2f9 \uc140\uc774 \ubc18\ud658\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
                  \ud83d\udca1 matchFormulaText()<\/mark><\/strong><\/code>\uba54\uc18c\ub4dc\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uac80\uc0c9\ud558\uace0\uc790 \ud558\ub294 \uc218\uc2dd\uc774 \ud3ec\ud568\ub418\ub294 \ubaa8\ub4e0 \uc140\uc744 \uac80\uc0c9\ud569\ub2c8\ub2e4. \ub9cc\uc57d \uac80\uc0c9\ud558\uace0\uc790 \ud558\ub294 \uc218\uc2dd\uacfc \uc2dc\ud2b8\uc758 \uc218\uc2dd\uc774 \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uc140\uc744 \ucc3e\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c \ucf54\ub4dc\uc640 \uac19\uc774 matchEntireCell(true) <\/mark><\/code><\/strong>\uc635\uc158\uc744 \ucd94\uac00\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 \uac80\uc0c9 \uc218\uc2dd\uc5d0 \u2018=\u2019(\ub4f1\ud638)\ub3c4 \uc785\ub825\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
                  let textFinder = SHEET.createTextFinder(\"\uc218\uc2dd\")\n                      .matchFormulaText(true).matchEntireCell(true).findAll();<\/code><\/pre>\n\n\n\n
                    \n
                  1. findAll()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc140\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. TextFinder.findAll()<\/strong><\/mark><\/code>\uc774 \ud638\ucd9c\ub418\uace0, \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uc140\uc758 \uc704\uce58\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                  2. forEach()<\/mark><\/code><\/strong> \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01\uac01\uc758 \ubc1c\uacac\ub41c \ud56d\ubaa9\uc5d0 \ub300\ud574 \ubc18\ubcf5\ud558\uace0, \uac01 \ud56d\ubaa9\uc758 \ud589\uc744 \uac00\uc838\uc640 \ub85c\uadf8\uc5d0 \ud574\ub2f9 \ud589\uc744 \ucc38\uc870\ud558\ub294 \uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
                    <\/li>\n<\/ol>\n\n\n\n
                    \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?
                    <\/p>\n\n\n
                    \n
                    \"\"<\/figure>\n<\/div>\n\n\n

                    =TODAY() \uc218\uc2dd\uc774 \uc0ac\uc6a9\ub41c \uc140\uc758 \uc704\uce58\ub9cc\uc744 \ucc3e\uc544\uc11c \ubc18\ud658\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
                    <\/p>\n\n\n\n

                    \ud83d\udca1 \uc5ec\uae30\uc11c \uc7a0\uae50! \uc218\uc2dd\uc73c\ub85c \uc785\ub825\ub41c \uac12\ub3c4 TextFinder\ub85c \uac80\uc0c9\uc774 \uac00\ub2a5\ud560\uae4c\uc694? \uac04\ub2e8\ud55c \uc608\uc2dc\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \u2018C1\u2019 \uc140\uc5d0\ub294 \u2018A1+B1\u2019\uc774\ub77c\ub294 \uc218\uc2dd\uc5d0 \uc758\ud574 \u20182\u2019\ub77c\ub294 \uac12\uc774 \ucd9c\ub825\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n
                    \n
                    \"\"<\/figure>\n<\/div>\n\n\n
                    \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 TextFinder\ub85c \u20182\u2019\ub97c \uac80\uc0c9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
                    \n\t\t\n\t\t\t
                    <\/div>\n\t\t\t
                    \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
                    \n\t\t\t\t\t
                    1<\/div>
                    2<\/div>
                    3<\/div>
                    4<\/div>
                    5<\/div>
                    6<\/div>
                    7<\/div>
                    8<\/div>
                    9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
                    function<\/span> <\/span>findAll<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                      <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                      <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>“2”<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
                     <\/div>
                      <\/span>textFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                        <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                        <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span>;<\/span><\/div>
                      <\/span>}<\/span>)<\/span>;<\/span><\/div>
                    }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n
                    \ub85c\uadf8\ub97c \uc0b4\ud3b4\ubcf4\ub2c8 \uc218\uc2dd\uc5d0 \uc758\ud55c \uacb0\uacfc \uac12\ub3c4 TextFinder\ub97c \ud1b5\ud574\uc11c \uac80\uc0c9\uc774 \uac00\ub2a5<\/strong>\ud558\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n
                    \n
                    \"\"<\/figure>\n<\/div>\n\n\n
                    3.7 replaceAllWith()<\/strong><\/h2>\n\n\n\n

                    replaceAllWith() \uba54\uc18c\ub4dc\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uc740 \ud6c4\uc5d0 \ud574\ub2f9 \ud14d\uc2a4\ud2b8\ub97c \uc9c0\uc815\ub41c \ub2e4\ub978 \ud14d\uc2a4\ud2b8\ub85c \ubaa8\ub450 \ub300\uccb4\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uad04\ud638\uc548\uc5d0 \ub300\uccb4\ud560 \uc0c8\ub85c\uc6b4 \ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \uba54\uc18c\ub4dc\uac00 \uc2e4\ud589\ub41c \ud6c4\uc5d0\ub294 \ubcc0\uacbd\ub41c \uc140\uc758 \uc218\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.

                    <\/p>\n\n\n\n
                    \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

                    <\/h5>\n\n\n\n
                    function replaceAllWith() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder(\"\ucc3e\uc744 \ud14d\uc2a4\ud2b8\");\n  textFinder.replaceAllWith(\"\ub300\uccb4\ud560 \ud14d\uc2a4\ud2b8\");\n}<\/code><\/pre>\n\n\n\n

                    \uc608\uc2dc

                    <\/h5>\n\n\n\n
                    \uc544\ub798 \uc608\uc2dc\uc5d0\uc11c \u2018autooffice\u2019 \ub77c\ub294 \uc774\ub984\uc744 \ucc3e\uc544\uc11c \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019\ub85c \ubcc0\uacbd\ud558\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
                    <\/p>\n\n\n
                    \n
                    \"\"<\/figure>\n<\/div>\n\n\n

                    \ucf54\ub4dc

                    <\/h5>\n\n\n\n
                    \n\t\t\n\t\t\t
                    <\/div>\n\t\t\t
                    \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
                    \n\t\t\t\t\t
                    1<\/div>
                    2<\/div>
                    3<\/div>
                    4<\/div>
                    5<\/div>
                    6<\/div>
                    7<\/div>
                    8<\/div>
                    9<\/div>
                    10<\/div>
                    11<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
                    function<\/span> <\/span>replaceAllWith<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                      <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                      <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>‘autooffice’<\/span>)<\/span>;<\/span><\/div>
                      <\/span>let <\/span>replacedCount<\/span> <\/span>=<\/span> <\/span>textFinder<\/span>.<\/span>replaceAllWith<\/span>(<\/span>‘\uc624\ud1a0\uc624\ud53c\uc2a4’<\/span>)<\/span>;<\/span><\/div>
                     <\/div>
                      <\/span>if<\/span> <\/span>(<\/span>replacedCount<\/span> <\/span> =><\/span> <\/span>0<\/span>)<\/span> <\/span>{<\/span><\/div>
                        <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>$<\/span>{<\/span>replacedCount<\/span>}<\/span>\uac1c\uc758 <\/span>\uac12\uc774 <\/span>\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span>`<\/span>)<\/span>;<\/span><\/div>
                      <\/span>}<\/span> <\/span>else<\/span> <\/span>{<\/span><\/div>
                        <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>“\ubcc0\uacbd\ub41c \uac12\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.”<\/span>)<\/span>;<\/span><\/div>
                      <\/span>}<\/span><\/div>
                    }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

                    \ucf54\ub4dc \uc124\uba85

                    <\/h5>\n\n\n\n
                      \n
                    1. createTextFinder('autooffice')<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec TextFinder\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c ‘autooffice<\/strong>‘\ub294 \ub300\uccb4\ud558\uace0\uc790 \ud558\ub294 \ud14d\uc2a4\ud2b8\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n
                    2. replaceAllWith('\uc624\ud1a0\uc624\ud53c\uc2a4')<\/mark><\/strong><\/code>\ub97c \ud638\ucd9c\ud558\uc5ec “autooffice<\/strong>“\ub97c “\uc624\ud1a0\uc624\ud53c\uc2a4<\/strong>“\ub85c \ubaa8\ub450 \ub300\uccb4\ud569\ub2c8\ub2e4. \uc774\ub54c, \ubcc0\uacbd\ub41c \uc140\uc758 \uc218\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.
                      <\/li>\n<\/ol>\n\n\n\n
                      \ud83d\udca1 replaceAllWith()<\/mark><\/code><\/strong>\uba54\uc18c\ub4dc\ub294 \uc8fc\uc5b4\uc9c4 \ubc94\uc704\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \ubaa8\ub4e0 \ud56d\ubaa9\uc744 \ucc3e\uc544\uc11c \uad50\uccb4\ud569\ub2c8\ub2e4. findAll()<\/mark><\/strong><\/code> \uc635\uc158\uc744 \uae30\ubcf8\uc73c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uac83\uacfc \uac19\uc740 \uac83\uc785\ub2c8\ub2e4.
                      <\/p>\n\n\n\n
                        \n
                      1. \ubc18\ud658\ub41c \ubcc0\uacbd\ub41c \uc140\uc758 \uc218\ub97c \ubcc0\uc218 replacedCount<\/strong><\/mark><\/code>\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                      2. replacedCount<\/strong><\/mark><\/code><\/code>\uac00 0\ubcf4\ub2e4 \ud070 \uacbd\uc6b0, \ubcc0\uacbd\ub41c \uc140\uc774 \uc788\uc73c\ubbc0\ub85c \ubcc0\uacbd\ub41c \uc140\uc758 \uc218\ub97c \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                      3. replacedCount<\/strong><\/mark><\/code><\/code>\uac00 0\uc778 \uacbd\uc6b0, \ubcc0\uacbd\ub41c \uc140\uc774 \uc5c6\uc73c\ubbc0\ub85c “\ubcc0\uacbd\ub41c \uac12\uc774 \uc5c6\uc2b5\ub2c8\ub2e4<\/strong>.”\ub97c \ub85c\uadf8\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4.
                        <\/li>\n<\/ol>\n\n\n\n
                        \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
                        <\/p>\n\n\n
                        \n
                        \"\"<\/figure>\n<\/div>\n\n
                        \n
                        \"\"<\/figure>\n<\/div>\n\n\n

                        \u2018autooffice\u2019 \ud14d\uc2a4\ud2b8\uac00 \ubaa8\ub450 \u2018\uc624\ud1a0\uc624\ud53c\uc2a4\u2019\ub85c \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uc815\uaddc \ud45c\ud604\uc2dd\uc744 \uac80\uc0c9\ud558\ub294 \uba54\uc18c\ub4dc\ub97c \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.

                        <\/p>\n\n\n\n
                        3.8 useRegularExpression()<\/h2>\n\n\n\n

                        \uc774 \uba54\uc18c\ub4dc\ub294 \uc815\uaddc \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

                        \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

                        <\/h5>\n\n\n\n
                        function findTextInRange() {\n  const SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  let textFinder = SHEET.createTextFinder('\uc815\uaddc\ud45c\ud604\uc2dd').useRegularExpression(true);\n}<\/code><\/pre>\n\n\n\n

                        \uc608\uc2dc

                        <\/h5>\n\n\n\n
                        \uc544\ub798 \uc608\uc2dc\uc5d0\uc11c \uc815\uaddc \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\uba54\uc77c\uc774 \uc785\ub825\ub41c \uc0ac\ub78c\ub4e4\uc758 \ud589 \uc704\uce58\ub97c \ucd9c\ub825\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
                        <\/p>\n\n\n
                        \n
                        \"\"<\/figure>\n<\/div>\n\n\n

                        \ucf54\ub4dc

                        <\/h5>\n\n\n\n
                        \n\t\t\n\t\t\t
                        <\/div>\n\t\t\t
                        \n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
                        \n\t\t\t\t\t
                        1<\/div>
                        2<\/div>
                        3<\/div>
                        4<\/div>
                        5<\/div>
                        6<\/div>
                        7<\/div>
                        8<\/div>
                        9<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
                        function<\/span> <\/span>useRegularExpression<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
                          <\/span>const<\/span> <\/span>SHEET<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>.<\/span>getActiveSheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
                          <\/span>let <\/span>textFinder<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>createTextFinder<\/span>(<\/span>‘^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\\\.[a-zA-Z]{2,}$’<\/span>)<\/span>.<\/span>useRegularExpression<\/span>(<\/span>true<\/span>)<\/span>;<\/span><\/div>
                          <\/span>let <\/span>foundCells<\/span> <\/span>=<\/span> <\/span>textFinder<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span><\/div>
                          <\/span>foundCells<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span> =><\/span> <\/span>{<\/span><\/div>
                            <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
                            <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uac80\uc0c9 <\/span>\uacb0\uacfc:<\/span> <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694`<\/span>)<\/span>;<\/span><\/div>
                          <\/span>}<\/span>)<\/span>;<\/span><\/div>
                        }<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

                        \ucf54\ub4dc \uc124\uba85

                        <\/h5>\n\n\n\n
                          \n
                        1. \uba3c\uc800 SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \ud65c\uc131\ud654\ub41c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
                        2. createTextFinder('^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$')<\/mark><\/strong><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec TextFinder<\/code><\/strong> <\/mark>\uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc0ac\uc6a9\ub41c \uc815\uaddc \ud45c\ud604\uc2dd\uc740 \uc774\uba54\uc77c \uc8fc\uc18c\uc758 \ud615\uc2dd\uc744 \ub530\ub985\ub2c8\ub2e4.
                          <\/li>\n<\/ol>\n\n\n\n
                          \ud83d\udca1 \uc704 \uc815\uaddc \ud45c\ud604\uc2dd\uc5d0 \uc0ac\uc6a9\ub41c \ubb38\uc790\ub4e4\uc740 \ubb34\uc5c7\uc744 \uc758\ubbf8\ud560\uae4c\uc694?<\/p>\n\n\n\n