Pulling the data from DB using API

Hi All,

In my DB there are 3 rows of data available, using API service i’m pulling the data from DB.
When i pulling the data, the data come like below

value
N,test,N,N,$$,$$,N,$$,test,$$,544545,venu,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,END

N,test-1,N,N,$$,$$,N,$$,test-1,$$,544545,venu,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,END

N,test-2,N,N,$$,$$,N,$$,test-2,$$,544545,venu,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,$$,END

It has 3 rows of data.
How to decode this one to normal data.
Pls help me out

1 Like

Hey @sudhasagar,

You need to just ignore all the dollar values and keep the rest.

Use split string manipulation please.

Thanks :slight_smile:

Hi @Nithinkrishna
Use strinput.tostring.replace("$","")

Thanks
Ashwin.S

Tq, I understand the process