WebFOCUS

| Function | Description | Syntax | | --- | --- | --- | | ABS | Calculate Absolute Value | ABS(in_value) | | ACOS | Calculate an Angle Given its Cosine | ACOS(expression) | | ADD | Add Days to a Date | ADD(date,value) | | ANOMALY_IF | Calculate an Anomaly Score | ANOMALY_IF('options' predictor_field1[, predictor_field2, ...]) | | ARGLEN | Measure the Length of a Character String | ARGLEN(length, source_string, output) | | ASCII | Return the ASCII Code for the Leftmost Character in a String | ASCII(charexp) | | ASIN | Calculate an Angle Given its Sine | ASIN(expression) | | ASIS | Distinguish Between a Space and a Zero | ASIS(argument) | | ATAN | Calculate an Angle Given its Tangent | ATAN(expression) | | ATAN2 | Calculate an Angle Given the Coordinates of its Tangent | ATAN2(x,y) | | ATODBL | Convert an Alphanumeric String to Double-Precision Format | ATODBL(source_string, length, output) | | AYM | Add or Subtract Months to or From a Date | AYM(indate, months, output) | | AYMD | Add or Subtract Days to or From a Date | AYMD(indate, days, output) | | BAR | Produce a Bar Chart | BAR(barlength, infield, maxvalue, 'char', output) | | BITSON | Determine If a Bit Is On or Off | BITSON(bitnumber, source_string, output) | | BITVAL | Evaluate a Bit String | BITVAL(source_string, startbit, number, output) | | BYTVAL | Translate a Character | BYTVAL(character, output) | | CEILING | Return the Smallest Integer Greater Than or Equal to a Number | CEILING(number) | | CHAR | Return a Character Based on a Numeric Code | CHAR(number_code) | | CHAR_LENGTH | Return the Length of a String in Characters | CHAR_LENGTH(string) | | CHAR2INT | Translate a Character Into an Integer Value | CHAR2INT('character') | | CHECKMD5 | Compute an MD5 Hash Check Value | CHECKMD5(buffer) | | CHECKPRIVS | Retrieve the Privilege State for the Connected User | CHECKPRIVS(privcode, output) | | CHECKSUM | Compute a CHECKSUM Hash Value | CHECKSUM(buffer) | | CHGDAT | Change the Date Display String | CHGDAT('in_display_options', 'out_display_options', date_string,output) | | CHKFMT | Check the Format of a Character String | CHKFMT(numchar, source_string, 'mask', output) | | CHKNUM | Check the Format of a Character String | CHKNUM(numchar, source_string, output) | | CHKPCK | Validate a Packed Field | CHKPCK(length, in_value, error, output) | | CHR | Return the ASCII Character Given a Numeric Code | CHR(number) | | CLASSIFY_BLR | Calculate a Binary Logistic Regression | CLASSIFY_BLR('options', predictor_field1[, predictor_field2, ...] target_field) | | CLASSIFY_KNN | Calculate a K-Nearest Neighbors Classification | CLASSIFY_KNN('options', predictor_field1[, predictor_field2, ...] target_field) | | CLASSIFY_RF | Calculate a Random Forest Classification | CLASSIFY_RF('options', number_of_trees, predictor_field1[, predictor_field2, ...] target_field) | | CLASSIFY_XGB | Calculate an Extreme Gradient Boosting Classification | CLASSIFY_XGB('options', predictor_field1[, predictor_field2, ...] target_field) | | CLSDDREC | Close All Files Opened by the PUTDDREC Function | CLSDDREC(output) | | COALESCE | Return the First Non-Missing Value | COALESCE(arg1, arg2, ...) | | COMPACTFORMAT | Display Numbers in an Abbreviated Format | COMPACTFORMAT(input) | | CONCAT | Concatenate Strings | CONCAT(string1, string2) | | CORRELATION | Calculate the Correlation Coefficient Between Two Fields | CORRELATION(field1, field2) | | COS | Calculate the Cosine of an Angle | COS(expression) | | COT | Calculate the Cotangent of an Angle | COT(expression) | | CTRAN | Translate One Character to Another | CTRAN(length, source_string, decimal, decvalue, output) | | CTRFLD | Center a Character String | CTRFLD(source_string, length, output) | | CTRLCHAR | Return a Non-Printable Control Character | CTRLCHAR(ctrl_char) | | DA Functions | Convert a Date to an Integer (DADMY, DADYM, DAMDY, DAMYD, DAYDM, DAYMD)" | function(indate, output) | | DATEADD | Add or Subtract a Date Unit to or From a Date | DATEADD(date, 'component', increment) | | DATECVT | Convert a Date Format | DATECVT(date, 'in_format', output) | | DATEDIF | Find the Difference Between Two Dates | DATEDIF(from_date, to_date, 'component') | | DATEMOV | Move a Date to a Significant Point | DATEMOV(date, 'move-point') | | DATETRAN | Format Dates in International Formats | DATETRAN(indate, '(intype)', '([formatops])', 'lang', outlen, output) | | DAY | Extract the Day of the Month From a Date | DAY(date) | | DAYNAME | Return the Name of the Day From a Date Expression | DAYNAME(date_exp) | | DB_EXPR | Insert an SQL Expression Into a Request With DB_EXPR | DB_EXPR(native_SQL_expression) | | DB_INFILE | Compare Source and Target Field Values With DB_INFILE | DB_INFILE(target_file, s1, t1, ... sn, tn) | | DB_LOOKUP | Retrieve a Value From a Lookup Data Source | DB_LOOKUP(look_mf, srcfld1, lookfld1, srcfld2, lookfld2, ..., returnfld) | | DCTRAN | Translate a Single-Byte or Double-Byte Character to Another | DCTRAN(length, source_string, indecimal, outdecimal, output) | | DECODE | Supply Values in the Function | DECODE fieldname(code1 result1 code2 result2...[ELSE default ]) | | DEDIT | Extract or Add DBCS or SBCS Characters | DEDIT(inlength, source_string, mask_length, mask, output) | | DEGREES | Convert Radians to Degrees | DEGREES(expression) | | DIFFERENCE | Measure the Phonetic Similarity Between Character String | DIFFERENCE(chrexp1, chrexp2) | | DIGITS | Convert a Number to a Character String | DIGITS(number,length) | | DMOD | Calculate the Remainder From a Division | function(dividend, divisor, output) | | DMY or MDY or YMD | Calculate the Difference Between Two Dates | function(from_date, to_date) | | DOWK | Find the Day of the Week | DOWK(indate, output) | | DOWKL | Find the Day of the Week | DOWKL(indate, output) | | DPART | Extract a Date Component and Return It in Integer Format | DPART (datevalue, 'component', output) | | DSTRIP | Remove a Single-Byte or Double-Byte Character From a String | DSTRIP(length, source_string, char, output) | | DSUBSTR | Extract a Substring | DSUBSTR(inlength, source_string, start, end, sublength, output) | | DT Functions | Convert an Integer to a Date (DTDMY, DTDYM, DTMDY, DTMYD, DTYDM, DTYMD)" | function(number, output) | | DT_CURRENT_DATE | Return the Current Date | DT_CURRENT_DATE() | | DT_CURRENT_DATETIME | Return the Current Date and Time | DT_CURRENT_DATETIME(component) | | DT_CURRENT_TIME | Return the Current Time | DT_CURRENT_TIME(component) | | DT_FORMAT | Convert a Date Value to an Alphanumeric String in a Specified Date Format | DT_FORMAT(date,'date_format') | | DT_TOLOCAL | Convert UTC Time to Local Time | DT_TOLOCAL(datetime, timezone) | | DT_TOUTC | Convert Local Time to UTC Time | DT_TOUTC(datetime, timezone) | | DTADD | Increment a Date or Date-Time Component | DTADD(date, component, increment) | | DTDIFF | Return the Number of Component Boundaries | DTDIFF(end_date, start_date, component) | | DTIME | Extract a Time Component From a Date-Time Value | DTIME(datetime, component) | | DTPART | Return a Date or Date-Time Component in Integer Format | DTPART(date, component) | | DTRUNC | Return the First or Last Date of a Date Period | DTRUNC(date_or_timestamp, date_period, extend) | | EDAPRINT | Insert a Message in the EDAPRINT Log File | EDAPRINT(message_type, 'message') | | EDIT | Convert the Format of a Field | EDIT(fieldname) | | EDIT | Extract or Add Characters | EDIT(source_string, 'mask') | | ENCRYPT | Encrypt a Password | ENCRYPT(password) | | EXP | Raise e to the Nth Power | EXP(power, output) | | EXPN | Evaluate a Number in Scientific Notation | EXPN(n.nn {E\|D} {+\|-} p) | | EXPONENT | Raise the Constant e to a Power | EXPONENT(power) | | FEXERR | Retrieve an Error Message | FEXERR(error, 'A72') | | FGETENV | Retrieve the Value of an Environment Variable | FGETENV(length, 'varname', outlen, output) | | FIND | Verify the Existence of a Value in a Data Source | FIND(fieldname [AS dbfield] IN file) | | FINDMEM | Find a Member of a Partitioned Data Set | FINDMEM(ddname, member, output) | | FIQTR | Obtain the Financial Quarter | FIQTR(inputdate, lowcomponent, startmonth, startday, yrnumbering, output) | | FIYR | Obtain the Financial Year | FIYR(inputdate, lowcomponent, startmonth, startday, yrnumbering, output) | | FIYYQ | Convert a Calendar Date to a Financial Date | FIYYQ(inputdate, lowcomponent, startmonth, startday, yrnumbering, output) | | FLOOR | Return the Largest Integer Less Than or Equal to a Number | FLOOR(number) | | FMLCAP | Retrieve Captions in an FML Request Using the FMLCAP Function | FMLCAP(fieldname \| 'format') | | FMLFOR | Retrieve FML Tag Values | FMLFOR(output) | | FMLINFO | Retain FOR Values in an FML Request | FMLINFO('FORVALUE', output) | | FMLLIST | Retrieve an FML Tag List | FMLLIST('A4096V') | | FORECAST_DOUBLEXP | Calculate a Double Exponential Smoothing Column | FORECAST_DOUBLEXP(display, infield,interval, npredict, npoint1, npoint2) | | FORECAST_EXPAVE | Calculate a Single Exponential Smoothing Column | FORECAST_EXPAVE(display, infield, interval,npredict, npoint1) | | FORECAST_LINEAR | Calculate a Linear Regression Column | FORECAST_LINEAR(display, infield, interval,npredict) | | FORECAST_MOVAVE | Calculate a Simple Moving Average Column | FORECAST_MOVAVE(display, infield, interval,npredict, npoint1) | | FORECAST_SEASONAL | Calculate a Triple Exponential Smoothing Column | FORECAST_SEASONAL(display, infield,interval, npredict, nperiod, npoint1, npoint2, npoint3) | | FPRINT | Convert Fields Using FPRINT | FPRINT(in_value, 'usageformat', output) | | FPRINT | Display a Value in a Specified Format | FPRINT(value, 'out_format') | | FPUTENV | Assign a Value to an Environment Variable | FPUTENV (varname_length,'varname',value_length, 'value', output) | | FTOA | Convert a Number to Alphanumeric Format | FTOA(number, '(format)', output) | | GET_TOKEN | Extract a Token Based on a String of Delimiters | GET_TOKEN(string, delimiter_string, occurrence) | | GETCOOKI | Retrieve a Cookie Value | GETCOOKI('cookie_name', length) | | GETENV | Retrieve the Value of an Environment Variable | GETENV(var_name) | | GETHEADR | Retrieve an HTTP Header Variable | GETHEADR('varname', output) | | GETPDS | Determine If a PDS Member Exists | GETPDS(ddname, member, output) | | GETTOK | Extract a Substring (Token)" | GETTOK(source_string, inlen, token_number, 'delim', outlen, output) | | GETUSER | Retrieve a User ID | GETUSER(output) | | GIS_DISTANCE | Calculate the Distance Between Geometry Points | GIS_DISTANCE(geo_point1,geo_point2) | | GIS_DRIVE_ROUTE | Calculate the Drive Route Between Geometry Points | GIS_DRIVE_ROUTE(geo_start_point,geo_end_point) | | GIS_GEOCODE_ADDR | Geocode a Complete Address | GIS_GEOCODE_ADDR(address[, country]) | | GIS_GEOCODE_ADDR_CITY | Geocode an Address Line | City, and State,GIS_GEOCODE_ADDR_CITY( street_addr, city , state [, country]) | | GIS_GEOCODE_ADDR_POSTAL | Geocode an Address Line and Postal Code | GIS_GEOCODE_ADDR_POSTAL( street_addr, postal_code [, country]) | | GIS_GEOMETRY | Build a JSON Geometry Object | GIS_GEOMETRY(geotype, wkid, geometry) | | GIS_IN_POLYGON | Determine if a Point is in a Complex Polygon | GIS_IN_POLYGON(point, polygon_definition) | | GIS_LINE | Build a JSON Line | GIS_LINE(geometry1, geometry2) | | GIS_POINT | Build a Geometry Point | GIS_POINT(wkid, longitude, latitude) | | GIS_REVERSE_COORDINATE | Return a Geographic Component | GIS_REVERSE_COORDINATE(longitude, latitude, component) | | GIS_SERV_AREA_XY | Calculate a Geometry Area Around a Coordinate | GIS_SERV_AREA_XY(longitude, latitude, distance, travel_mode[, wkid]) | | GIS_SERVICE_AREA | Calculate a Geometry Area Around a Point | GIS_SERVICE_AREA(geo_point, distance, travel_mode) | | GREGDT | Convert From Julian to Gregorian Format | GREGDT(indate, output) | | GRPLIST | Retrieve a List of Group Memberships for the Connected User | GRPLIST(outputLength, outformat) | | HADD | Increment a Date-Time Value | HADD(datetime, 'component', increment, length, output) | | HCNVRT | Convert a Date-Time Value to Alphanumeric Format | HCNVRT(datetime, '(format)', length, output) | | HDATE | Convert the Date Portion of a Date-Time Value to a Date Format | HDATE(datetime, output) | | HDIFF | Find the Number of Units Between Two Date-Time Values | HDIFF(end_dt, start_dt, 'component', output) | | HDTTM | Convert a Date Value to a Date-Time Value | HDTTM(date, length, output) | | HEXBYT | Convert a Decimal Integer to a Character | HEXBYT(decimal_value, output) | | HEXTR | Extract Multiple Components From a Date-Time Value | HEXTR(datetime, 'componentstring', length, output) | | HEXTYPE | Returning the Hexadecimal View of an Input Value | HEXTYPE(in_value) | | HGETC | Store the Current Local Date and Time in a Date-Time Field | HGETC(length, output) | | HGETZ | Store the Current Universal Date and Time in a Date-Time Field | HGETZ(length, output) | | HHMMSS | Retrieve the Current Time | HHMMSS(output) | | HHMMSS | Retrieve the Current Time | HHMMSS() | | HHMS | Convert a Date-Time Value to a Time Value | HHMS(datetime, length, output) | | HINPUT | Convert an Alphanumeric String to a Date-Time Value | HINPUT(source_length, 'source_string', output_length, output) | | HMASK | Move Multiple Date-Time Components to a Target Date-Time Field | HMASK(source, 'componentstring', input, length, output) | | HMIDNT | Set the Time Portion of a Date-Time Value to Midnight | HMIDNT(datetime, length, output) | | HNAME | Retrieve a Date-Time Component in Alphanumeric Format | HNAME(datetime, 'component', output) | | HPART | Retrieve a Date-Time Component in Numeric Format | HPART(datetime, 'component', output) | | HSETPT | Insert a Component Into a Date-Time Value | HSETPT(datetime, 'component', value, length, output) | | HTIME | Convert the Time Portion of a Date-Time Value to a Number | HTIME(length, datetime, output) | | HTMTOTS or TIMETOTS | Convert a Time to a Timestamp | HTMTOTS(time, length, output) | | HYYWD | Return the Year and Week Number From a Date-Time Value | HYYWD(dtvalue, output) | | IMPUTE | Replace Missing Values With Aggregated Values | IMPUTE(field, reset_key, replacement) | | INCREASE | Calculate the Difference Between the Current and a Prior Value of a Field | INCREASE([prefix.]field, offset) | | INITCAP | Capitalize the First Letter of Each Word in a String | INITCAP(input_string) | | Initial_HHMMSS | Retrieve the Initial Time | Initial_HHMMSS() | | Initial_TODAY | Retrieve the Initial Date | Initial_TODAY() | | INT | Find the Greatest Integer | INT(in_value) | | INT2CHAR | Translate an Integer Value Into a Character | INT2CHAR(value) | | ITONUM | Convert a Large Binary Integer to Double-Precision Format | ITONUM(maxbytes, infield, output) | | ITOPACK | Convert a Large Binary Integer to Packed-Decimal Format | ITOPACK(maxbytes, infield, output) | | ITOZ | Convert a Number to Zoned Format | ITOZ(length, in_value, output) | | IWC.FindAppCGIValue | Find a TIBCO WebFOCUS Parameter Value | IWC.FindAppCGIValue(name,value) | | IWC.FindAppCGIValue | Retrieve a TIBCO WebFOCUS Parameter or Variable Value | IWC.FindAppCGIValue(parm, mnt_var) | | IWC.GetAppCGIValue | Import a TIBCO WebFOCUS Parameter | IWC.GetAppCGIValue(parm) | | IWC.GetAppCGIValue | Retrieve a TIBCO WebFOCUS Parameter | IWC.GetAppCGIValue(parm) | | IWCLink | Display a URL in a Browser or Frame | IWCLink(url, [target], [newwindow], [options]) | | IWCSwitchToSecure | Turn Secure Sockets Layer On | IWCSwitchToSecure() | | IWCSwitchToUnsecure | Turn Secure Sockets Layer Off | IWCSwitchToUnsecure() | | IWCTrigger | Call a Maintain Function From a Script Handler | IWCTrigger('functionname'[, 'parm'] | | IWCTrigger | Pass the Value of an ActiveX Control Property to a Maintain Function | IWCTrigger ('function',document.form.control.property) | | JOBNAME | Retrieve the Current Process Identification String | JOBNAME(length, output) | | JPTRANS | Convert Japanese Specific Characters | JPTRANS ('type_of_conversion', length, source_string, 'output_format') | | JULDAT | Convert From Gregorian to Julian Format | JULDAT(indate, output) | | JULIAN | Determine How Many Days Have Elapsed in the Year | JULIAN(date) | | KKFCUT | Truncate a String | KKFCUT(length, source_string, output) | | KMEANS_CLUSTER | Partition Observations Into Clusters Based on the Nearest Mean Value | KMEANS_CLUSTER(number, percent, iterations, tolerance, [prefix1.]field1[, [prefix1.]field2 ...]) | | LAST | Retrieve the Preceding Value | LAST fieldname | | LAST_NONBLANK | Return the Last Value That is Neither Blank nor Missing | LAST_NONBLANK(field) | | LCWORD | Convert a Character String to Mixed-Case Using LCWORD | LCWORD(string) | | LCWORD | Convert a Character String to Mixed-Case Using LCWORD1 | LCWORD(length, source_string, output) | | LCWORD2 | Convert a Character String to Mixed-Case Using LCWORD2 | LCWORD2(string) | | LCWORD2 | Convert a Character String to Mixed-Case Using LCWORD2 | LCWORD2(length, string, output) | | LCWORD3 | Convert a Character String to Mixed-Case Using LCWORD3 | LCWORD3(length, string, output) | | LEFT | Return Characters From the Left of a Character String | LEFT(chr_exp, int_exp) | | LENGTH | Determine the Length of a Character String | LENGTH(string) | | LENV | Find the Length of an Alphanumeric Field | LENV(source_string, output) | | LJUST | Left-Justify a Character String | LJUST(string) | | LJUST | Left-Justify a Character String | LJUST(length, source_string, output) | | LOCASE | Convert Text to Lowercase | LOCASE(length, source_string, output) | | LOCASV | Create a Variable Length Lowercase String | LOCASV(upper_limit, source_string, output) | | LOCATE | Return the Position of a Substring in a String | LOCATE(substr, source [,start]) | | LOG | Calculate the Natural Logarithm | LOG(in_value) | | LOG10 | Calculate the Base 10 Logarithm | LOG10(num_exp) | | LOOKUP | Retrieve a a data value from a cross-referenced FOCUS data source in a MODIFY request | LOOKUP(field) | | LOWER | Convert a Character String to Lowercase | LOWER(string) | | LOWER | Return a String With All Letters Lowercase | LOWER(string) | | LPAD | Pad a Character String on the Left | LPAD(string, out_length, pad_character) | | LTRIM | Remove Blanks From the Left End of a String | LTRIM(string) | | MASK | Extract or Add Characters | MASK(fieldname, 'mask') | | MAX | Find the Maximum Value | MAX(value1, value2, ...) | | MIN | Find the Minimum Value | MIN}(value1, value2, ...) | | MIRR | Calculate the Modified Internal Rate of Return | MIRR(cashflow, finrate, reinvrate, output) | | MNTGETTOK | Extract a Substring (Token)" | MNTGETTOK(infield,'delim',token_number) | | MOD | Calculate the Remainder From a Division | MOD(dividend, divisor) | | MONTH | Extract the Month From a Date | MONTH(date) | | MONTHNAME | Return the Name of the Month From a Date Expression | MONTHNAME(date_exp) | | MULTIREGRESS | Create a Multivariate Linear Regression Column | MULTIREGRESS(input_field1, [input_field2, ...]) | | MVSDYNAM | Pass a DYNAM Command to the Command Processor | MVSDYNAM(command, length, outfield) | | NLSCHR | Convert Characters From the Native English Code Page | NLSCHR('character') | | NORMSDST | Calculate the Cumulative Standard Normal Distribution | NORMSDST(value, 'D8') | | NORMSINV | Calculate the Inverse Cumulative Standard Normal Distribution | NORMSINV(value, 'D8') | | NULLIF | Return a Null Value for Equal Parameters | NULLIF(arg1,arg2) | | OUTLIER | Identify Outliers in Numeric Data | OUTLIER(input_field) | | OVERLAY | Replace Characters in a String | OVERLAY(src, ins, start, len) | | OVRLAY | Overlay a Character String | OVRLAY(source_string, length, substring, sublen, position, output) | | OVRLAY | Overlay a Character String | OVRLAY(string1, string2, position) | | PARAG | Divide Text Into Smaller Lines | PARAG(length, source_string, 'delimiter', max_token_size, output) | | PARTITION_AGGR | Generate Rolling Calculations Using PARTITION_AGGR | PARTITION_AGGR([prefix.]measure,reset_key,lower,upper,operation) | | PARTITION_REF | Retrieve Prior or Subsequent Field Values for Use in a Calculation | PARTITION_REF([prefix.]field, reset_key, offset) | | PATTERN | Generate a Pattern From an Input String | PATTERN (length, source_string, output) | | PATTERNS | Return a String That Represents the Pattern Profile of the Input Argument | PATTERNS(string) | | PCKOUT | Write a Packed Number of Variable Length | PCKOUT(in_value, length, output) | | PCT_INCREASE | Calculate the Percentage Difference Between the Current and a Prior Value of a Field | PCT_INCREASE([prefix.]field, offset) | | PHONETIC | Return a Phonetic Key | PHONETIC(string) | | PI | Returning the Value Pi | PI() | | POSIT | Find the Beginning of a Substring | POSIT(source_string, length, substring, sublength, output) | | POSIT | Find the Beginning of a Substring | POSIT(parent, substring) | | POSITION | Return the First Position of a Substring in a Source String | POSITION(pattern, string) | | POSITION | Return the Position of a Search String in a Source String | POSITION(search, source, start) | | POSITV | Find the Beginning of a Variable Length Substring | POSITV(source_string, upper_limit, substring, sub_limit, output) | | POWER | Raise a Value to a Power | POWER(base, power) | | PRDNOR | Generate Reproducible Random Numbers | PRDNOR(seed, output) | | PRDUNI | Generate Reproducible Random Numbers | PRDUNI(seed, output) | | PREVIOUS | Retrieve a Prior Value of a Field | PREVIOUS([prefix.]field, offset) | | PTOA | Convert a Packed-Decimal Number to Alphanumeric Format | PTOA(number, '(format)', output) | | PUTCOOKI | Submit a Cookie Value | PUTCOOKI('cookie_name','cookie_value') | | PUTDDREC | Write a Character String as a Record in a Sequential File | PUTDDREC(ddname, dd_len, record_string, record_len, output) | | PUTENV | Assign a Value to an Environment Variable | PUTENV(var_name, var_value) | | QUARTER | Determine the Quarter for a Date | QUARTER(date) | | RADIANS | Convert Degrees to Radians | RADIANS(expression) | | RDNORM | Generate Random Numbers | RDNORM(output) | | RDUNIF | Generate Random Numbers | RDUNIF}(output) | | REGEX | Match a String to a Regular Expression | REGEX(string, regular_expression) | | REGEXP_COUNT | Count the Number of Matches to a Pattern in a String | REGEXP_COUNT(string, pattern) | | REGEXP_INSTR | Return the Position of a Pattern in a String | REGEXP_INSTR(string, pattern) | | REGEXP_REPLACE | Replace Matches to a Pattern in a String | REGEXP_REPLACE(string, pattern, replacement) | | REGEXP_SUBSTR | Returning the First Match to a Pattern in a String | REGEXP_SUBSTR(string, pattern) | | REGRESS_KNN | Calculate a K-Nearest Neighbors Regression | REGRESS_KNN('options', predictor_field1[, predictor_field2, ...] target_field) | | REGRESS_POLY | Calculate a Polynomial Regression Column | REGRESS_POLY('options', predictor_field1, predictor_field2, [...,] target_field) | | REGRESS_RF | Calculate a Random Forest Regression | REGRESS_RF('options', predictor_field1[, predictor_field2, ...] target_field) | | REGRESS_XGB | Calculate an Extreme Gradient Boosting Regression | REGRESS_XGB('options', predictor_field1[, predictor_field2, ...] target_field) | | REPEAT | Repeat a Character String a Given Number of Times | REPEAT(source_str, number) | | REPLACE | Replace all Instances of a String | REPLACE(input_string , search_string , replacement) | | REVERSE | Reverse the Characters in a String | REVERSE(length, source_string, output) | | RIGHT | Return Characters From the Right of a Character String | RIGHT(chr_exp, int_exp) | | RJUST | Right-Justify a Character String | RJUST(length, source_string, output) | | RJUST | Right-Justify a Character String | RJUST(string, length, char) | | ROUND | Round a Number to a Given Number of Decimal Places | ROUND(num_exp, count) | | RPAD | Pad a Character String on the Right | RPAD(string, out_length, pad_character) | | RSERVE | Run an R Script | RSERVE(rserve_mf, input_field1, ...input_fieldn, output) | | RTRIM | Remove Blanks From the Right End of a String | RTRIM(string) | | RUN_MODEL | Run a Saved Python Model | RUN_MODEL('app/modelname') | | RUN_MODEL2 | Run a Saved Python Model (predictor field names are not the same in the model and the data)" | RUN_MODEL2('app/modelname', pfield1, ..., pfieldn) | | RUNNING_AVE | Calculate Running Average Between the Current and a Prior Value of a Field | RUNNING_AVE(field, reset_key, lower) | | RUNNING_MAX | Calculate Running Maximum Between the Current and a Prior Value of a Field | RUNNING_MAX(field, reset_key, lower) | | RUNNING_MIN | Calculate Running Minimum Between the Current and a Prior Value of a Field | RUNNING_MIN(field, reset_key, lower) | | RUNNING_SUM | Calculate Running Sum Between the Current and a Prior Value of a Field | RUNNING_SUM(field, reset_key, lower) | | SELECTS | Decode a Value From a Stack | target SELECTS (code, result, code, result, ... [ELSE default]) | | SETMDY | Set a Value to a Date | SETMDY(date, month, day, year) | | SFTDEL | Delete the Shift Code From DBCS Data | SFTDEL(source_string, length, output) | | SFTINS | Insert the Shift Code Into DBCS Data | SFTINS(source_string, length, output) | | SIGN | Return the Sign of a Number | SIGN(number) | | SIN | Calculate the Sine of an Angle | SIN(expression) | | SLACK | Post a Message to a Slack Channel | SLACK(workspace, channel, message) | | SLEEP | Suspend Execution for a Specified Number of Seconds | SLEEP(delay, output) | | SOUNDEX | Compare Character Strings Phonetically | SOUNDEX(length, source_string, output) | | SPACE | Return a String With a Given Number of Spaces | SPACE(count) | | SPAWN | Create a Subprocess From a Procedure | SPAWN(inlength, command, outcode) | | SPELLNM | Spell Out a Dollar Amount | SPELLNM(outlength, number, output) | | SPLIT | Extract an Element From a String | SPLIT(element, string) | | SQRT | Calculate the Square Root | SQRT(in_value) | | SQUEEZ | Reduce Multiple Spaces to a Single Space | SQUEEZ(length, source_string, output) | | STDDEV | Calculate the Standard Deviation in a Set of Data | STDDEV(field, sampling) | | STRAN | Substitute a Substring | STRAN(string, substr1, substr2) | | STRCMP | Compare Character Strings | STRCMP(string1, string2) | | STRICMP | Compare Character Strings and Ignore Case | STRICMP(string1, string2) | | STRIP | Remove a Character From a String | STRIP(length, source_string, char, output) | | STRNCMP | Compare Character Substrings | STRNCMP(string1, string2, number) | | STRREP | Replace Character Strings | STRREP (inlength, instring, searchlength, searchstring, replength, repstring, outlength, output) | | STRTOKEN | Extract a Substring | STRTOKEN(string, delimiters) | | SUB | Subtract a Value From a Date | SUB(date,value) | | SUBSTR | Extract a Substring | SUBSTR(length, source_string, start, end, sublength, output) | | SUBSTR | Extract a Substring | SUBSTR(string, start, length) | | SUBSTRING | Extract a Substring From a Source String | SUBSTRING(string, position, length) | | SUBSTV | Extract a Variable Length Substring | SUBSTV(upper_limit, source_string, start, sub_limit, output) | | SYSTEM | Call a DOS or Windows Program | SYSTEM(length, 'string ', returncode) | | SYSVAR | Retrieve the Value of a z/OS System Variable | SYSVAR('length', '[&]sysvar[.]', 'outfmt') | | TAN | Calculate the Tangent of an Angle | TAN(expression) | | TO_INTEGER | Convert a Character String to an Integer | TO_INTEGER(string) | | TO_NUMBER | Convert a Character String to a Number | TO_NUMBER(string) | | TODAY | Retrieve the Current Date | TODAY() | | TODAY | Retrieve the Current Date | TODAY(output) | | TODAY2 | Retrieve the Current Date | TODAY2() | | TOKEN | Extract a Token From a String | TOKEN(string, delimiter, number) | | TRIM | Remove Leading and Trailing Occurrences | TRIM(trim_where, source_string, length, pattern, sublength, output) | | TRIM | Remove Trailing Occurrences | TRIM(string) | | TRIM_ | Remove a Leading Character, Trailing Character or Both From a String | TRIM_(where, pattern, string) | | TRIMLEN | Determine the Length of a String Excluding Trailing Spaces | TRIMLEN(string) | | TRIMV | Remove Characters From a String | TRIMV(trim_where, source_string, upper_limit, pattern, pattern_limit, output) | | TRUNCATE | Truncate a Number to a Given Number of Decimal Places | TRUNCATE(num_exp, count) | | TSTOPACK | Convert an MSSQL or Sybase Timestamp Column to Packed Decimal | TSTOPACK(tscol, output) | | UFMT | Convert an Alphanumeric String to Hexadecimal | UFMT(source_string, length, output) | | UPCASE | Convert Text to Uppercase | UPCASE(length, source_string, output) | | UPCASE | Convert Text to Uppercase | UPCASE(string) | | UPCASV | Create a Variable Length Uppercase String | UPCASV(upper_limit, source_string, output) | | UPPER | Return a String With All Letters Uppercase | UPPER(string) | | WEEKDAY | Determine the Day of the Week for a Date | WEEKDAY(date) | | XIRR | Calculate the Internal Rate of Return | XIRR (cashflow, dates,guess, maxiterations, output); WITHIN {sort_field \| TABLE} | | XMLDECOD | Decode XML-Encoded Characters | XMLDECOD(inlength, source_string, outlength, output) | | XMLENCOD | XML-Encode Characters | XMLENCOD(inlength, source_string, option, outlength, output) | | XTPACK | Store Packed Values in an Alphanumeric Field | XTPACK(in_value, outlength, outdec, output) | | YEAR | Extract the Year From a Date | YEAR(date) | | YM | Calculate Elapsed Months | YM(fromdate, todate, output) |