Help needed in expression

[#1]

Hi All,

I have data in this format {"Marks":"95"},inorder to take the values 95 alone i used the expression

=subfield(columnname,':",3)but it does not return the value 95

Kindly help me in getting this value 95 alone

Thanks in advance

[Clever_Anjos]

=keepchar(subfield(columnname,':",2),'0123456789')

[stantrolav]

=right(3,2)

this would get you 2 digits from right, starting at third digit from right.

[swuehl]

Why do you use 3 as argument to subfield (where I would expect 2)?

If you then get

95"}

you might use an additional purgechar():

=subfield(purgechar(columnname,'{}""'),':',2)

[stantrolav]

And what is the answer? ashoksenthilcould you do smth with this theme? There are lots of questions here Not Answered. Don't leave one more among them.