How to remove the brackets from the value received from airtable

[Syed_Khalid_Mahmood]

Hi,
I wanted to get only one row of a column in airtable. Hence I set the maximum record value to 1. Till now everything was correct.

I wanted to display the text received from airtable in a label. Hence I added the following code…

What I get is the value of the spreadsheet but with two brackets before and after the text. Is there any way I can remove that and why is this happening?

[dora_paz (Dora)]

Try

[Asd_fasd]

If there are only two brackets(at the start and at the end) you can use segment block for delete them.

[Still-learning (1-2-3-4...)]

You can use two replace blocks even…

[Asd_fasd]

What if there is another bracket in the text?

[Still-learning (1-2-3-4...)]

Two replace block i mentioned , in one replace block ,can add ( and in another block he can add )… even if more number of brackets obtained it will be removed

But dora method will be good to use.

[Asd_fasd]

i mean if there is another bracket in the main text: for example main text is sqrt{25}=5. when he received this text it will be {sqrt{25}=5}. if you use replace block it will be sqrt25=5

[Still-learning (1-2-3-4...)]

(deleted)…

[Asd_fasd]

@Still-learning

But dora method will be good to use.

yes, fully agree

[dora_paz (Dora)]

Airtable returns values as list, so since you are setting max record to 1 with above blocks you will get sqrt{25}=5

[Didyme_Apps]

Maybe this Steven Leary’s video can be useful.

Remove Parentheses () from lists - App Inventor

This is a detail of code that replace ( )

[Syed_Khalid_Mahmood]

Thanks for your valuable reply. But using these blocks, I can only remove the bracket at the first but the last bracket still remains.

[dora_paz (Dora)]

@Didyme_Apps Why use so many blocks when in the specific problem it can be done with one block ?

[Asd_fasd]

oh i am sorry i sent the block without testing, write length.values - 2 instead of 1

[Syed_Khalid_Mahmood]

It worked!!! Thanks a ton. Can you please edit the above solution so that i can mark it as the correct answer.

[dora_paz (Dora)]

I really can not understand the logic in that solution, you have a list with just one item and you want to use segment and …

[Still-learning (1-2-3-4...)]

@dora_paz

can not understand the logic

Me too …

[Asd_fasd]

okay, just one minute

[Asd_fasd]

done. you can mark it as a solution

[Taifun]

@Asd_fasd

If there are only two brackets(at the start and at the end) you can use segment block for delete them.

@Still-learning

use two replace blocks

@Didyme_Apps

This is a detail of code that replace ( )

rather than removing brackets you should learn how to work with lists…

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun