Color VB Comments

Changes color of text starting with a single quote (') on selected lines to green


Author(s) : Onetastic ★
Category : Formatting
Last Updated : October 17, 2016
Requirements : OneNote 2010 or above
Changelog :

October 17, 2016 (E9FA79) - Onetastic ★
Initial Version


Dan - 2017-01-25
Hello Omer,
what if I wrapped my word at both ends eg    %Hello% would a macro be able to isolate or identify that word using the index of characters?
If string contains characters start position?
Omer Atay - 2017-01-22
Dan: Macros currently don't have a way to query whole words or otherwise identify word boundaries. Therefore writing this kind of macro that has to deal with words is very hard.
Dan - 2017-01-22
Hello Omer,

I would like to Change the Font Color of words that have a % in front of them,

I know this is a lot to ask but I would be really grateful, please  please can you help me to adapt this so I can color my words.

<?xml version="1.0" encoding="utf-16"?>
<Macro name="Color VB Comments -Omer" category="TEST" description="Changes color of text starting with a single quote (') on selected lines to green" publishDate="00-00-00T00:00:00.000Z" version="15">
  <Comment text="----------------------------------------------------------------------------------" />
  <Comment text="    Color Words" />
  <Comment text="----------------------------------------------------------------------------------" />
  <Expression>$color = "#FF0099"</Expression>
  <Comment text="Find all the selected paragraphs" />
  <ForEach var="p">
    <Array>QueryObjects("Text", GetCurrentPage())</Array>
    <Comment text="Find quotes as the beginning of a comment" />
    <Expression>$quotes = QueryText($p, "%", false)</Expression>
      <Condition>Array_Length($quotes) == 0</Condition>
    <Comment text="Start coloring from the first quote " />
    <Expression>$quote = $quotes[0]</Expression>
    <Expression>$quote.fontColor = $color</Expression>
    <Comment text="Get all the text in the paragraph and color the ones that are after the first quote" />
    <ForEach var="text">
      <Array>QueryObjects("Text", $p)</Array>
        <Condition>$text.startIndex &gt; $quote.startIndex</Condition>
        <Expression>$text.fontColor = $color</Expression>

I have been trying for months and cant make it work :( :(
I have left the original as above as I cant work out how to isolate the words with a % in front of them.
Normally I have to copy and paste to word - and then paste back and I have too many pages to do everyday

When ever you have a chance thank you so much