Bablosoft

What is the quickest way to extract data from a single column on Database ?

Support
  • P

    Main/Database/Select Records By Criteria
    I use this method to retrieve data from the Database; however, the list I receive is in the format column1:column2:column3:column4...
    What is the quickest way to extract data from a single column?
    I have tried the Main/String/Parse CSV string tool, but it takes a long time to process with a large amount of data.

    0

  • K

    POST data constructor problem

    Support
    0 Votes
    2 Posts
    756 Views
    FoxF

    @Kiryakov said in POST data constructor problem:

    hello, I have a problem with sending arrays with the POST data constructor, the server reads it as a string instead of an array, and it's giving me Status 400 instead of 200
    for example
    [[ERRORS]] = ["problem 1"] or [[ERRORS]] = ["Problem 1", "Problem 2"]
    and when i send it with POST like let say
    "mistake", [[ERORRS]] , the server say's it wants an array and not a string

    Exactly a month has passed, I think it's time to give an answer :D

    The most obvious answer is don't use data constructor:

    67b90da2-c5f1-4934-a148-d849d5b90987-изображение.png

    67ae0019-2537-4bc0-95c5-28491ed69165-изображение.png

  • M

    extract data with regex

    Support
    0 Votes
    2 Posts
    1171 Views
    FoxF

    @heshamyassin1 said in extract data with regex:

    i have a problem i am trying to get text with get element text when i do so and make extract with extract data in regex the log become blank but when i take the text itself and put in string to apply regex it success what i can do please help

    most likely there are line breaks in the text.

  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2664 Views
    BAS Viet NamB

    There are many ways to handle this issue. I'll show you one way.

    For a news website, it's almost impossible for recently added articles to have 100% identical content. Therefore, you just need to compare the latest data added to your database with the data you're checking. If they are 100% identical, then the data has already been added, so you can skip it and check the next piece of data using the same process.

    So, for your request, you can convert the database to a list format, then retrieve the last element corresponding to the latest data added (or you can retrieve the latest data directly from the database if you know how to work with databases). Use Parse CSV string to parse the string into article title and content.

    You can compare the title of the latest article with the title you're checking. If they are 100% identical, then it has already been added to the database. If you want to be more certain, you can also compare the content (although this may not be necessary).

    I hope you understand what I'm saying.

  • C

    Saving data to file or database after script completes

    Support
    0 Votes
    6 Posts
    3039 Views
    C

    @Allister Thanks again!

  • S

    How to parse database?

    Support
    0 Votes
    2 Posts
    1650 Views
    supportS

    @solarV Hi, just need to use "Parse string" action several times

    0_1490785858778_ParseString.png

    0_1490785886110_parsestring.xml