Split a column in sqlite3 with delimiter and add more rows

Multi tool use
Multi tool use











up vote
-1
down vote

favorite












Table schema



CREATE MYTABLE (ROWID PRIMARY KEY, FILENAME TEXT, HOUR INT);


Example:



My input table looks like below:



Input



1 /tmp/hello1.c!@#/tmp/hello2.c 12



2 /tmp/my1.c!@#/tmp/my2.c 13



I want to create the output as below: splitting filename with demlimiter '!@#'



1 /tmp/hello1.c 12



2 /tmp/my1.c 13



3 /tmp/hello2.c 12



4 /tmp/my2.c 13






c++ sqlite3







share|improve this question




























    up vote
    -1
    down vote

    favorite












    Table schema



    CREATE MYTABLE (ROWID PRIMARY KEY, FILENAME TEXT, HOUR INT);


    Example:



    My input table looks like below:



    Input



    1 /tmp/hello1.c!@#/tmp/hello2.c 12



    2 /tmp/my1.c!@#/tmp/my2.c 13



    I want to create the output as below: splitting filename with demlimiter '!@#'



    1 /tmp/hello1.c 12



    2 /tmp/my1.c 13



    3 /tmp/hello2.c 12



    4 /tmp/my2.c 13






    c++ sqlite3







    share|improve this question


























      up vote
      -1
      down vote

      favorite









      up vote
      -1
      down vote

      favorite











      Table schema



      CREATE MYTABLE (ROWID PRIMARY KEY, FILENAME TEXT, HOUR INT);


      Example:



      My input table looks like below:



      Input



      1 /tmp/hello1.c!@#/tmp/hello2.c 12



      2 /tmp/my1.c!@#/tmp/my2.c 13



      I want to create the output as below: splitting filename with demlimiter '!@#'



      1 /tmp/hello1.c 12



      2 /tmp/my1.c 13



      3 /tmp/hello2.c 12



      4 /tmp/my2.c 13






      c++ sqlite3







      share|improve this question















      Table schema



      CREATE MYTABLE (ROWID PRIMARY KEY, FILENAME TEXT, HOUR INT);


      Example:



      My input table looks like below:



      Input



      1 /tmp/hello1.c!@#/tmp/hello2.c 12



      2 /tmp/my1.c!@#/tmp/my2.c 13



      I want to create the output as below: splitting filename with demlimiter '!@#'



      1 /tmp/hello1.c 12



      2 /tmp/my1.c 13



      3 /tmp/hello2.c 12



      4 /tmp/my2.c 13






      c++ sqlite3




      c++ sqlite3






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 21 at 8:41

























      asked Nov 21 at 7:19









      goku

      253




      253





























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53407032%2fsplit-a-column-in-sqlite3-with-delimiter-and-add-more-rows%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















           

          draft saved


          draft discarded



















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53407032%2fsplit-a-column-in-sqlite3-with-delimiter-and-add-more-rows%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          ypOUS tyRjETwREHZCPdR3kF3xORi6dWXk Sq p0Op56oB1cp7W,q9xVjReB5AbSfL5zQ9suX,dIx,ir,iVL2kUbD9 jL u67KKR Pm3HLrqw
          -
          DO4Z LkHAqEGc 9oH5Rd B0TsOBQ OTPDDV1ms1Dyqgy4yK7apFQ2wZP95olluZ

          Popular posts from this blog

          xlwings: Save and Close

          Image
          1 I am trying to find out how to save and close to an existing workbook using xlwings after writing in it: import xlwings as xw list_of_values = [1, 2, 3] workbook_path = 'abc.xlsx' wb = xw.Book(workbook_path) ws = wb.sheets['sheet1'] ws.range('E35').value = list_of_values wb.save() wb.close() When I get to wb.save(workbook_path) , there is a prompt stating: 'A file named abc.xlsx' already exists in this location. Do you want to replace it?' I want to overwrite the file immediately without the prompt coming up. According to the docs, wb.save() should automatically overwrite (see: https://docs.xlwings.org/en/v0.6.4/api.html). I have also tried wb.save(workbook_path) but the pop-up still appears. Appreciate any help on this please. p.s. - I am basically try...
          Read more

          UPSERT syntax error linked to UPDATE in PostgreSQL (python)

          Image
          1 1 I'm still learning PostgreSQL. During my testing, I have only been using INSERT statement in either psycopg2 and now asyncpg. I now have the need to UPDATE data in my test database, instead of replacing all of it. I'm currently trying to do a simple replacement test in a testing table, before I move to development table with more data. I want to replace any $1 name that is in CONFLICT with a name that is already in the table users. I'm trying the query code, which is passed to the DB via asyncpg. I keep getting a syntax errors, so I'm a little lost on how to correct these errors. What is the proper syntax for this query? '''INSERT INTO users(name, dob) VALUES($1, $2) ON CONFLICT (name) DO UPDATE "users" SET name = 'TEST' W...
          Read more

          Some classess of my CSS file are not rendering into Django templates (most classess render without problems)

          Image
          up vote 0 down vote favorite I'm starting with Django, I've been throught this several hours, please help me! on my *.html file I have this code (and more): {% load static %} <link rel="stylesheet" href="{% static 'css/style.css' %}"> and since I added that static file, my page has style.. but some classes don't render, for example this div: <div class="nav-profile-image"> If I delete the class .nav-profile-image from style.css, the page still the same, that image has no container, it's very strange. I uploaded all the app on branch "problems": https://github.com/franchodl/robohome/tree/problems view trying to render: home url for home: http://127.0.0.1:8000/propietario/ template: ./own/templates/own/home.html static files: ./static ...
          Read more