14 Replies Latest reply on Nov 11, 2015 10:16 AM by wideEyedPupil

    How can I convert arbitrary numbers [0,1,2] in a table to anchored objects (think traffic light)

    wideEyedPupil Level 1

      Brazil

      2

      2

      2

      0

      1

      0

      0

      0

      0

      1

      1

      1

      1

      1

      0

       

      0

      0

      12

      Cameroon

      2

      2

      2

      2

      2

      2

      1

      1

      1

      1

      2

      2

      2

      2

      1

       

      1

      1

      27

      Canada

      2

      2

      2

      2

      1

      1

      1

      1

      2

      1

      0

      1

       

       

      1

      2

      0

      0

      19

      China

      2

      2

      2

      2

      2

      1

      1

      2

      1

      1

      1

      1

      1

      0

      1

      1

      1

      1

      23

      Colombia

      2

      2

      0

      0

      0

       

       

      0

      0

      0

      1

      1

      1

       

      1

      0

      0

      0

      8

      Denmark

      2

      2

      2

      0

      2

      1

      1

      1

      1

      1

      2

      2

      2

      1

      1

      1

      1

      1

      24

      Egypt

      2

      2

      2

      2

      1

      2

      1

      1

      1

      1

      1

      1

      0

      1

      0

      1

      1

      0

      20

      Georgia

      2

      2

      2

      2

      1

      1

      1

      1

      1

      1

      1

      1

      1

      1

      1

      1

      1

      1

      22

      Hungary

      2

      2

      2

      2

      1

      1

      0

      0

      0

      0

      1

      1

      1

      1

      0

      0

      0

      0

      14

       

       

      So I want do a GREP style find and replace where I search for "0" and put a solid red circle in the table, search for "1" and I place a solid amber circle and "2" and solid green circle. Could be images or a glyph I suppose. (interested if images is possible I saw a InDesign training video on Adobe Communities where they placed clip art to style the 'look' of the table to be "interesting" (old school fancy design) so I think this is doable but I forget how. Otherwise I guess I can figure a glyph replacement out with the practice I've been getting.

       

      If I can continue to search and modify the three sets of circles i.e. change red ones to blue ones then that would be handy, thinking object styles or char colour I guess. I think the empty squares should be zeros I need to check on that.