Dec 10, 2016, 9:48 AM
178 Posts

format text

  • Category: Other
  • Platform: All
  • Release: 9.0.1
  • Role: Developer
  • Tags: format json string
  • Replies: 2

I would like to store the following json object:

 

{
    "user": "Patrick Kwinten",
    "gender": "male"
}

(json object generated via JSONlint.com)

in a Notes document as plain text (without the formatting) in a text field.

I tried several options e.g. @replace (thestring;@char(9:10:11:13);"")

but whatever I choose I still get 'tabs' returned which I do not want to store.

anyone got a clue how to format the text properly ?

 

Dec 19, 2016, 3:20 PM
178 Posts
workd well!

Hejsan Ketil

 

your code works fine. 

 

due to some reason I must have overlooked it.

 

thanks/tack for your help