I am customizing a couple contest logforms and I found the expression LEFT(LOCATION,AT("|",LOCATION)) under the "Copy from Prefix table" tab. Seeing as I had a mess of entries only generated from contest logform(s) that resulted in multiple "|" being added in USERFIELDS, I was wondering if this expression could be contributing to that anomaly.
What does this expression do exactly ?? SORRY, answered this myself.....I just looked in help (duh) and see its returning everything to the left (including the pipe) of the pipe in the location. I was curious as I had one anomaly relating to VE PROV and the many pipes after that entry, i.e, VE PROV: AB |||||||||, and another with multiple VE PROV entries in secession, i.e., VE PROV: AB | VE PROV: AB |, VE PROV AB: |. Thought maybe this may have had something to do with one of them but it appears not the case.
Thanks de Brad