Bablosoft

How to copy list and paste into database

Support

  • B

    Check if variable contains something from a list

    Support
    0 Votes
    5 Posts
    746 Views
    B

    @sergerdn
    Thank a lot!
    Its not excatcly what I looked for but based on your code I made a few changes and have a working solution now:

    function findKeywordsInTitle(keywords, title) { var words = title.toLowerCase().split(/\W+/); var foundKeywords = []; keywords.forEach(function (keyword) { if (words.indexOf(keyword.toLowerCase()) !== -1) { foundKeywords.push(keyword); } }); return foundKeywords; } var title = [[VARIABLE]]; var keywords = [[KEYWORDS]]; var keywordsPresent = findKeywordsInTitle(keywords, title); [[KEYWORD_PRESENT_LIST]] = keywordsPresent.join(', '); [[KEYWORD_PRESENT]] = keywordsPresent.length > 0; //true or false if ([[KEYWORD_PRESENT]]) { log("Keywords found - " + [[KEYWORD_PRESENT_LIST]]); }
  • D

    Devtools copy value

    Support
    0 Votes
    4 Posts
    526 Views
    D

    @Fox I've looked at all the threads but none of them are up to date. Do you have any current recommendations?

  • B

    Compare list 1 and 2 -> put missing elements in extra list (without foreach)

    Support
    0 Votes
    3 Posts
    814 Views
    B

    Works great for me:

    Array.prototype.diff = function(a) { return this.filter(function(i) {return a.indexOf(i) < 0;}); }; const dif = [[TABLE1]].diff([[TABLE2]]); [[DIF]] = (dif);
  • J

    List of BAS functions or API for node.js

    Support
    0 Votes
    2 Posts
    1126 Views
    FoxF

    @jimhill21 said in List of BAS functions or API for node.js:

    Hello,

    Where can I find a list of BAS functions or API calls for embedded node.js? I'm doing trial and error currently with the commands and parameters and it's not going well.

    Thanks,
    JIm

    You can simply copy the required BAS action directly into node js
    alt text

  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2257 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.