INDEX: index, scan, nearest, verify for substring in string, scalar in array, and scalar in file matrix column (f)

• substring in string search

  operations:
  • result = INDEX(string, substring [, options] )

  option	string search type	example	result
  0	case insensitive, default	INDEX("aA bB cC", "A")	1
  1	case sensitive	INDEX("aA bB cC", "A", 1)	2
  2	word	INDEX("aA bB cC", "A", 2)	0
  4	backward	INDEX("aA bB cC", "a", 4)	2
  8	scan for first character in substring	INDEX("aA bB cC", "cbx", 8)	4
  16	include trailing blanks	INDEX("a a a", "a ", 16)	3
  32	best match	INDEX("aA bB cCe"," bC",32)	3
  64	verify (1st character of string that is not in substring)	INDEX("aA bB cCe"," ab",64)	7

  ---

  • options are additive, e.g. option=1+4+8 scans case sensitive backward
  • ⇒ EDIT facilitates many string manipulations

• string in file matrix search

  operations:
  • result = INDEX( matrix_file_name(start_row, column), substring [, options] )
  1. OPEN( FIle=matrix_file_name, format=...)
  2. result is the absolute row number (independend of the current value of start_row) of the 1st matrix element that contains substring
  3. available options are as above

• scalar in vector search

  operations:
  • result = INDEX(vector, scalar [, options] )

  • comparison tolerance

    for all numeric comparisons in HicEst is 1E-13
  • example vector: vec5 = (3, 1, -1, 1, 5)

  option	numeric scalar search type	example	result
  0	forward, default. Finds are for ABS(delta) ≤ 1E13	INDEX(vec5, 1)	2
  4	backward	INDEX(vec5, 1.00001, 4)	0
  32	best match	INDEX(vec5, 1.00001, 4+32)	4

  ---

• numeric file matrix search

  operations:
  • result = INDEX( matrix_file_name(start_row, column), scalar [, options] )
  1. OPEN( FIle=matrix_file_name, format=...)
  2. result is the absolute row number (independend of the current value of start_row)
  3. available options are 0, 4, 32