Databases
StackOverflow2013
Postsdbo
POExtract substring by utf-8 byte positions
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExtract substring by utf-8 byte positions
    primarykey
    data
    text
    <p>I have a string and start and length with which to extract a substring. Both positions (start and length) are based on the byte offsets in the original UTF8 string.</p> <p>However, there is a problem: </p> <p>The start and length are in bytes, so I cannot use "substring". The UTF8 string contains several multi-byte characters. Is there a hyper-efficient way of doing this? (I don't need to decode the bytes...)</p> <p>Example： var orig = '你好吗？'</p> <p>The s,e might be 3,3 to extract the second character (好). I'm looking for</p> <pre><code>var result = orig.substringBytes(3,3); </code></pre> <p>Help!</p> <p><strong>Update #1</strong> In C/C++ I would just cast it to a byte array, but not sure if there is an equivalent in javascript. BTW, yes we could parse it into a byte array and parse it back to a string, but it seems that there should be a quick way to cut it at the right place. Imagine that 'orig' is 1000000 characters, and s = 6 bytes and l = 3 bytes.</p> <p><strong>Update #2</strong> Thanks to zerkms helpful re-direction, I ended up with the following, which does <strong>NOT</strong> work right - works right for multibyte but messed up for single byte.</p> <pre><code>function substrBytes(str, start, length) { var ch, startIx = 0, endIx = 0, re = ''; for (var i = 0; 0 &lt; str.length; i++) { startIx = endIx++; ch = str.charCodeAt(i); do { ch = ch &gt;&gt; 8; // a better way may exist to measure ch len endIx++; } while (ch); if (endIx &gt; start + length) { return re; } else if (startIx &gt;= start) { re += str[i]; } } } </code></pre> <p><strong>Update #3</strong> I don't think shifting the char code really works. I'm reading two bytes when the correct answer is three... somehow I always forget this. The codepoint is the same for UTF8 and UTF16, but the number of bytes taken up on encoding depends on the encoding!!! So this is not the right way to do this.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKaii
    1. UStofutim
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExtract substring by utf-8 byte positions
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POExtract substring by utf-8 byte positions
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POExtract substring by utf-8 byte positions
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe start and length for `substr` are in character, not bytes.
      singulars
      1. POExtract substring by utf-8 byte positions
      1. USnhahtdh
    2. COhttp://stackoverflow.com/q/1240408/251311
      singulars
      1. POExtract substring by utf-8 byte positions
      1. USzerkms
    3. CO@zerkms - I found that too, though I think that decoding the whole string to bytes, picking off the substring and going back would be really inefficient. What if there are 10000000 characters and I want bytes 6-12? Seems that converting the whole string would be a terrible idea.
      singulars
      1. POExtract substring by utf-8 byte positions
      1. UStofutim
 

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