This page will auto-generate a MATH statement that mimics Magic's {EXTRACT,} function.
  • Enter the string you want to search, for example: {TR,Subject}
  • Enter the beginning delimiter and ending delimiter. These can be single characters like [ and ] or ( and ), or they can be strings like ~x~ or ~z~. They cannot be the same character or string, however - the start and end delimiters must be different.
  • Enter a test string that includes your delimiters and a value, to make sure it finds the right value.
  •  
    String to search:
    Begin delimiter:
    End delimiter:
    Test String:
     
    Resulting Value:  
    SQL Server MATH statement:
    Oracle MATH statement: