0

Request to Remove Quotation Marks from Field Return Value

Test2.ninox

Hello everyone,

I would like to know if it’s possible to modify the return value of a program field so that the word name is returned without quotation marks.

I’d really appreciate any guidance or support. Thank you!

 

Before

[{"name":"Apple"},{"name":"Banana"},{"name":"Orange"},{"name":"Grape"},{"name":"Strawberry"},{"name":"Mango"},{"name":"Pineapple"},{"name":"Peach"},{"name":"Cherry"},{"name":"Blueberry"}]

after

[{name:"Apple"},{name:"Banana"},{name:"Orange"},{name:"Grape"},{name:"Strawberry"},{name:"Mango"},{name:"Pineapple"},{name:"Peach"},{name:"Cherry"},{name:"Blueberry"}]

 

9 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 days ago
    • Reported - view

    let src := before;
    let res := replace(src, "{""", "{");
    let after := replace(res, """:", ":");
    after

      • gold_cat
      • yesterday
      • Reported - view

       Thank you for your help.👍

    • red_kite
    • 2 days ago
    • Reported - view

    another possibility is the following. But why?

    let salesData := (select tab1).("{name: " + """" + Te + """}");
join(salesData, ",
")
      • gold_cat
      • yesterday
      • Reported - view

       Thank you for your help. I made a simple problem more complicated.

      • red_kite
      • yesterday
      • Reported - view

       Well, then we're already two. 😐

      • gold_cat
      • 20 hrs ago
      • Reported - view

       Hi, new friend.😁

    • Fred
    • 2 days ago
    • Reported - view

    Question: Why are you using a JSON format in your code if you don't want quotes around the key?

      • gold_cat
      • yesterday
      • Reported - view

        I thought the chart wasn’t displaying because of a data format problem...

      • gold_cat
      • yesterday
      • Reported - view

       I was trying to connect data to a chart, but it just wouldn’t display. I thought it was a data format issue.

Login to reply

Content aside

  • Status Answered
  • 20 hrs agoLast active
  • 9Replies
  • 49Views
  • 4 Following