On the Data tab, go to a column name and click the
arrow_drop_down
expander arrow.
Select Format and select an option—for example, TitleCase. The
options are explained in the following sections.
Wrangler performs the transformation on the column's values in Preview mode and
adds the corresponding directive to the recipe. When you run the data pipeline,
the transformation is applied to all values in the column.
Change the case of the strings
To change the letter case, follow the steps in the preceding section and choose
one of the following options.
Option
Description
UPPERCASE
Changes the letter case of strings to all-uppercase—for example,
1800 Amphibious Blvd. changes to
1800 AMPHIBIOUS BLVD.
lowercase
Changes the letter case of strings to all-lowercase—for example,
1800 Amphibious Blvd. changes to
1800 amphibious blvd.
TitleCase
Changes the letter case to capitalize the first letter of each word—for
example, 1800 amphibious blvd. changes to
1800 Amphibious Blvd.
Concatenate the strings
To append characters to the beginning or end of all string values in a column,
follow these steps:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-03 UTC."],[[["\u003cp\u003eThis page outlines how to format string data within the Wrangler workspace in Cloud Data Fusion, focusing on common string manipulations.\u003c/p\u003e\n"],["\u003cp\u003eYou can change the case of strings to \u003ccode\u003eUPPERCASE\u003c/code\u003e, \u003ccode\u003elowercase\u003c/code\u003e, or \u003ccode\u003eTitleCase\u003c/code\u003e directly from the Wrangler's formatting options.\u003c/p\u003e\n"],["\u003cp\u003eWrangler allows you to concatenate strings, appending characters to the beginning or end of each string value in a column, optionally creating a new column for the modified data.\u003c/p\u003e\n"],["\u003cp\u003eYou can trim spaces from strings in a column, including removing leading spaces, trailing spaces, or both, using the \u003ccode\u003eTrim whitespace\u003c/code\u003e, \u003ccode\u003eTrim leading whitespace\u003c/code\u003e, or \u003ccode\u003eTrim trailing whitespace\u003c/code\u003e options.\u003c/p\u003e\n"]]],[],null,["# Format strings\n\nThis page explains how to format strings when you prepare data in the Wrangler\nworkspace of the Cloud Data Fusion Studio.\n\nTo format a **String** column, follow these steps:\n\n1. [Go to the Wrangler workspace in Cloud Data Fusion](/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).\n2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.\n3. Select **Format** and select an option---for example, **TitleCase**. The options are explained in the following sections.\n\nWrangler performs the transformation on the column's values in Preview mode and\nadds the corresponding directive to the recipe. When you run the data pipeline,\nthe transformation is applied to all values in the column.\n\nChange the case of the strings\n------------------------------\n\nTo change the letter case, follow the steps in the preceding section and choose\none of the following options.\n\nConcatenate the strings\n-----------------------\n\nTo append characters to the beginning or end of all string values in a column,\nfollow these steps:\n\n1. [Go to the Wrangler workspace in Cloud Data Fusion](/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).\n2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.\n3. Click **Format \\\u003e Concatenate**.\n4. In the **Add** field, enter the string to add to the existing values.\n5. Select where to add the new value in the string by choosing **at the\n beginning** or **at the end**.\n6. Optional: to create a new column for the concatenated strings, select the **Copy to a new column** checkbox.\n\n| **Tip:** To prevent adding characters to null or blank values, filter out the null and blank values before performing this task.\n\n**Example**\n\nThis example shows the input and output values when you add the string `NEW-` to\nthe beginning of each value in a column:\n\nTrim spaces from the strings\n----------------------------\n\nTo trim spaces, follow the steps to format a string column at the\nbeginning of this page and choose one of the following options:\n\nWhat's next\n-----------\n\n- Learn more about [Wrangler directives](/data-fusion/docs/concepts/wrangler-overview#apply_directives)."]]
