Field Code Heading reference

Question

I need some help in changing the Style Ref field codes for a non-existent heading.

My headings follow the decimals.

Heading 1 = 3.0

Heading 2 = 3.1

Heading 3 = 3.1.1

Heading 4 = 3.1.1.1

I'm writing a template document (for Doc2) with the use of field codes. Doc1 is a test request, and Doc2 is the test results that references Doc1.

An example being as follows:

For Doc1, Section 3.2.2 is the test setup, and Section 3.3.2 is the test procedure.

For Doc2, Section 3.2.2 gives the results of the test in section 3 of Doc1.

Similarly Doc2 Section 3.2.4 gives the results for Doc1's test setup in Section 3.2.4 and test procedure in Section 3.3.4.

Likewise, Doc2 Section 5.2.15 references Doc1's Sections 5.2.15 (setup) and 5.3.15 (procedure).

Since there are numerous sections for each set of tests, I wanted to use a field code to automatically give the correct test number. This is easy for the test setup references (they have the same heading), but how do I augment my field code to increase the middle heading number ("2" up to "3")?

Using the 3.2.2, Doc2 example, I have the following field code:

Section {STYLEREF  "Heading 3" \n \t}

  Which yields "Section 3.2.2"

How can I get a "Section 3.3.2"? When there is never a"3" used for Heading 2?

Any help would be appreciated! Thank you!

***Post moved by the moderator to the appropriate forum category.***

Answer 1

re. an equivalent for your SUBSTITUTE expression in Word, there isn't one in the "Field Language", primarily because the Field language does not have any functions like MID, LEFT, INSTR etc. To get string manipulation facilities you basically have to use a DATABASE field connected to a data source that supports an SQL dialect with those kinds of functions. Having a DATABASE field is overkill IMO, and also requires that you have an external file in a known place, which tends to make distribution of documents difficult. It's also "Windows desktop ord only" as Mac Word cannot connect to any such data source. But if you want to pursue that, you could look at the files I posted at http://goo.gl/EYxYij in response to a rather different problem and adapt it for your needs. (Sorry, the problem in there is different enough that it might not be obvious how to adapt the code, but in essence you need to start with a field that looks like

{ QUOTE { DATABASE \d "the database pathname" \s "SELECT '{ STYLEREF 3 \n }'" } }

and use string and logical functions to split the heading number apart and reconstruct it. The total length of the SQL string cannot exceed 255 or perhaps 511 characters but I would think that would be enough in this case. 

If your heading numbering is such that your x.y.z numbers never have y > 9 or z > 9 and "." is the decimal point in your locale and the associated Heading 2 paragraph is always present, I think you can probably get "x.y+1.z" using something like the following:

{ QUOTE { =INT{ STYLEREF 2 \s #0.0 }) }{ =.1+{ STYLEREF 2 \s #.0 } #.0 }{ ={ STYLEREF 3 \s #0.0 }-{ STYLEREF 2 \s #0.0 } #.0 } }

(Not seriously tested!)

That relies on a bit of weirdness in Word's { = } field where it will treat x.y.z as if it is x.y+.z. IN my view it's not such a great idea to rely on what is basically a Word kludge. If y or z can go beyond 9, there is a problem because .1 is arithmetically the same as .10 and so on, so you would then start having to use tests such as { IF { STYLEREF 2 \n } = "*0" } to determine whether "y" is .1 or .10, .2 or 20 and so on, and the same to determine whether z is .1 or .10. I would guess it can be done but I haven't pursued that myself.

Answer 2

1. One possibility would be to use VBA to create Document variables that let you map one number to another. As a simple example, if you know that you need a reference to 3.3.2 but you can only get "3.2.2" using field codes then you can use

Activedocument.Variables("3.2.2").Value = "3.3.2"

Then in your document you would use something like 

{ DOCVARIABLE { STYLEREF 3 \n } }

to display 3.3.2.

If you need more than one mapping, i.e. need to get 3.3.2 and 3.4.2, you could consider

Activedocument.Variables("a3.2.2").Value = "3.3.2"

Activedocument.Variables("b3.2.2").Value = "3.4.2"

then

{ DOCVARIABLE "a{ STYLEREF 3 \n }" }

{ DOCVARIABLE "b{ STYLEREF 3 \n }" }

If there is a regular pattern to the mappings, you may be able to code a simple VBA loop to generate all the necessary mappings, and generate as many as the document needs. You don't have to retain any VBA in the document to make this work, i.e. you can run whatever VBA you need, then just make use of the generated variables using DOCVARIABLE fields.

All the {  } need to be the special field code braces that you can insert using ctrl-F9 on Windows Word.

2. Personally, I think I would try to find a different way to relate one numbering scheme to the other, but the feasibility and ease of doing that would depend rather a lot on what numbering standards you have to follow.

Answer 3

It is not going to be possible to achieve that using a STYLEREF, or any other type of REF field.  You could select the result of the STYLEREF field and then use CTRL+SHIFT+F9 to unlink it from its source and then edit the result to give you what you want.

Answer 4

But just to re-iterate, if your copy of Windows/Mac is set up for a locale that uses "," as the decimal point character rather than ".", none of these field-based calculations can work (unless perhaps your heading numbering looks like "1,2,3" rather than "!.2.3", which I doubt). Nor do I know any way to make them work without mapping or DATABASE along the lines we already discussed.

Answer 5

I've now had a look at doing the calculation for x.y.z where y and z can be 1 to 99. Rather than post the code here I've put it in a test document that you can download from https://goo.gl/TxwBzD

Let me know if it doesn't work for you - I tested on both Mac and Windows Word 2016 (though not so much on Windows).