Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What you need is a handy reference to <a href="http://www.asciitable.com/" rel="nofollow noreferrer">THIS</a> ASCII Table</p> <p><img src="https://i.stack.imgur.com/kOa2r.gif" alt="enter image description here"></p> <p>Also </p> <ol> <li>You do not need so many variables.</li> <li>When you declare variables as <code>Dim umlaut1, umlaut2, umlaut3 As String</code>, then only the last variable is declared as string in VBA. The first two are declared as <code>Variants</code></li> </ol> <p>Now back to the ASCII table.</p> <p>If you notice the special chars start from 128 and go up till 255 so simply use a loop to replace the unwanted characters.</p> <p><strong>NOTE</strong>: There is a <strong>one time</strong> slogging that you have to do. This will also ensure that you will not have to add more characters in the future. In the code below, simply add the text to be replaced in the same order as shown in the image above.</p> <p><strong>Code</strong>: (UNTESTED)</p> <pre><code>Function umlaut(text As String) Dim umlaut1 As String, rplString As String Dim i As Long, j as Long Dim MyArray '~~&gt; One time slogging rplString = ",ue,e,,a,,,,,,,,......." '&lt;~~ and so on. '~~&gt; The first one before the comma is empty since we do '~~&gt; not have any replacement for character represented by 128. '~~&gt; The next one is for 129 and then 130 and so on so forth. '~~&gt; The characters for which you do not have the replacement, '~~&gt; leave them empty MyArray = Split(rplString, ",") umlaut1 = text: j = 0 For i = 128 To 255 umlaut1 = Replace(umlaut1, Chr(i), MyArray(j)) j = j + 1 Next umlaut = umlaut1 End Function </code></pre> <p><strong>TIP</strong>: If you feel that you could have your solution by only considering up till say, ASCII 166, then simply amend the code accordingly :)</p>
    singulars
    1. This table or related slice is empty.
    1. POExcel user-defined formula to eliminate special characters
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSiddharth Rout
    1. USSiddharth Rout
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExcel user-defined formula to eliminate special characters
      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. VTAcceptedByOriginator
    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. VTUpMod
    1. COthanks a lot, that Looks very interesting indeed! But 2 Problems/questions: - the code is having #value as result - I do not find the error... - it seems to me that the ascci-codes are different for different languages - but i look deeper into hat when the code does not provide an error any more... my rplstring is for the Moment: rplString = "C,ue,e,a,,a,a,c,e,e,e,i,i,i,,A,e,a,A,o,,o,u,u,,,,o,,O,x,f,a,i,o,u,n,N,a,o,,,,,,i,,,,,,,,A,A,A,,,,,,,,,,,,,,,,,,,,,,,,,o,D,E,E,E,I,I,I,I,,,,,,I,,O,ss,O,O,o,O,u,b,b,U,U,u,y,Y,,,,,,3/4,,,,,,,,1,3,2," '<~~ and so on.
      singulars
      1. PO
      1. USMax
    2. COYou can type `?Chr(128)` in immediate window and see what it gives you...
      singulars
      1. PO
      1. USSiddharth Rout
    3. COany idea what the Problem with the code could be?
      singulars
      1. PO
      1. USMax
 

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