Arcmap reads column of integers in .csv as strings instead of numbers
How would one format an Excel sheet so numeric fields are set to numeric field types when importing to ArcGIS 10.2?
16.04 Japanese Text Input not working I have to create a report on some student completions. The students each belong to one client. Here are the tables (simplified for this question).  CREATE TABLE  `clients` (   `clientId` int(10) unsigned NOT NULL auto_increment,   `clientName` varchar(100) NOT NULL default '',   `courseNames` varchar(255) NOT NULL default '' )   The courseNames field holds a comma-delimited string of course names, eg "AB01,AB02,AB03"  CREATE TABLE  `clientenrols` (   `clientEnrolId` int(10) unsigned NOT NULL auto_increment,   `studentId` int(10) unsigned NOT NULL default '0',   `courseId` tinyint(3) unsigned NOT NULL default '0' )   The courseId field here is the index of the course name in the clients.courseNames field. So, if the client's courseNames are "AB01,AB02,AB03", and the courseId of the enrolment is 2, then the student is in AB03.  Is there a way that I can do a single select on these tables that includes the course name? Keep in mind that there will be students from different clients (and hence have different course names, not all of which are sequential,eg: "NW01,NW03")  Basically, if I could split that field and return a single element from the resulting array, that would be what I'm looking for. Here's what I mean in magical pseudocode:  SELECT e.`studentId`, SPLIT(",", c.`courseNames`)[e.`courseId`] FROM ... I'm considering re-designing my personal website to promote my web services in my local area.  My issue is whether to do a one page website with a scroll-to navigation system. What effect does this have on SEO. As i understand it, you set stuff like h1's and meta description on specific page content. How does this work when all of your different content is on one page? Is the neutral wire considered safe? How to make equally sized windows in corners of the screen? Uniform convergence of $f_n(z)=nz^n$ in the set $|z|<\frac{1}{2}$ Is there any way to make a custom page.html.twig template in Drupal 8?  By default, Drupal generates some suggestions, but I'm looking for something like page--node--content-type.html.twig. Why does light in a room not form constructive and destructive interference patterns? I recently read this , which stated:     For scientists trying to design a compound that will attach itself to,   and modify, a target disease pathway, the critical first step is to   determine the electronic structure of the molecule. But modeling the   structure of a molecule of an everyday drug such as penicillin, which   has 41 atoms at ground state, requires a classical computer with some   $10^{86}$ bits—more transistors than there are atoms in the observable   universe. Such a machine is a physical impossibility. But for quantum   computers, this type of simulation is well within the realm of   possibility, requiring a processor with 286 quantum bits, or qubits.   Along with this resource estimate for penicillin, I've also seen  of the number of qubits required to model the ground state of caffeine (160 qubits). Given that the above report offers no reference(s) (probably in the name of business intelligence) and much Internet searching and looking into the quantum chemistry literature has come up short, my question is: Where are these resource estimates coming from – is there a journal article that published these numbers? I would really like to identify the methodology and assumptions used in making these estimates. How to hide title bar in Firefox 57 Quantum? I used to use an extension to hide/show the title bar in Firefox, but since Firefox 57 was released most of the extensions were disabled.  In Chrome I just uncheck the option "Use system title bar and borders" and it's done.  Are there any ways to do that? Draw somewhat random function I am trying to reconstruct this image here    I am not very happy with the code, as it uses hacking and adding white boxes and alike. My problem is now how do I draw the somewhat arbitary function in the figure? I tried to do a polynomial fit, but that did not work. I got dimensions to large, would a spline solution work better?    \documentclass{standalone}     \usepackage{tikz}     \usetikzlibrary{patterns}     \usepackage{pgfplots}     \pgfplotsset{compat=1.6}     \begin{document}     \begin{tikzpicture}      \begin{axis}[         xmin=-0.1,xmax=5,         xlabel={z},         ymin=0,ymax=4.5,     xtick={2.5,4},     xticklabels={$v_1$,$v_2$},     ytick={2.5,3.5},     yticklabels={$u_1$,$u_2$},     xlabel={$u$},       ylabel={$v$},     axis lines=middle]  \draw [fill=gray!40!white,thick,dashed] (axis cs:0,0) rectangle (axis cs:4,3.5); \draw [color=black,fill=white,thick,dashed] (axis cs:0,0) rectangle (axis cs:2.5,2); \draw [fill=black] (axis cs:0,0) rectangle (axis cs:0.01,4.45); \addplot+[black,thick,domain=0:5,no marks] {0}; % \node at (axis cs:2.5,0)    [anchor=south west] {$A$}; \node at (axis cs:4,0)      [anchor=south west] {$A'$}; \node at (axis cs:2.8,2.2)  [anchor=north]      {$B$}; \node at (axis cs:4.2,4)   [anchor=north]       {$B'$}; \node at (axis cs:0.25,2.5) [anchor=north]      {$C$}; \node at (axis cs:0.25,4)   [anchor=north]      {$C'$}; \node at (axis cs:0,0)     [anchor=south west]  {$O$}; % \end{axis} \end{tikzpicture} \end{document} How do they film the mirror scenes in movies? What are the antonyms of "append" and "prepend"? Generated Frattini Lemma Let $A$ be a normal subgroup of a group $G$. Let $B$ be a subgroup of   $A$ with the property that whenever $B_1 \leq A$ is conjugate to $B$   in $G$ then it is conjugate to $B$ in $A$. Prove that $G=AN_G(B)$   Help me some hints. How do you declare an interface in C++? How do I setup a class that represents an interface?  Is this just an abstract base class? Showing that $\lim_{x \to 1} \left(\frac{23}{1-x^{23}}-\frac{11}{1-x^{11}} \right)=6$ Rich Wizards, Poor Muggles Why, oh why, don't the Weasleys "conjure" up some diamonds/gold/etc, sell 'em to Muggles, and get rich? They could buy a mansion (like the Malfoys), and live there happily ever after.  I know there's  that prohibits one from conjuring food (which doesn't make much sense to me, either). Even if it applied to gold, what about all the other elements/compounds/materials? Could the law really be 'don't let a wizard conjure something if it'll make them richer'? That's totally nonsensical.  Why does Wizard society still have poor people, especially if they're talented? What are the use cases for different scoping constructs? Install suspension forks on non-suspension bike I have a 1990s Saracen PowerTrax. Is there a way I can install a suspension fork, or will that muck up the bike somehow? I'm actually interested in ways to raise the bars with respect to the seat, so that wouldn't be a problem. My toes rubbing in the wheel, in the other hand, would definitely be a problem. New navigation doesn't appear to alert of question changes when watching a tag I am watching the  tag on Stack Overflow. My filter looks like this:    I do not receive notification of new questions. Previously I'd get notifications like this:    This notification does work when watching the  page of Meta.   Are notifications only active for a certain set of filter options? If so, what are they? If not, can we get them back when watching pages other than the main page?