Getting strings between 2 characters C#

Question

I have a string which looks like

{"BTC":{"USD":7358.8},"ETH":{"USD":402.78},"LTC":{"USD":125.37},"DASH":{"USD":335.73},"XMR":{"USD":187.2},"NXT":{"USD":0.1272},"ZEC":{"USD":204.82},"XRP":{"USD":0.5296},"WAVES":{"USD":4},"BCH":{"USD":705.74},"EOS":{"USD":5.89},"XLM":{"USD":0.229},"ADA":{"USD":0.1601},"NEO":{"USD":52.03},"IOT":{"USD":1.07}}

What I want to get are the names(e.g : BTC, ETH, etc), and I was thinking of getting the text before " : " and after " " ", and removing whats unnecessary, but I don't really know if it is a good aproach or how to do it. Any help would be appreciated. Thanks !

This is JSON, just use JSON.NET to deserialize into a an object — maccettura, Apr 03 '18 at 14:13

Patrick Hofman · Answer 1 · 2018-04-03T14:25:39.427

4

The string seems JSON, so why not just parse it as is?

public class ExchangeRate
{
    public decimal USD { get; set; }
}

static class Program
{
    static void Main(string[] args)
    {
        string s = "{\"BTC\":{\"USD\":7358.8},\"ETH\":{\"USD\":402.78},\"LTC\":{\"USD\":125.37},\"DASH\":{\"USD\":335.73},\"XMR\":{\"USD\":187.2},\"NXT\":{\"USD\":0.1272},\"ZEC\":{\"USD\":204.82},\"XRP\":{\"USD\":0.5296},\"WAVES\":{\"USD\":4},\"BCH\":{\"USD\":705.74},\"EOS\":{\"USD\":5.89},\"XLM\":{\"USD\":0.229},\"ADA\":{\"USD\":0.1601},\"NEO\":{\"USD\":52.03},\"IOT\":{\"USD\":1.07}}";

        var er = JsonConvert.DeserializeObject<Dictionary<string, ExchangeRate>>(s);

        Console.ReadKey();
    }
}

If you expect multiple currencies, you can use:

var er = JsonConvert.DeserializeObject<Dictionary<string, Dictionary<string, decimal>>>(s);

Related: Easiest way to parse JSON response

edited Apr 03 '18 at 14:25

answered Apr 03 '18 at 14:16

Patrick Hofman

153,850
22
249
325

Yeah, it's JSON, but it will contain ~100 entries like that, and i'd have to manually write that s string you have which I think is not very efficient. But thanks a lot ! – weaverbeaver Apr 03 '18 at 14:17
4

@weaverbeaver thats not how it works, where is your JSON coming from? The bottom line is your JSON is exactly a `Dictionary`, so use the `JsonConvert.DeserializeObject` method like Patrick said and pass it whatever JSON string. If your JSON does not look like your example then you need to provide a [MCVE] – maccettura Apr 03 '18 at 14:20
Solved it, thanks a lot and sorry for the newbie question. – weaverbeaver Apr 03 '18 at 14:31

Sandeep · Answer 2 · 2018-04-30T13:42:29.900

1

I believe you are trying to use ticker API of some crypto-currency exchange to create probably a desktop notification app. I created one few months back and here is what i did:

Converted JSON to C# class using json2csharp.com website. Name it say JsonClass
Imported Newtonsoft.Json package in my C# project.

Used following code to initialize class

JsonTextReader reader = new JsonTextReader(new StringReader(JsonString));
if (reader.Read())
{
    JsonSerializer serializer = new JsonSerializer();
    jsonClassObject = serializer.Deserialize<jsonClass>(reader);
}

edited Apr 30 '18 at 13:42

answered Apr 03 '18 at 14:24

Sandeep

333
2
7

1

`JsonConvert` is easier to use. – Patrick Hofman Apr 03 '18 at 14:26
Thanks! will try that too. – Sandeep Apr 04 '18 at 07:07

maccettura · Accepted Answer · 2018-04-03T14:39:33.653

From your comment:

What I want to get are the names(e.g : BTC, ETH, etc)

It sounds like you just want the keys of the JSON.

With that in mind you dont even need to care what object the JSON is, just that its a Dictionary of some object. We use a little LINQ to select all the keys and viola:

//Gives an List<string> that is a collection of all the coin names
List<string> coins = JsonConvert.DeserializeObject<Dictionary<string, object>>(someJson)
                .Select(x => x.Key)
                .ToList();

This results in an List<string> that contains this data:

BTC,
ETH,
LTC,
DASH,
XMR,
NXT,
ZEC,
XRP,
WAVES,
BCH,
EOS,
XLM,
ADA,
NEO,
IOT

Fiddle here

Yeah, thats what I wanted and thats what I did, kind of. Thanks a lot ! — weaverbeaver, Apr 03 '18 at 14:31

Getting strings between 2 characters C#

3 Answers3