Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lookups fail if data has a left bracket [

Highlighted
Copper Super Contributor
Posts: 72
Country: USA

Lookups fail if data has a left bracket [

 

Testing in the desktop v20 version of Act Premium,  I found that the character [  (a left bracket) will not work in an Act! lookup.   Cliff Roberts and I were using an ACT 6 Contact ID as a matching field to link data in an one ACT database to a different ACT database.  We noticed doing tests inside ACT that any lookup with a left bracket failed to find the records.  Act! said no contact found.  

 

Using OAK!Merge to do the matching, the records with the left bracket were correctly found and updated, We could update fields in database "A" from database "B" matching on the field that had data with the [ bracket; but our our tests in the ACT user interface failed.  

 

I checked all ascii characters from decimal 33 to decimal 126 and the only character that ACT cannot find is a [ left bracket.  This is weird, but i wanted to document it.   Lookups in ACT fail to find records with a [ left bracket.

 

 

These characters work correctly in an ACT lookup:

ABCDEFGHIJKLMNOPQURSTUVWXYZabcdefghijklmnopqrstuvwxyz
!"#$%&'()*+,-./0123456789:;<=>?@\]^_`{|}~

 

This character does not

[

 

 

I used the standard ASCII characters 32 to 126 to test 

 

 

Dec  Char     Dec  Char     Dec  Char

---------     ---------     ----------

32  SPACE     64  @         96  `

33  !         65  A         97  a

34  "         66  B         98  b

35  #         67  C         99  c

36  $         68  D        100  d

37  %         69  E        101  e

38  &         70  F        102  f

39  '         71  G        103  g

40  (         72  H        104  h

41  )         73  I        105  i

42  *         74  J        106  j

43  +         75  K        107  k

44  ,         76  L        108  l

45  -         77  M        109  m

46  .         78  N        110  n

47  /         79  O        111  o

48  0         80  P        112  p

49  1         81  Q        113  q

50  2         82  R        114  r

51  3         83  S        115  s

52  4         84  T        116  t

53  5         85  U        117  u

54  6         86  V        118  v

55  7         87  W        119  w

56  8         88  X        120  x

57  9         89  Y        121  y

58  :         90  Z        122  z

59  ;         91  [        123  {

60  <         92  \        124  |

61  =         93  ]        125  }

62  >         94  ^        126  ~

63  ?         95  _    

 

 

 

Alan Lee

1st ACC and still standing

www.OAKMerge.com