What types of string manipulation can I do?

Here are some typical string manipulation tasks you can do in Querri

String Splitting:

1. Split by a Specific Character

   • e.g., "Split the text in {column} by comma to extract individual values."

2. Split by Spaces

   • e.g., "Divide the sentence in {column} into individual words."

3. Split by Newlines

   • e.g., "Separate lines in the text document."

White Space Handling:

1. Remove Leading and Trailing Spaces

   • e.g., "Get rid of any extra spaces at the beginning and end of the text in {column}."

2. Replace White Spaces

   • e.g., "Replace spaces with hyphens in {column}"

3. Join Multiple Strings with Spaces

   • e.g., "Combine words or elements in {column} into a single string with spaces in between."

String Modification:

1. Change to Uppercase or Lowercase

   • e.g., "Convert text  in {column} to all uppercase."
   • e.g., "Convert text  in {column} to all lowercase."

2. Capitalize First Letter

   • e.g., "Make the first letter of a sentence or phrase uppercase in {column}."

3. Title Case

   • e.g., "Capitalize the first letter of each word in a text in {column}."

4. Extract Substrings

   • e.g., "Take a specific portion of the text in {column}."

Regular Expressions:

1. Find a Pattern

   • e.g., "Search for a particular pattern or keyword in the text in {column}."

2. Replace Using Patterns

   • e.g., "Replace occurrences of a specific pattern with another text."

3. Extract Groups Matching a Pattern

   • e.g., "Retrieve all instances of a specific pattern from the text in {column}."

4. Split Using Regular Expressions

   • e.g., "Separate the text based on a custom pattern using regular expressions in {column}."

Stripping and Padding:

1. Zero Padding for Numbers

   • e.g., "Add leading zeros to numeric strings to match a desired width in {column}."