Need help with Conditional Formatting
Posted: Sun Sep 03, 2017 6:46 am
Hello all,
I am feeling fairly humbled (alternatively, stupid) at the moment, since I cannot get right what I am hoping should be simple to set up...
Hopefully, someone will be able to point me in the right direction, as I am spending too much time on this – relative to what must still be done!
I am currently working with Government reports, and have set up a user-created Format for them.
All is working as it should, but unfortunately, the Reports themselves are not proving consistent, which is introducing edge cases that I am trying to cater for.
Simply put, the format output I require, is a follows:
NameOfGovtDept [Author(s)/(Eds)] Title (year)
That is working as expected - in that, where the Author field is empty, I have managed to set up a Conditional Formatting rule to then use the Editor field, and add the "ed/eds" behind the names, which is obviously not included where the authors are used.
And as above, if there are either Authors or Editors, they must be enclosed in the [ ] brackets.
My problem:
I have reached the limit of my understanding of Conditional Formatting in those instances (and sadly, this happens too frequently for it to be done manually), where BOTH the Author or Editor fields are empty...
BE, due to how I have things set up, is now producing NameOfGovtDept [(ed)] Title (year)...
As in, instead of leaving the entire a/e field blank, it is inserting "[(ed)]" in its place.
I want BE to drop EVERYTHING where there is neither an Author or Editor, as in just output "NameOfGovtDept Title (year)"
Here is my Formatting code:
I suspect that I need to be using either the Binding Quote ~ ~ option, or be using the $ option differently?
Any suggestions would be welcome!
I am feeling fairly humbled (alternatively, stupid) at the moment, since I cannot get right what I am hoping should be simple to set up...
Hopefully, someone will be able to point me in the right direction, as I am spending too much time on this – relative to what must still be done!
I am currently working with Government reports, and have set up a user-created Format for them.
All is working as it should, but unfortunately, the Reports themselves are not proving consistent, which is introducing edge cases that I am trying to cater for.
Simply put, the format output I require, is a follows:
NameOfGovtDept [Author(s)/(Eds)] Title (year)
That is working as expected - in that, where the Author field is empty, I have managed to set up a Conditional Formatting rule to then use the Editor field, and add the "ed/eds" behind the names, which is obviously not included where the authors are used.
And as above, if there are either Authors or Editors, they must be enclosed in the [ ] brackets.
My problem:
I have reached the limit of my understanding of Conditional Formatting in those instances (and sadly, this happens too frequently for it to be done manually), where BOTH the Author or Editor fields are empty...
BE, due to how I have things set up, is now producing NameOfGovtDept [(ed)] Title (year)...
As in, instead of leaving the entire a/e field blank, it is inserting "[(ed)]" in its place.
I want BE to drop EVERYTHING where there is neither an Author or Editor, as in just output "NameOfGovtDept Title (year)"
Here is my Formatting code:
Code: Select all
u1 {[a]^[e $(ed)^^(eds)$]} t (d).Any suggestions would be welcome!