I have a python script in my desktop, and I need to execute and pass some parameters for the script.. How to achieve this.. How do I approach this.. Please help
Hi I need some help on below scenario:
I need to paste the following formula to an excel but it not considered as text
=RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,"|","#",LEN(A1)-LEN(SUBSTITUTE(A1,"|","")))))
What is the escape character in BP?
For example : I am looking for a particular text in an collection, Collection of item gets populated from an application, sometimes I am getting like :
1. Location 2. LOCATION 3. location
And also please suggest what is the alternate function for "contains" like in any other language..
Hi, I have a scenario where I wanted to know the position of my data in the collection. For an example : my collection contains 15 records, and I wanted to know to positions of 3 records.. I managed to resolve it with 3 loops breaking with exception as and when I found my match case and jumping...
As an initial approach, I have read the notepad line by line using (Utility file management -> Read Lines from File), then loop over the lines and Mid function to splite and get the required value and stored in an collection. This is working fine.. but wanted to know the best and possible...
I want to segregate the excel file based on location, where number of location is not fixed,
My Initial approach was
1. Get the excel input as collection and found unique location in an separate collection and
2. Applied filter collection and wrote the output into separate excel files.
But...
I have used get files from utility file management vbo and got few files into collection, now I want to send those files as an attachment, how to achieve
Within a loop, I want to use filter collection, for every iteration I need to change the filter criteria, please suggest how to achieve this
I have tried all the below combination but its not working :
Collection In [ExcelData]
Filter "Location = 'India'" : its working fine
Collection...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.