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