# Is there a way to remove the extra characters from JSON result?
**URL:** https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606
**Category:** Ask for Help
**Created:** [December 12, 2023, 12:42pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606 "2023-12-12T12:42:43Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@smaxss](https://community.glideapps.com/u/smaxss)
#### Post date: [December 12, 2023, 12:42pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/1 "2023-12-12T12:42:44Z")
Hi,
I’m using the OpenAI output as JSON, however it being wrapped in comments that are not recognised by the parser.
Is there any way to avoid this without too many loops with trimming the text?
At the end I want to split the result into different columns, like below
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 12, 2023, 12:49pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/2 "2023-12-12T12:49:14Z")
Are you referring to the backticks?
What does your prompt look like?
You should be able to craft it so that only the JSON is returned.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 12, 2023, 12:53pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/3 "2023-12-12T12:53:14Z")
This is not a JSON format… how did you get it? What kind of script?.. You can clean it by replacing the first characters… anything before the first curly bracket must go away…
---
### Author:  [@smaxss](https://community.glideapps.com/u/smaxss)
#### Post date: [December 12, 2023, 12:57pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/4 "2023-12-12T12:57:05Z")
yes, these backticks are causing me an issue.
I’m using output from OpenAi integration with the following prompt (part is shown)
There is also an option to return in JSON, which makes no difference in this case.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 12, 2023, 1:14pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/5 "2023-12-12T13:14:26Z")
Replace your code with this one:
```auto
if(p1){
let inputString = p1;
let indexOfFirstCurlyBracket = inputString.indexOf('{');
if (indexOfFirstCurlyBracket !== -1) {
let resultString = inputString.substring(indexOfFirstCurlyBracket);
return (JSON.parse(resultString).json.Title);
} else {
return "Curly bracket not found in the string."
}
}
return
```
---
### Author:  [@smaxss](https://community.glideapps.com/u/smaxss)
#### Post date: [December 12, 2023, 1:52pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/6 "2023-12-12T13:52:48Z")
Thank you for suggestion. I tried this code, but it did not work in the JS column. However it gave me an idea to construct a different code which did work at the end without adding interim columns
---
### Author:  [@swathi](https://community.glideapps.com/u/swathi)
#### Post date: [March 4, 2025, 7:38am UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/7 "2025-03-04T07:38:25Z")
This is to remove the invalid char at the start
How to remove invalid chars at the start before { as well as after }
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 4, 2025, 8:14am UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/8 "2025-03-04T08:14:03Z")
This is a very old thread. Can you please explain more about your use case?
Please show the data you have, how you get it, and your desired end ressult.
---
### Author:  [@swathi](https://community.glideapps.com/u/swathi)
#### Post date: [March 4, 2025, 9:18am UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/9 "2025-03-04T09:18:48Z")
From the AI response we will get json like below
“Here is the sample response{“productId”: 123, “productCode”:“code1”} end”
Need to remove prefix text “Here is the sample response” as well as suffix text at end after last } which is “end”
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 4, 2025, 9:27am UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/10 "2025-03-04T09:27:11Z")
Change your prompt. Instruct the AI to return only the JSON and nothing else.
Question: Are you using “Document to Text” or “Generate Text”? If so, try using “Text to JSON” instead.
---
### Author:  [@swathi](https://community.glideapps.com/u/swathi)
#### Post date: [March 4, 2025, 10:02am UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/11 "2025-03-04T10:02:58Z")
Yes but sometimes the prompt return invalid text at start and end if promptInput is not proper
The prompt input is unstructured like “123 code1” then it returns output in json
{“productId”: 123, “productCode”:“code1”}
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 4, 2025, 11:21pm UTC](https://community.glideapps.com/t/is-there-a-way-to-remove-the-extra-characters-from-json-result/68606/12 "2025-03-04T23:21:07Z")
You should use Text to JSON to ensure the JSON output.