title: Neo4j: Loading CSV file combined with substring function
body: <p>I am trying to load a *.csv file into neo4j and in the same load statement split the line (which has no delimiters but has a set location for the data that I need to create nodes from). I want to use the substring function, I can't figure out how to get it to work. The data reads in as a single line: </p>
  
  <p>0067011990999991958051507004+68750+023550FM-12+038299999V0203301N00671220001CN9999999N9+00001+99999999999</p>
  
  <p>I have tried using the following code: </p>
  
  <pre><code>LOAD CSV WITH HEADERS FROM "file:/c:/itw/Ltemps.csv" AS line
  WITH line
  WHERE line.year IS split((substring(line, 15, 19))) and line.temp IS split((substring(line, 88, 92))) and line.qlfr IS split((substring(line, 87, 88))) and line.qual IS split((substring(line, 92, 93)))
  MERGE (y:Year {year:line.year})
  MERGE (t:Temp {temp:line.temp})
  MERGE (f:Qlfr {qlfr:line.qlfr})
  MERGE (q:Qual {qual:line.qual})
  CREATE (y)-[r:HAS_TEMP]-&gt;(t);
  </code></pre>
  
  <p>I am looking to get 4 nodes: year, temp (an absolute value), a qualifier (positive or negative symbol), and a quality number. The indexes on for where the data lies in the string should be accurate. </p>