META FUNCTIONS

From SemanticLab

Jump to: navigation, search

SET DEFINE OFF; 

 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('2', 'chop.word', 'v v v chop.word', 'CASE WHEN SUBSTR(v3,1,v2) = v1 THEN SUBSTR(v3,v2+1) ELSE v3 END', NULL, 
     'compUserSql', 0, 'chop.word', 'chop.word', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('3', 'multi.page.check', 'v multi.page.check', 'TO_CHAR(LENGTH(v1)-LENGTH(REPLACE(REPLACE(v1,+,'),-,')))>0', NULL, 
     'compUserSqlBoolean', NULL, 'multi.page.check', 'multi.page.check', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('4', 'num.names$', 'v num.names$', 'v1_NUM_NAMES', NULL, 
     'compUserSql', NULL, 'num.names$', 'num.names$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('405249', 'sort.format.names', 'v sort.format.names', 'v1_SORT_FORMAT_NAMES', 'def SORT_FORMAT_NAMES(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[1:len(FieldValue)-2]/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    for lnr, nLDict in enumerate(nameList):/n        nameptr = lnr + 1/n        namesleft = numnames - lnr/n        first = nLDict[first]/n        von = nLDict[von]/n        last = nLDict[last] /n        jr =  nLDict[jr]/n        t = von+last+first+jr/n        nameresult= nameresult+t/n    return nameresult', 
     'compUserSQLPython', 0, ' SORT_FORMAT_NAMES', 'sort.format.names', 'plain');
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('51', 'calc.label', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'calc.label', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('52', 'new.sentence.checka', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.sentence.checka', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('53', 'format.tr.number', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'format.tr.number', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('54', 'initialize.et.al.char.used', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'initialize.et.al.char.used', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('55', 'reverse.pass', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'reverse.pass', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('56', 'not', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'not', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('57', 'format.vol.num.pages', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'format.vol.num.pages', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('58', 'new.block', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.block', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('59', 'forward.pass', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'forward.pass', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('60', 'new.block.checkb', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.block.checkb', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('61', 'and', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'and', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('62', 'new.sentence.checkb', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.sentence.checkb', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('63', 'output.nonnull', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'output.nonnull', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('64', 'output', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'output', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('65', 'or', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'or', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('66', 'output.check', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'output.check', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('67', 'either.or.check', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'either.or.check', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('68', 'new.sentence', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.sentence', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('69', 'presort', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'presort', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('70', 'new.block.checka', NULL, NULL, NULL, 
     'ignor', NULL, NULL, 'new.block.checka', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('405241', 'format.lab.names', 'v format.lab.names', 'v1_FORMAT_LAB_NAMES', 'def FORMAT_LAB_NAMES(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[0:4]+}/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    for lnr, nLDict in enumerate(nameList):/n        nameptr = lnr + 1/n        namesleft = numnames - lnr/n        if numnames == 1:/n            if nLDict[von] != ':/n                von = nLDict[von][0]/n            else: /n                von = '/n            if nLDict[last]!= ':/n                last = nLDict[last][0]/n            else: /n                last = ' /n            t = von+last/n            if len(t) < 2:/n                if len(nLDict[last])>=3:/n                    last = nLDict[last][0:2]/n                else:/n                    last = nLDict[last]/n                t = last /n            nameresult = t/n            return nameresult/n        if nameptr < 4:/n            if nLDict[von] != ':/n                von = nLDict[von][0]/n            else: /n                von = '/n            if nLDict[last]!= ':/n                last = nLDict[last][0]/n            t = von+last            /n            nameresult= nameresult+t/n    return nameresult', 
     'compUserSQLPython', 0, ' FORMAT_LAB_NAMES', 'format.lab.names', 'alpha');
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('405246', 'sort.format.names', 'v sort.format.names', 'v1_SORT_FORMAT_NAMES', 'def SORT_FORMAT_NAMES(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[1:len(FieldValue)-2]/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    for lnr, nLDict in enumerate(nameList):/n        nameptr = lnr + 1/n        namesleft = numnames - lnr/n        first = nLDict[first]/n        von = nLDict[von]/n        last = nLDict[last] /n        jr =  nLDict[jr]/n        t = von+last+first+jr/n        nameresult= nameresult+t/n    return nameresult', 
     'compUserSQLPython', 0, ' SORT_FORMAT_NAMES', 'sort.format.names', 'abbrv');
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('411844', 'format.crossref.editor', 'format.crossref.editor', '"editor_FORMAT_CROSSREF"', 'def FORMAT_CROSSREF(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[1:len(FieldValue)-2]/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    if nameList[0][von] != ':/n        von1 = nameList[0][von]+"~"/n    else: /n        von1 = '/n    if nameList[0][last]!= ':/n        last1 = nameList[0][last]/n    else: /n        last1 = '/n    if numnames >1:      /n        if nameList[1][von] != ':/n            von2 = nameList[1][von]+"~"/n        else: /n            von2 = '/n        if nameList[1][last]!= ':/n            last2 = nameList[1][last]/n        else: /n            last2 = '/n    else:/n        von2 = '/n        last2 = '/n    t1= von1+last1         /n    t2= von2+last2            /n    if numnames == 1:/n        nameresult = t1/n    if numnames > 2:/n        nameresult = t1 + " et~al "/n    if numnames == 2:/n        if nameList[0][von]+nameList[0][first]+nameList[0][last]+nameList[0][jr] == others:/n            nameresult = t1 + " et~al "/n        else:/n            nameresult = t1 + " and " + t2/n    return nameresult', 
     'compUserSQLPython', 0, ' FORMAT_CROSSREF', 'format.crossref.editor', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('411843', 'format.names', 'v format.names', 'v1_FORMAT_NAMES', 'def FORMAT_NAMES(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[1:len(FieldValue)-2]/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    for lnr, nLDict in enumerate(nameList):/n        nameptr = lnr + 1/n        namesleft = numnames - lnr/n        if nLDict[first] == ':/n            first = nLDict[first]/n        else:/n            first = nLDict[first] +~/n        if nLDict[von] == ':/n            von = nLDict[von]/n        else:/n            von = nLDict[von]+~/n        if nLDict[last] ==':/n            last = nLDict[last]/n        else:/n            last = nLDict[last]/n        if nLDict[jr] == ':/n            jr =  nLDict[jr]/n        else:/n            , +nLDict[jr]/n        t = first+von+last+jr/n        if nameptr > 1:/n            if namesleft > 1:/n                nameresult = nameresult + ", " +t/n            else:/n                if numnames > 2:/n                    nameresult = nameresult + ","/n                if t == others:/n                    nameresult = nameresult + " et~al."/n                else:/n                    nameresult = nameresult + " and "/n        else:/n            nameresult = t/n    return nameresult', 
     'compUserSQLPython', 0, ' FORMAT_NAMES', 'format.names', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('405240', 'sort.format.names', 'v sort.format.names', 'v1_SORT_FORMAT_NAMES', 'def SORT_FORMAT_NAMES(FieldValue):/n    if FieldValue[0] =="{" and FieldValue[len(FieldValue)-1] == "}":/n        return FieldValue[1:len(FieldValue)-2]/n    nameL= formatNames.fName(FieldValue)/n    nameList = nameL.getNamlist()/n    nameresult  = '/n    numnames =  len(nameList)/n    for lnr, nLDict in enumerate(nameList):/n        nameptr = lnr + 1/n        namesleft = numnames - lnr/n        first = nLDict[first]/n        von = nLDict[von]/n        last = nLDict[last] /n        jr =  nLDict[jr]/n        t = von+last+first+jr/n        nameresult= nameresult+t/n    return nameresult', 
     'compUserSQLPython', 0, ' SORT_FORMAT_NAMES', 'sort.format.names', 'alpha');
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('5', 'l change.case$', 'v l change.case$', 'LOWER(v1)', NULL, 
     'compUserSql', NULL, 'change.case$', 'change.case$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('6', 'u change.case$', 'v u change.case$', 'UPPER(v1)', NULL, 
     'compUserSql', NULL, 'change.case$', 'change.case$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('7', 'initialize.longest.label', 'initialize.longest.label', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'initialize.longest.label', 'initialize.longest.label', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('8', 'longest.label.pass', 'longest.label.pass', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'longest.label.pass', 'longest.label.pass', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('9', 'add.period$', 'add.period$', %{add_period}, NULL, 
     'compUserSql', NULL, 'add.period$', 'add.period$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('0', 'default.type', 'default.type', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'default.type', 'default.type', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('10', 'init.state.consts', 'init.state.consts', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'init.state.consts', 'init.state.consts', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('11', 'empty.misc.check', 'empty.misc.check', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'empty.misc.check', 'empty.misc.check', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('12', 'newline$', 'newline$', \\n, NULL, 
     'compUserSql', NULL, 'newline$', 'newline$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('13', 'text.prefix$', 'v v text.prefix$', %{text_prefix, || v1 ||, || v2 ||}, NULL, 
     'compUserSql', 1, 'text.prefix$', 'text.prefix$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('14', 'sortify', 'sortify', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'sortify', 'sortify', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('15', 'sort.format.title', 'v sort.format.title', 'REPLACE(REPLACE(REPLACE(v1,A ),An ),The )', NULL, 
     'compUserSql', NULL, 'sort.format.title', 'sort.format.title', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('17', 'after.sentence', 'after.sentence', %{after_sentence}, NULL, 
     'compUserSql', NULL, 'after.sentence', 'after.sentence', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('18', 'pop$', 'pop$', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'pop$', 'pop$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('19', 'write$', 'write$', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'write$', 'write$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('21', 'emphasize', 'v emphasize', {\em}|| v1 ||\/}, NULL, 
     'compUserSql', NULL, 'emphasize', 'emphasize', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('22', 'output.state', 'output.state', %{output_state}, NULL, 
     'compUserSql', NULL, 'output.state', 'output.state', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('23', 'before.all', 'before.all', %{before_all}, NULL, 
     'compUserSql', NULL, 'before.all', 'before.all', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('24', 'after.block', 'after.block', %{after_block}, NULL, 
     'compUserSql', NULL, 'after.block', 'after.block', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('25', 't change.case$', 'v t change.case$', 'INITCAP(v1)', NULL, 
     'compUserSql', NULL, 'change.case$', 'change.case$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('26', 'tie.or.space.connect', 'v tie.or.space.connect', ' CASE WHEN LENGTH(v1)<3 THEN ~ ELSE   END || v1', NULL, 
     'compUserSql', 2, 'tie.or.space.connect', 'tie.or.space.connect', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('28', 'mid.sentence', 'mid.sentence', %{mid_sentence}, NULL, 
     'compUserSql', NULL, 'mid.sentence', 'mid.sentence', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('29', 'substring$', 'v v v substring$', 'substr(v1,v2, v3)', NULL, 
     'compUserSql', NULL, 'substring$', 'substring$', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('30', 'n.dashify', 'v n.dashify', 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(v1,--,"xxx"),"xxx"-,"xxx""yy"),-,--),"xxx",--),"yy",-)', NULL, 
     'compUserSql', 1, 'n.dashify', 'n.dashify', NULL);
 Insert into META_FUNCTIONS
    (ID, NAME, FUNCTION_BST, FUNCTION_SQL, FUNCTION_PYTHON, 
     ACTION, NUM_ORDER, FUNCTION, NAME_IN_BST, BST_NAME)
  Values
    ('31', 'field.or.null', 'field.or.null', ' ', NULL, 
     'replaceIgnoredFnc', NULL, 'field.or.null', 'field.or.null', NULL);
 COMMIT;
Retrieved from "http://www.semanticlab.net/index.php/META_FUNCTIONS"
Personal tools