Bablosoft

strings comparing

Support

  • S

    Check if ANY word in an array is contained in a string?

    Support
    0 Votes
    2 Posts
    637 Views
    FoxF

    @spockthe40oz said in Check if ANY word in an array is contained in a string?:

    I have an array with data like "Bob, Amy, James" etc..

    I need a working IF statement to check if ANY of the words in an array are contained in a string, and also included partial matches. Meaning if a string = "hellobob123" it would still be true because it contains "bob"

    I'm still new to JS so not sure how I would go about this..

    Alternatively, I can use a text file instead of an array, but each word would be on a different line. I don't mind using this option either, but it needs to check every word in the text file (or array) for a partial match in [[VARIABLE]]

    Please help, thanks

    This can only be done by iterating through the elements, use the "foreach" action.

    9a03e839-795f-4b80-b172-19d8062817b2-изображение.png

    1792.xml

  • J

    Parse String Error Excel Module

    Support
    0 Votes
    4 Posts
    985 Views
    J

    @GhostZ Thank you so much for your reply and help. Yes, I read the instructions. I saved as a list and all that and still got errors because I didnt know to use First Element instead of a regular list.

    This clarifies everything!

    And i get that it's an index but I dont understand why when all actions would definitely utilize the row so it requires an extra step.

    But i know nothing lol

    Thanks!

  • H

    Can not click change string to expression in "set variable" function

    Support
    0 Votes
    4 Posts
    956 Views
    H

    @Fox You saved again my life!!!! thanks
    @DoctorKrolic thanks but can not give up the 23.2.2 yet ^^

  • H

    Search the whole of database table for a string

    Support
    0 Votes
    2 Posts
    719 Views
    FoxF

    @HELP_ME said in Search the whole of database table for a string:

    Hi, I have seen this https://community.bablosoft.com/topic/3750/how-to-avoid-duplicates-in-database/3
    and want to know if its possible to search the whole of the database table for a string.

    I have tried what the OP has tried, list functions such as get index and list contains aren't working as expected, it doesn't let you search the whole database for a string(it returns false / no result) nor select records by criteria.

    Use the filter in the "Select Records By Criteria" action
    a368082a-159a-418d-899e-adecf8b1887d-изображение.png

    892282f3-a72a-444a-aa5a-4b17b110f873-изображение.png

  • blahzayB

    random string - how to create my own 'tips'?

    Support
    0 Votes
    2 Posts
    1046 Views
    FoxF

    @blahzay said in random string - how to create my own 'tips'?:

    this is helpful but I would like to create my own 'tips', is it possible? Can I create tips from file?
    What I am trying to do is to create unique usernames with spintax.

    0_1550656076480_generate_lines.png

    Resources are set before running the script, and the spintax function is already used in the script.
    You can create a resource "string" and write your own "hints" in the description.