Object Report - decoding ^(yearabbr) (or if.fieldvalue)

JustinB1 — Tue, 19 Jul 2022 03:08:36 GMT

Hello!

I am attempting to match a value to the ^(yearabbr) DAT tag, but I'm noticing that it has trailing whitespace at the end of it, despite not having that whitespace in the actual value (under district > years & terms).

Since you cannot use scripting to trim the whitespace within an object report, how can I match this value?

Here is an example of what I've tried:

^(decode;^(yearabbr);22-23;Year is 22-23; ) -- This does not match the value

^(yearabbr;if.fieldvalue.22-23.then=Test) -- This does not match the value

I've tried adding spaces to the end of '22-23' and tried wrapping it quotes with and without the space.

Ultimately, I'm trying to match a custom field to the ^(yearabbr) DAT tag, but noticed that it was appending whitespace when testing. I found this by printing ^(yearabbr)test which produces 22-23 test.

I'll continue to troubleshoot, but found this quite odd and thought it might just be me experiencing this. Does anyone have any tips or suggestions?

Thank you in advance!

Re: Object Report - decoding ^(yearabbr) (or if.fieldvalue)

JustinB1 — Tue, 19 Jul 2022 15:03:38 GMT

This seems to only be an issue with ^(yearabbr) and object reports, from what I can see. I cannot replicate this behavior on normal HTML pages or with other DAT tags.

I found a work around by using the ^(abbryearterm) and matching it with "^(customfield) YR" in a decode statement.

Hopefully this helps someone, but I'd wager the chances are slim.

topic Re: Object Report - decoding ^(yearabbr) (or if.fieldvalue) in Community Forum

Object Report - decoding ^(yearabbr) (or if.fieldvalue)

Re: Object Report - decoding ^(yearabbr) (or if.fieldvalue)