{"id":489,"date":"2021-05-22T11:32:35","date_gmt":"2021-05-22T11:32:35","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=489"},"modified":"2021-06-15T14:35:09","modified_gmt":"2021-06-15T14:35:09","slug":"find-replace","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/find-replace\/","title":{"rendered":"Find-Replace"},"content":{"rendered":"

What is the \u2018Find-Replace\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

The \u2018Find-Replace\u2019 task can be used to find content in a data table, based on a full or a partial match. The content can then be replaced with new custom content.<\/p>\n

The \u2018Find-Replace\u2019 task is useful tool to quickly revise a data table.<\/p>\n

 <\/p>\n

 <\/p>\n

How to use the \u2018Find-Replace\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

The important fields in the \u2018Find-Replace\u2019 task are<\/p>\n

    \n
  1. Select Table<\/strong><\/li>\n<\/ol>\n

    Use this dropdown menu to select the table which has the data entries you would like to find and replace.<\/p>\n

     <\/p>\n

      \n
    1. Select Columns to Find<\/strong><\/li>\n<\/ol>\n

      Use this dropdown menu to select the columns which have the data entries you would like to find and replace. You may select all columns if you would like to select the entire data table.<\/p>\n

       <\/p>\n

        \n
      1. Incoming Value<\/strong><\/li>\n<\/ol>\n

        Use this dropdown menu to define the nature of the match with the incoming value. You can select if the incoming value is equal to, or begins with, or ends with a particular value or text string. You can even use this field to select empty cells or a Regular Expression.<\/p>\n

        Note: RegEx Match (also called Regular Expression Match) can be used to search for very complex strings. For example, a RegEx search for \u2018[A-Z]\\w+\u2019 will search for all words that start with capital letters A to Z. \u2018Andreas\u2019 and \u2018Ralf\u2019 would meet this criterion. You can develop and test such expressions using sites like\u00a0https:\/\/regex101.com\/<\/a><\/span><\/p>\n

         <\/p>\n

          \n
        1. Incoming Value to Replace<\/strong><\/li>\n<\/ol>\n

          Use this field to type in the value or the text string you want to find.<\/p>\n

           <\/p>\n

            \n
          1. Partial Match<\/strong><\/li>\n<\/ol>\n

            Use this dropdown menu to indicate if you want to find a full or a partial match.<\/p>\n

             <\/p>\n

              \n
            1. Replace With<\/strong><\/li>\n<\/ol>\n

              Use this dropdown menu to define the nature of the replacement value. You can select a custom value or even a numerical calculation like column sum or column average.<\/p>\n

               <\/p>\n

                \n
              1. Replace with Value<\/strong><\/li>\n<\/ol>\n

                Use this field to type in the replacement value. This field shows up only if \u2018Custom Value\u2019 is selected in \u2018Replace With\u2019.<\/p>\n

                 <\/p>\n

                 <\/p>\n

                How to use the \u2018Filter Options\u2019 section in the \u2018Find-Replace\u2019 task?<\/strong><\/p>\n

                The \u2018Filter Options\u2019 section in the \u2018Find-Replace\u2019 task can be used to modify features of the output table.<\/p>\n

                More information about this section is available here<\/a><\/strong><\/em>.<\/p>\n

                 <\/p>\n

                 <\/p>\n

                How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Find-Replace\u2019 task?<\/strong><\/p>\n

                The \u2018Output Options\u2019 section in the \u2018Find-Replace\u2019 task can be used to modify features of the output table. The fields related to this section become visible on selecting the \u2018Output Options\u2019 checkbox.<\/p>\n

                More information about this section is available here<\/a><\/strong><\/em>.<\/p>\n

                 <\/p>\n

                 <\/p>\n