All geek questions in one place

C # Regex.Replace, Colon as Delimiter, Ignore DateTime format

I have the following line:

[{names: {en: "US 30 - 5 Minute Level", es: "US 30 - 5 Minute Level"}, status: "A", displayed: "Y", start_time: "2011-05-20 00:00:00", start_time_xls: {en: "20th of May 2011 00:00 am", es: "20 May 2011 00:00 am"}, suspend_at: "2011-05-20 16:53:48", is_off: "Y", score_home: "", score_away: "", bids_status: "", period_id: "", curr_period_start_time: "", score_extra_info: "", settled: "N", ev_id: 2688484, ev_type_id: 10745, num_mkts: 5, venues: {en: "", es: ""}, disporder: 2040, ev_stream_available: false}]

I need to surround all variable names with quotation marks so that this is confirmed as JSON. I did the following, but also shared the dates.,

 Regex.Replace(input, @"(\w+:)", "\"$0\":", RegexOptions.None);

Exit after Regex.Replace:

 [{"names" {"en" "US 30 - 5 Minute Level", "es" "US 30 - 5 Minute Level"}, "status" "A", "displayed" "Y", "start_time" "2011-05-20 "00""00"00", "start_time_xls" {"en" "20th of May 2011 "00"00 am", "es" "20 May 2011 "00"00 am"}, "suspend_at" "2011-05-20 "16""53"48", "is_off" "Y", "score_home" "", "score_away" "", "bids_status" "", "period_id" "", "curr_period_start_time" "", "score_extra_info" "", "settled" "N", "ev_id" 2688484, "ev_type_id" 10745, "num_mkts" 5, "venues" {"en" "", "es" ""}, "disporder" 2040, "ev_stream_available" false}]

How can I change this to ignore them? Also, what a good web resource you can get at the bottom of regular expressions once and for all ?!

Thanks.

+6
source share
1 answer

Try this template:

 string pattern = @"\b([A-Za-z_]+)\b(?=:)"; string replace = "\"$0\""; string result = Regex.Replace(input, pattern, replace); Console.WriteLine(result);

[A-Za-z_]+ matches any upper / lower case alphabet and underscore one or more times. This works fine if none of the JSON names contain numbers. The metacharacter \b matches the word boundary and (?=:) matches - but does not fix - the colon. You will notice that the replace pattern does not include a colon.

Similarly, this pattern will work: @"\b([^\d\s]+)\b(?=:)" , because it matches everything that is not a number or space.

Learning regex requires a lot of practice to understand concepts, try examples, and wrap around how everything works. I suggest grabbing a tool that allows you to try them along with some tutorials. To get started:

  • 30 minute regex guide
  • Regular expression information is an excellent resource that explains various concepts and highlights the differences between regular expression mechanisms in different languages.
  • Expresso is a free tool, you just need to provide an email to register it. It also includes a 30-minute regular expression tutorial, which I linked to above.

That should get you started. If you really want to dive deeper, then two good books to check:

+3
source

Source: https://habr.com/ru/post/888661/

More articles:


All Articles