Ok,

So I'm learning....posting this as an aide to myself and others who may benefit.

My previous post wasn't thought thru all the way.....All my issues of multiple pipes related to VE PROV, OBLAST, and CONTINENT. Not thinking clearly I obviously missed the fact that the the expression(s) are returning everything up to AND including the pipe from the Location in the prefix table. So, if the prefix table contains "Ve Prov:ab| Alberta", the expression will insert VE PROV:AB| in USERFIELDS (the "Alberta" is stripped out as its AFTER the pipe |). Oblasts are listed the same way in the location field with a pipe at the end of the Oblast name. So, I'm guessing that anything entered into USERFIELDS is by default seperated by a pipe which if true would ADD a pipe to each, i.e., VE PROV:AB||. In addition to that, the other expression I see is LEFT(LOCATION,AT("|",LOCATION)) which, guessing again, is adding an additional pipe (or more) as its returning everything in the location field up to and including the first pipe of what was already entered by any previous expressions, then yet another pipe as its an additional entry in USERFIELDS, maybe even if its "empty". So it seems I can have potentially 3, 4, or more pipes being added. I included a jpeg of the prefix table showing the description in the location field.

de Brad

I got the exact same results here. The expression LEFT(LOCATION,AT("|",LOCATION)) also appears in the line below, so it was duplicated. Not sure why it added so many ||||. I updated my master copy.

Thanks, I really appreciate it!

Dennis WN4AZY

LEFT(LOCATION,AT("|",LOCATION))

No, it still grabs everything including the pipe. IOTA:SA-007| for instance.

This is correct in this instance. It is a user-defined field in the proper format. and is being copied to userfields. I just don't know why having it in there twice just did't enter the value twice.

Tnx & 73,

Dennis WN4AZY