Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Not sure how well this will work, but this is what I came up with:</p> <pre><code> string input = "A bgt abc hyi. Abc Ab df h"; Dictionary&lt;string, string&gt; map = new Dictionary&lt;string, string&gt;(); map.Add("abc", "cde"); map.Add("ab df", "de"); string temp = input; foreach (var entry in map) { string key = entry.Key; string value = entry.Value; temp = Regex.Replace(temp, key, match =&gt; { bool isUpper = char.IsUpper(match.Value[0]); char[] result = value.ToCharArray(); result[0] = isUpper ? char.ToUpper(result[0]) : char.ToLower(result[0]); return new string(result); }, RegexOptions.IgnoreCase); } label1.Text = temp; // output is A bgt cde hyi. Cde De h </code></pre> <p><strong>EDIT</strong> After reading the modified question, here's my modified code (it turns out to be similar steps to @Sephallia's code.. and similar variable names lol )</p> <p>The code now is a bit more complicated.. but I think it's ok</p> <pre><code> string input = @"As he didn't achieve success, he was fired. As he DIDN'T ACHIEVE SUCCESS, he was fired. As he Didn't Achieve Success, he was fired. As he Didn't achieve success, he was fired."; Dictionary&lt;string, string&gt; map = new Dictionary&lt;string, string&gt;(); map.Add("didn't achieve success", "failed miserably"); string temp = input; foreach (var entry in map) { string key = entry.Key; string value = entry.Value; temp = Regex.Replace(temp, key, match =&gt; { bool isFirstUpper, isEachUpper, isAllUpper; string sentence = match.Value; char[] sentenceArray = sentence.ToCharArray(); string[] words = sentence.Split(' '); isFirstUpper = char.IsUpper(sentenceArray[0]); isEachUpper = words.All(w =&gt; char.IsUpper(w[0]) || !char.IsLetter(w[0])); isAllUpper = sentenceArray.All(c =&gt; char.IsUpper(c) || !char.IsLetter(c)); if (isAllUpper) return value.ToUpper(); if (isEachUpper) { // capitalize first of each word... use regex again :P string capitalized = Regex.Replace(value, @"\b\w", charMatch =&gt; charMatch.Value.ToUpper()); return capitalized; } char[] result = value.ToCharArray(); result[0] = isFirstUpper ? char.ToUpper(result[0]) : char.ToLower(result[0]); return new string(result); }, RegexOptions.IgnoreCase); } textBox1.Text = temp; /* output is : As he failed miserably, he was fired. As he FAILED MISERABLY, he was fired. As he Failed Miserably, he was fired. As he Failed miserably, he was fired. */ </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POReplace text while keeping case intact in C#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USElias
    1. USElias
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POReplace text while keeping case intact in C#
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COinteresting - but seems to be able to upcase only when the caps is on the first letter - maybe i wasn't so clear on my question - i need to keep caps - so if the setence had somwhere ABc it would need to be changed to CDe - however that could be achieved to a point - but only when length matched i guess - will look deeper into your solution to see what i can pull out of it - if anything
      singulars
      1. PO
      1. US537mfb
    2. COAs 537mfb mentioned, it doesn't work for ABc -> CDe as the result would be Cde. For cases where the `key` and the `value` are the same length, this is easily resolved using a for loop using the `.Length` property as the end condition. It may be necessary to have more clarification regarding what happens in the `ad df -> de` case. What happens depending on what letters are capitalized in `ad df`? (Posed this question on the Original Question as well)
      singulars
      1. PO
      1. USSephallia
    3. CO@Sephallia edited the question in an attempt to clarify AND reduce scope of the problem
      singulars
      1. PO
      1. US537mfb
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload