Bablosoft

importing csv to database with colons and breaklines : in it

Support

  • bankaiB

    how to create chrome profile database

    Support
    0 Votes
    5 Posts
    1039 Views
    bankaiB

    @super84 I've read it. But I don't understand how it works. Can you make a video about it. Thank you so much
    I tried running with the following link: C:\Users\Administrator\Desktop\akm
    This directory is empty. After running it, nothing happens.

  • H

    How to ? database to delete the same records

    Support
    0 Votes
    2 Posts
    715 Views
    H

    @Fox @Administrator

  • L

    Import Proxies from Url, help.

    Support
    0 Votes
    5 Posts
    24742 Views
    bigoratB

    @lymz101 Well, it's a file with data, not an answer in json format, save it to disk and from it already take a random string for example, and then it should be parsed

  • Y

    Saved text to file skips breaklines

    Support
    0 Votes
    3 Posts
    1615 Views
    Y

    @support_dan

    but I pasted variable that contains:
    word1
    word2
    word3

    if I used your modification, it would be
    wordword2word3 BREAKLINE

    Anyway thanks, I have done it already with lists.

    alt text

    so variable:
    word1
    word2
    word3

    is saved as:
    word1word2word3

    then I read it from file as list and save to file as list, and its:
    word1
    word2
    word3

  • D

    How to load CSV file MultiLine

    Support
    0 Votes
    4 Posts
    2453 Views
    supportS

    @Diya.3rif BAS has internal function csv_parse, but it doesn't handle rows without commas.
    So this won't work

    "AA 11111 11111" "BBB 2222 2222"

    while this

    "AA 11111 11111", "BBB 2222 2222"

    will work.

    Anyway there is regexp support, so you can process text very easy.
    This regexp should work for you \"([^\"]+)\"

    And here is project which solves your problem.
    0_1504114213349_MultilineCsvProcess.xml