Bablosoft

how to parse list from database

Support
  • B

    I am taking my database to my list in browser automation Studio but I'm facing a problem that it also has the row ID which I don't want I want to parse it so that is removed how we can do with the normal string

    anyone any clue why this javascript is giving syntax error if? and also there is a proper documentary for the JavaScript that works with browser automation Studio please link it to me as well

    function removeLastColumnsFromList(inputList, columnsToRemove) {
  const outputList = inputList.map(inputString => {
    const parts = inputString.split(':');
    if (parts.length < columnsToRemove) {
      return inputString; // Return the original string if there are fewer columns than requested to remove.
    }
    
    return parts.slice(0, parts.length - columnsToRemove).join(':');
  });

  return outputList;
}

// Example usage:
const inputList = [
  "randomstring:randomstring:randomstring:randomstring:randomstring:randomstring:randomstring:randomstring",
  "example1:example2:example3:example4:example5:example6",
  "abc:def:ghi:jkl",
];
const columnsToRemove = 2;

const outputList = removeLastColumnsFromList(inputList, columnsToRemove);
var [[colist]] = outputList;
    0

  • P

    How to Use Database Accounts

    Support
    0 Votes
    20 Posts
    1384 Views
    P

    Is there not an already compiled script that someone has shared?

  • JARVISJ

    SyntaxError: Parse error during execution of action 222266208

    Support
    0 Votes
    3 Posts
    658 Views
    JARVISJ

    @Fox Thank you for replying.

    I only have one "Execute code" action

    Here is its contents.

    // Sample HTML content var htmlContent = [[SAVED_XML]]; // Regular expression pattern to extract email addresses var emailPattern = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/g; // Extract email addresses from HTML content var emails = htmlContent.match(emailPattern); // Map emails var data = emails.map(function(email) { return " /n " + email + " /n "; }); // Output the resulting email addresses // log(data); [[EMAILS]] = data;
  • G

    Parse new line to list?

    Support
    0 Votes
    4 Posts
    753 Views
    GaGG

    @gudolik said in Parse new line to list?:

    @GaG Thanks for the idea, but i will have like 50 variables, its bit hassle to save 50 files then read every one one by one, my idea was to parse them into list with command then merge them into 1 list and remove duplicates, i'm not clear with "OnAplicationStart" but will dig videos about it to understand it better

    According to your previous description I thought that you already have that
    variable with 50 or so lines, like on your picture. But if you obtain them 1 by 1
    than it is easy to put them in the list variable 1by 1. Just use "List" module - create
    new empty list firstly, than simply add elements with apropriate "Add list element"
    command. Usually you will be getting elements in some kind of the loop, so
    create empty list before that loop, and inside the loop you can add elements
    (variable - site address) to that new lycreated list variable which is outside the
    loop, so it will hold all elements as a list variable, so no need for any conversions.

  • S

    How to delete all items from the list

    Support
    0 Votes
    3 Posts
    638 Views
    GaGG

    You can use "Element Number" action to determine number of elements
    in existing list, and after that you can use action "Delete By Index" or
    "Remove Part".

  • AllisterA

    Interface Api.DatabaseUpdate --> Database Error

    Support
    1 Votes
    2 Posts
    1039 Views
    supportS

    @allister Hi, this is bug, it happens only if update column of int type. It was fixed, new version will be available in Thursday(8 November), if it is urgent for you, I can make a separate build.