how to clean a query?

Certified Associate Developer

Hello again, 

you guys were so awesome last time I decided I would take a chance again and reach back out to see if you can help me again,

I am attempting to grab just the actual data from my query,

for example my list of 50 states returns:

on the front end and this is the query returns 

  • Dictionary
      • stateAbrv"AL"(Text)
      • Dictionary
          • stateAbrv"AK"(Text)
          • Dictionary
              • stateAbrv"AZ"(Text)
                • ...

              I have tried to use right( query(), 11

              and I get 

              why are only 2 chars taken off when 11 should be?

              is there another way I could/should be doing this?

              many thanks,

              Kevin

                Discussion posts and replies are publicly visible