本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。

# REMOVE\_COMBINED
<a name="recipe-actions.REMOVE_COMBINED"></a>

根據使用者指定的內容，從資料欄移除一或多個字元。

**Parameters**
+ `sourceColumn` – 現有資料欄的名稱。
+ `collapseConsecutiveWhitespace` – 如果為 `true`， 會將兩個或多個空格字元取代為正好一個空格字元。
+ `removeAllPunctuation` – 如果為 `true`， 會移除下列所有字元： `. ! , ?`
+ `removeAllQuotes` – 如果為 `true`， 會移除所有單引號和雙引號。
+ `removeAllWhitespace` – 如果為 `true`， 會移除所有空格字元。
+ `customCharacters` – 可採取動作的一個或多個字元。
+ `customValue` – 可採取動作的值。
+ `removeCustomCharacters` – 如果為 `true`， 會移除 `customCharacters` 參數指定的所有字元。
+ `removeCustomValue` – 如果為 `true`， 會移除 `customValue` 參數指定的所有字元。
+ `punctuationally` – 如果為 `true`，當下列字元出現在值的開頭或結尾時， 會移除這些字元：`. ! , ?`
+ `antidisestablishmentarianism` – 如果為 `true`， 會從值的開頭和結尾移除單引號和雙引號。
+ `removeLeadingAndTrailingWhitespace` – 如果為 `true`， 會從值的開頭和結尾移除所有空格。
+ `removeLetters` – 如果為 `true`， 會移除所有大寫和小寫字母字元 (`A` 到 `Z`； `a`到 `z`)。
+ `removeNumbers` – 如果為 `true`， 會移除所有數字字元 (`0` 到 `9`)。
+ `removeSpecialCharacters` – 如果為 `true`， 會移除下列所有字元： `! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~`

**Example 範例**  
  

```
{
    "RecipeAction": {
        "Operation": "REMOVE_COMBINED",
        "Parameters": {
            "collapseConsecutiveWhitespace": "false",
            "removeAllPunctuation": "false",
            "removeAllQuotes": "false",
            "removeAllWhitespace": "false",
            "removeCustomCharacters": "false",
            "removeCustomValue": "false",
            "removeLeadingAndTrailingPunctuation": "false",
            "removeLeadingAndTrailingQuotes": "false",
            "removeLeadingAndTrailingWhitespace": "false",
            "removeLetters": "false",
            "removeNumbers": "false",
            "removeSpecialCharacters": "true",
            "sourceColumn": "info_url"
        }
    }
}
```

```
{
    "RecipeAction": {
        "Operation": "REMOVE_COMBINED",
        "Parameters": {
            "collapseConsecutiveWhitespace": "false",
            "customCharacters": "¶",
            "removeAllPunctuation": "false",
            "removeAllQuotes": "false",
            "removeAllWhitespace": "false",
            "removeCustomCharacters": "true",
            "removeCustomValue": "false",
            "removeLeadingAndTrailingPunctuation": "false",
            "removeLeadingAndTrailingQuotes": "false",
            "removeLeadingAndTrailingWhitespace": "false",
            "removeLetters": "false",
            "removeNumbers": "false",
            "removeSpecialCharacters": "false",
            "sourceColumn": "info_url"
        }
    }
}
```

```
{
    "RecipeAction": {
        "Operation": "REMOVE_COMBINED",
        "Parameters": {
            "collapseConsecutiveWhitespace": "true",
            "customValue": "M",
            "removeAllPunctuation": "true",
            "removeAllQuotes": "false",
            "removeAllWhitespace": "false",
            "removeCustomCharacters": "false",
            "removeCustomValue": "true",
            "removeLeadingAndTrailingPunctuation": "false",
            "removeLeadingAndTrailingQuotes": "true",
            "removeLeadingAndTrailingWhitespace": "true",
            "removeLetters": "true",
            "removeNumbers": "true",
            "removeSpecialCharacters": "false",
            "sourceColumn": "info_url"
        }
    }
}
```

```
{
    "RecipeAction": {
        "Operation": "REMOVE_COMBINED",
        "Parameters": {
            "collapseConsecutiveWhitespace": "false",
            "removeAllPunctuation": "false",
            "removeAllQuotes": "false",
            "removeAllWhitespace": "false",
            "removeCustomCharacters": "false",
            "removeCustomValue": "false",
            "removeLeadingAndTrailingPunctuation": "false",
            "removeLeadingAndTrailingQuotes": "false",
            "removeLeadingAndTrailingWhitespace": "false",
            "removeLetters": "false",
            "removeNumbers": "true",
            "removeSpecialCharacters": "false",
            "sourceColumn": "first_name"
        }
    }
}
```

```
{
    "RecipeAction": {
        "Operation": "REMOVE_COMBINED",
        "Parameters": {
            "collapseConsecutiveWhitespace": "false",
            "removeAllPunctuation": "false",
            "removeAllQuotes": "false",
            "removeAllWhitespace": "false",
            "removeCustomCharacters": "false",
            "removeCustomValue": "false",
            "removeLeadingAndTrailingPunctuation": "false",
            "removeLeadingAndTrailingQuotes": "false",
            "removeLeadingAndTrailingWhitespace": "false",
            "removeLetters": "false",
            "removeNumbers": "true",
            "removeSpecialCharacters": "false",
            "sourceColumn": "first_name"
        }
    }
}
```