Databases
StackOverflow2013
Postsdbo
POProper Casing of Letters
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POProper Casing of Letters
    primarykey
    data
    text
    <p>I have a Problem here in my casing function. I used replace to change the all conjunction into a lower but still i have an error></p> <pre><code>Private Function UpCsing(ByVal sValue As String) As String Dim toConvert As String() = sValue.Split(" ") Dim lst As New List(Of String) For i As Integer = 0 To toConvert.Length - 1 Dim converted As String = "" If toConvert(i).Contains("^") Then converted = toConvert(i).ToUpper.Replace("^", "") Else converted = StrConv(toConvert(i), VbStrConv.ProperCase).Replace("^", "") End If lst.Add(converted) Next Dim ret As String = "" For i As Integer = 0 To lst.Count - 1 If i = 0 Then ret = lst(0) Else ret += " " + lst(i) End If Next Return ret.Replace(" For ", " for ").Replace(" In ", " in ").Replace(" Of ", " of ").Replace(" And ", " and ").Replace(" And/Or ", " and/or ").Replace(" By ", " by ") _ .Replace(" By ", " by").Replace(" 2Nd ", " 2nd ").Replace(" 3Rd ", " 3rd ").Replace(" At ", " at ").Replace("And/Or ", "and/or ").Replace("1St", "1st").Replace("2Nd", "2nd").Replace("3Rd", "3rd") _ .Replace("At ", "at ").Replace(" At", " at").Replace(" Of", " of").Replace(" &amp; ", " and ").Replace("Poc", "POC").Replace(" As ", " as ") _ .Replace("C/O", "c/o").Replace("$ ", "$").Replace(" And/Or ", " and/or ") End Function </code></pre> <p>error sample: 'For' should be 'for' but the word 'Forward' must be 'Forward' by my output change it into 'forward'</p> <p>Example 'For the main event and for us to forward' the output should be 'For the Main Event and for us to Forward' </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkelvzy
    1. USkelvzy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POProper Casing of Letters
      1. USkelvzy
      1. VTFavorite
    2. VO
      singulars
      1. POProper Casing of Letters
      1. This table or related slice is empty.
      1. VTDownMod
    1. COShow us a string of what you want to convert with the expected results vs the actual?
      singulars
      1. POProper Casing of Letters
      1. USJeremy Thompson
    2. COExample 'For the main event and for us to forward' the output should be 'For the Main Event and for us to Forward'
      singulars
      1. POProper Casing of Letters
      1. USkelvzy
    3. COsee my edit. I have attached a screenshot proving your code outputs what you expect.
      singulars
      1. POProper Casing of Letters
      1. USJeremy Thompson
 

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