Home
Integer and string manipulations
Includes recipes that manipulate strings and integers by extracting, separating, ordering, and converting characters, among other operations including date manipulations and regular expressions.

Integer and string manipulations
Includes recipes that manipulate strings and integers by extracting, separating, ordering, and converting characters, among other operations including date manipulations and regular expressions.
- Converting names to initials
  Using string manipulations, you can convert a column containing names to a column containing initials.
- Transforming dates from text to integers
  Sometimes dates are stored in a variety of text formats for display purposes, but in order to operate on these dates using 1010data functions, they need to be transformed to 1010data's standard YYYYMMDD integer format.
- Determining days between entries
  Using a combination of days and g_rshift, you can determine how many days have elapsed between the previous occurrence of a particular value and the current entry.

Integer and string manipulations

Includes recipes that manipulate strings and integers by extracting, separating, ordering, and converting characters, among other operations including date manipulations and regular expressions.