for InterBase and FireBird

Description of FreeAdhocUDF functions (583 functions: 522 basic-, 58 variants and 3 file-functions)
click on   or on (.. functions) to expand the block Preliminary note Functions with Unicode-Sign in front are compatible to UTF-8 since InterBase 2009 and FireBird 2.0 also for InterBase since 7.5 with limitation and without warranty compatible to UNICODE_FSS Necessary UPDATE for existing databases ! very important - please read ! Handling of NULL since FireBird 2.0 Necessary additional files ! very importend - please read ! Functions included in FreeAdhocUDF.dll/.so String functions (91 functions and 28 variants) Create (8 functions) F_CRLF F_LF F_SPACE F_NBSP U_NBSP U_NNBSP F_DQM F_SQM F_DSQM F_TAB Edit (45 functions and 19 variants) F_LEFT (F_BIGLEFT) U_LEFT F_MID(F_BIGMID, F_COPY, F_STRCOPY) U_MID F_RIGHT (F_BIGRIGHT) U_RIGHT F_SUBSTR (F_BIGSUBSTR, F_STRSUB, F_STRPOS, F_SUBSTRN, F_STRSUBN) U_SUBSTR F_STRRM U_STRRM F_LTRIM (F_BIGLTRIM) F_RTRIM (F_BIGRTRIM) F_LRTRIM (BIGLRTRIM) F_PADLEFT (F_RPADLEFT) U_PADLEFT F_PADRIGHT (F_RPADRIGHT) U_PADRIGHT F_PADCENTER U_PADCENTER F_LINEWRAP U_LINEWRAP F_REPLACE (F_BIGREPLACE) F_REPLACESTRING (F_BIGREPLACESTRING) U_REPLACESTRING F_CONVERTSYMBOLS U_CONVERTSYMBOLS F_REVERSE U_REVERSE F_STRIPSTRING (F_BIGSTRIPSTRING) U_STRIPSTRING F_STRIPSTRINGHOLD (F_HOLDSTRING, F_BIGSTRIPSTRINGHOLD) U_STRIPSTRINGHOLD F_REPEATTRIM U_REPEATTRIM F_STRREPEAT F_STROFCHAR F_STRSTUFF U_STRSTUFF F_COLLATEBR F_KEYUP F_PRED U_PRED F_SUCC U_SUCC Convert (21 functions and 6 variants) F_LOWER (F_ANSILOWERCASE, F_RLOWER) U_LOWER F_UPPER (F_ANSIUPPERCASE, F_RUPPER) U_UPPER F_PROPERCASE U_PROPERCASE F_RLATIN U_CYRILLIC-LATIN F_CHARACTER (F_CHR) U_CHR F_ORD U_ORD F_ROT13 F_SOUNDEX (F_GENERATESNDXINDEX) F_GSOUNDEX F_TELEFONNR F_DIGITS F_STR2EXCEL F_RC F_FLOATTOSTR F_INTTOSTR Compare (3 functions) F_EQUALSTRING F_STRCMP U_STRCMP Find / determin (12 functions and 3 variants) F_FINDWORD U_FINDWORD F_WORDNUM F_FINDNTHWORD F_FINDWORDINDEX (F_FINDWORDINDEXN) F_STRINGLENGTH (F_BIGSTRINGLENGTH) U_STRINGLENGTH F_STRINGLISTITEM F_WORDCOUNT F_RWORDCOUNT F_STRINGCOUNT (F_RSTRINGCOUNT) F_DOMAINFROMEMAIL Numeric functions (74 functions) Create (4 functions) F_RAND F_INTRANDOM F_GETRANDOM F_DOUBLERANDOM Format (13 functions) F_ROUND F_ROUNDFLOAT F_ZAHLRUNDEN (F_ROUNDCOMMON) F_ROUNDTOEVEN F_SOFTROUND F_RAPPENRUNDUNG F_FIXEDPOINT F_FIXEDPOINTLANG F_TRUNCATE F_DOLLARVAL (F_CONVERTTODOLLAR) F_EUROVAL F_INPUTVAL F_NUMINWORDS Calculate (20 functions) F_DOUBLEABS (F_ABS) F_INTEGERABS F_POWER F_EXP F_SQRT F_FACT (F_FACTORIAL) F_MODULO F_DIV F_FLOOR F_CEILING F_FRAC F_LN F_LOG F_LOG10 F_ISDIVISIBLEBY F_EVEN F_SIGN F_PROZENTE F_Z F_DZERO Compare (4 functions) F_MAXNUM (F_MAX) F_MINNUM (F_MIN) F_EQUALINTEGER F_EQUALFLOAT Binary functions (8 functions) F_BIN_AND F_BIN_OR F_BIN_XOR F_BIN_NOT F_BIN_SHL F_BIN_SHR F_BIN_GET F_BIN_SET Trigonometry (25 functions) F_SIN F_COS F_TAN F_COT F_ASIN F_ACOS F_ATAN F_ATAN2 F_ACOT F_SIND F_COSD F_TAND F_COTD F_ARCSIND F_ARCCOSD F_ARCTAND F_ARCCOTD F_SINHYP F_COSHYP F_TANHYP F_COTHYP F_ARSINH F_ARCOSH F_ARTANH F_ARCOTH Date/time functions (139 functions and 27 variants) Preliminary note Calculate (11 functions) F_ADDYEAR F_ADDMONTH F_ADDWEEK F_ADDDAY F_ADDHOUR F_ADDMINUTE F_ADDSECOND F_INCDATE F_INCDATETIME F_ADDPERIOD F_SUBPERIOD Determin (78 functions and 23 variants) F_AGEINYEARS (F_AGEINYEARSN) F_AGEINMONTHS (F_AGEINMONTHSN) F_AGEINWEEKS (F_AGEINWEEKSN) F_AGEINWEEKSISO (F_AGEINWEEKSNISO) F_AGEINDAYS (F_AGEINDAYSN) F_AGEINWORKINGDAYS F_AGEINHOURS (F_AGEINHOURSN) F_AGEINMINUTES (F_AGEINMINUTESN) F_AGEINSECONDS (F_AGEINSECONDSN) F_AGEINYEARSTHRESHOLD (F_AGEINYEARSTHRESHOLDN) F_AGEINMONTHSTHRESHOLD (F_AGEINMONTHSTHRESHOLDN) F_AGEINWEEKSTHRESHOLD (F_AGEINWEEKSTHRESHOLDN) F_AGEINWEEKSTHRESHOLDISO (F_AGEINWEEKSTHRESHOLDNISO) F_AGEINDAYSTHRESHOLD (F_AGEINDAYSTHRESHOLDN) F_AGEINWORKINGDAYSTHR F_AGEINHOURSTHRESHOLD (F_AGEINHOURSTHRESHOLDN) F_AGEINMINUTESTHRESHOLD (F_AGEINMINUTESTHRESHOLDN) F_AGEINSECONDSTHRESHOLD (F_AGEINSECONDSTHRESHOLDN) F_YEARSBETWEEN F_MONTHSBETWEEN F_WEEKSBETWEEN F_WEEKSBETWEENISO F_DAYSBETWEEN F_WORKINGDAYSBETWEEN F_HOURSBETWEEN F_MINUTESBETWEEN F_INDMINUTESBETWEEN F_INDMINUTESBETWEENTHR (F_INDMINUTESBETWEENTHRIB) F_SECONDSBETWEEN F_DAYOFYEAR (F_EXTRACTYEARDAY) F_DAYOFMONTH F_DAYOFWEEK (F_EXTRACTWEEKDAY, F_DOW) F_DAYSOFMONTH F_LASTDAY F_FIRSTDAYQUARTER F_LASTDAYQUARTER F_FIRSTDAYMONTH F_LASTDAYMONTH F_FIRSTDAYWEEK F_LASTDAYWEEK F_FIRSTDAYWEEKISO F_LASTDAYWEEKISO F_FIRSTDAYWOY F_LASTDAYWOY F_FIRSTDAYKW F_LASTDAYKW F_FIRSTDAYLASTQUARTER F_LASTDAYLASTQUARTER F_FIRSTDAYLASTMONTH F_LASTDAYLASTMONTH F_FIRSTDAYLASTWEEK F_FIRSTDAYLASTWEEKISO F_LASTDAYLASTWEEK F_LASTDAYLASTWEEKISO F_FIRSTDAYNEXTQUARTER F_LASTDAYNEXTQUARTER F_FIRSTDAYNEXTMONTH F_LASTDAYNEXTMONTH F_FIRSTDAYNEXTWEEK F_FIRSTDAYNEXTWEEKISO F_LASTDAYNEXTWEEK F_LASTDAYNEXTWEEKISO F_DTIME F_ISLEAPYEAR (F_RISLEAPYEAR) F_ZEITDIFFERENZ F_COUNTWEEKDAYS F_YEAR (F_YEAROFYEAR) F_QUARTER F_MONTH F_WEEK (F_WEEKOFYEAR) F_WOY F_WOYISO F_KALENDERWOCHE F_HOUR F_MINUTE F_SECOND F_MILLISECOND F_TZVALUETOUTC Format (25 functions and 4 variants) F_CMONTHLONG U_MONTHLONG F_CMONTHLONGLANG U_MONTHLONGLANG F_CMONTHSHORT U_MONTHSHORT F_CMONTHSHORTLANG U_MONTHSHORTLANG F_CDOWLONG U_DOWLONG F_CDOWLONGLANG U_DOWLONGLANG F_CDOWSHORT U_DOWSHORT F_CDOWSHORTLANG U_DOWSHORTLANG F_GFORMATD F_DATETOSTR F_DATETOSTRLANG U_DATE2STRLANG F_ENCODEDATE (F_ENCODEDATENULL, F_RENCODEDATE) F_ENCODETIME (F_ENCODETIMENULL) F_ENCODETIMESTAMP (F_RENCODEDATETIME) F_STRIPDATE F_STRIPTIME Compare (4 functions) F_MAXDATE F_MINDATE F_EQUALDATE F_EQUALDATETIME Convert (7 functions) F_STRTOTIME F_DATETODOUBLE F_TIMETODOUBLE F_DOUBLETODATE F_DOUBLETOTIME F_PERIOD2SECONDS F_SECONDS2PERIOD Movable Feasts (14 functions) F_WEIBERFASSNACHT F_ROSENMONTAG F_KARNEVALSDIENSTAG F_ASCHERMITTWOCH F_PALMSONNTAG F_GRUENDONNERSTAG F_KARFREITAG F_OSTERSAMSTAG F_OSTERDATUM F_OSTERMONTAG F_HIMMELFAHRT F_PFINGSTSONNTAG F_PFINGSTMONTAG F_FRONLEICHNAM BLOb functions (20 functions and 3 variants) Transform (3 functions) F_BLOBASPCHAR F_STRBLOB F_BLOB2EXCEL Edit (8 functions and 3 variants) F_BLOBLEFT F_BLOBMID (F_RBLOBMID) F_BLOBRIGHT F_BLOBCAT F_BLOBCATSTR F_BLOBREPLACESTRING U_BLOBREPLACESTRING F_BLOBSUBSTR U_BLOBSUBSTR F_BLOBLINE Calculate (5 functions) F_BLOBSIZE F_BLOBMAXSEGMENTLENGTH F_BLOBSEGMENTCOUNT F_BLOBLINECOUNT F_BLOBWORDCOUNT Compare (2 functions) F_BLOBCOMPARE F_BLOBCMP find / determin (2 functions) F_BLOBSTRPOS F_BLOBTEXTPOS UUID functions (13 functions) Preliminary note Create (6 functions) F_UUID1MAC F_UUID1RAND F_UUID4 F_UUID1MACCOMPR F_UUID1RANDCOMPR F_UUID4COMPR Transform (2 functions) F_UUID2UUIDCOMPR F_UUIDCOMPR2UUID Read (5 functions) F_UUIDVERSION F_UUID1TIMESTAMP F_UUID1COMPRTIMESTAMP F_UUID1MACMAC F_UUID1MACCOMPRMAC Converting functions (142 functions) Longitudinal units (22 functions) F_C_P2MM F_C_IN2M F_C_LI2M F_C_FT2M F_C_YD2M F_C_FM2M F_C_RD2M F_C_CH2M F_C_FUR2M F_C_LEA2KM F_C_MILE2KM F_C_MM2P F_C_M2IN F_C_M2LI F_C_M2FT F_C_M2YD F_C_M2FM F_C_M2RD F_C_M2CH F_C_M2FUR F_C_KM2LEA F_C_KM2MILE Areal units (12 functions) F_C_AR2SQM F_C_HA2SQM F_C_MORGEN2SQM F_C_SQFT2SQM F_C_AC2SQM F_C_SQYD2SQM F_C_SQM2AR F_C_SQM2HA F_C_SQM2MORGEN F_C_SQM2SQFT F_C_SQM2AC F_C_SQM2SQYD Volume units (30 functions) F_C_CUIN2CUM F_C_CUFT2CUM F_C_CUYD2CUM F_C_CUP2ML F_C_GBFLOZ2ML F_C_USFLOZ2ML F_C_GBPT2L F_C_USPT2L F_C_GBQT2L F_C_USQT2L F_C_GBGAL2L F_C_USGAL2L F_C_BBL2L F_C_GBBU2L F_C_USBU2L F_C_CUM2CUIN F_C_CUM2CUFT F_C_CUM2CUYD F_C_ML2CUP F_C_ML2GBFLOZ F_C_ML2USFLOZ F_C_L2GBPT F_C_L2USPT F_C_L2GBQT F_C_L2USQT F_C_L2GBGAL F_C_L2USGAL F_C_L2BBL F_C_L2GBBU F_C_L2USBU Weight units (12 functions) F_C_CT2G F_C_OZ2G F_C_OZTR2G F_C_CWT2G F_C_ST2G F_C_OBU2G F_C_DRA2G F_C_LB2KG F_C_G2CT F_C_G2OZ F_C_G2OZTR F_C_G2CWT F_C_G2ST F_C_G2OBU F_C_G2DRA F_C_KG2LB Temperature units (2 functions) F_C_C2F F_C_F2C Date/Time units (6 functions) F_C_TIME2DECTIME F_C_TIME2INDTIME F_C_DECTIME2TIME F_C_INDTIME2TIME F_LOCAL2UTC F_UTC2LOCAL Technical units (30 functions) - magnetism (2 functions) F_C_G2T F_C_T2G - pressure (8 functions) F_C_BAR2TORR F_C_BAR2PA F_C_PSI2PA F_C_TORR2PA F_C_TORR2BAR F_C_PA2BAR F_C_PA2PSI F_C_PA2TORR - energy / work (4 functions) F_C_CAL2J F_C_J2CAL F_C_LBFT2NM F_C_NM2LBFT - power (4 functions) F_C_PS2KW F_C_BHP2KW F_C_KW2PS F_C_KW2BHP - speed (4 functions) F_C_MPH2KMPH F_C_FPS2MPS F_C_KMPH2MPH F_C_MPS2FPS - consumption (8 functions) F_C_MPGBGAL2L00KM F_C_MPUSGAL2L00KM F_C_L100KM2MPGBGAL F_C_L100KM2MPUSGAL F_C_KMPL2L100KM F_C_L100KM2KMPL F_C_MPL2L100KM F_C_L100KM2MPL nautic units (14 functions) F_C_SHOT2M F_C_CBL2M F_C_NL2M F_C_NM2M F_C_SM2M F_C_RT2CBM F_C_SMPH2KMPH F_C_M2SHOT F_C_M2CBL F_C_M2NL F_C_M2NM F_C_KM2SM F_C_CBM2RT F_C_KMPH2SMPH Number-systems (8 functions) F_ROMAN2ARABIC F_ARABIC2ROMAN F_CONVERTFROM33 F_CONVERTTO33 F_CONVERTFROMBASE F_CONVERTTOBASE F_HEXTOINT F_INTTOHEX Geometrical transformations (2 functions) F_DEGTORAD F_RADTODEG Checksum functions (27 functions) Common mathematical algorithm (4 functions) F_CROSSSUM F_CROSSDIFF F_WEIGHTCROSSSUM F_ITERATECROSSSUM Employed checksums/checkdigits (23 functions) F_ENCRYPTMD5 (with UTF-8 you got another but correct md5-Hash!) F_GTIN8CHECK F_GTIN8 F_UPC12CHECK F_UPC12 F_GTIN13CHECK F_GTIN13 F_GTIN14CHECK F_GTIN14 F_NVE18CHECK F_NVE18 F_ISBN10CHECK F_ISBN10 F_ISBN13CHECK F_ISBN13 F_ISSN8CHECK F_ISSN8 F_UPSTNCHECK F_UPSTN F_2OF5CHECK F_2OF5 F_CODE39CHECK F_CODE39 Functions for constants (6 functions) Numeric Constants (3 functions) F_PI F_E F_EPSILON Physical Constants (3 functions) F_C F_G F_K divers functions (10 functions) F_IF F_VERSION F_VERSIONNAME F_OSLANGUAGE NVL Funktionen (6 functions) F_SNVL F_SNVL2 F_INVL F_INVL2 F_DNVL F_DNVL2 Functions included in FAUfile.dll/.so (separated file-functions of FreeAdhocUDF) File functions (3 functions) with BLObs (2 functions) F_BLOBLOAD F_BLOBSAVE divers file functions (1 function) F_FILEVERSION