Bumblebee Docs
  • Hi Bumblebee!
  • Install Bumblebee
    • Install via Docker
    • Build and Install From Source
  • Quick start
    • Setting up your first workspace
  • Bumblebee interface
    • Loading a Dataset
    • Saving a Dataset
    • Profile
    • Table
    • Columns
  • Transformations
    • Join dataframes
    • Rows functions
      • Sort rows
      • Filter rows
      • Drop empty rows
      • Drop duplicates
    • Column managing functions
      • Set
      • Rename
      • Duplicate
      • Keep
      • Drop
      • Nest
      • Unnest
    • Transformation functions
      • Fill null values
      • Replace
      • String functions
        • Lower case
        • Upper case
        • Proper case
        • Remove accents
        • Remove special chars
        • Normalize white spaces
        • Left (substring)
        • Right (substring)
        • Mid (substring)
      • Math functions
        • Absolute value
        • Round
        • Floor
        • Ceil
        • Modulo
        • Logarithm
        • Natural logarithm
        • Power
        • Square root
      • Trigonometric functions
        • Sine
        • Cosine
        • Tangent
        • Inverse Sine
        • Inverse Cosine
        • Inverse Tangent
        • Hyperbolic Sine
        • Hyperbolic Cosine
        • Hyperbolic Tangent
        • Inverse Hyperbolic Sine
        • Inverse Hyperbolic Cosine
        • Inverse Hyperbolic Tangent
      • Time and Date
        • Transform format
        • Year
        • Year (short)
        • Month name
        • Month name (short)
        • Month as a number
        • Day of month
        • Weekday
        • Weekday (short)
        • Weekday as a number
        • Minute
        • Hour (00-23)
        • AM/PM
        • UTC offset
        • Timezone
        • Day number of year
        • Weekday of year (Mon as 1st)
        • Weekday of year (Sun as 1st)
      • Web related functions
        • Domain
        • Subdomain
        • Url scheme
        • Port
        • Url path
        • Url params
        • Email domain
        • Email username
        • Strip HTML
      • Machine Learning
        • Random sampling
  • Help
    • Bigger than memory data
    • Which engine to use
Powered by GitBook
On this page
  • Location
  • Fields
  • Example

Was this helpful?

  1. Transformations
  2. Transformation functions
  3. String functions

Mid (substring)

PreviousRight (substring)NextMath functions

Last updated 4 years ago

Was this helpful?

Extracts a given number of characters from the values of a string and outputs the result to a new column or to the same input column. This operation is useful for quickly extracting data from fixed-length values.

Location

Fields

Field

Type

Description

Output column name(s)

Text field

Name of the output column(s), if left blank will save the result on the same column.

Start at

Numeric

End at

Numeric

Example

Mid (substring) on the interface
Mid (substring) example