Thanks Sukesh, Data-OLEDB is a easy approach but we have been restricted from using Data-OLEDB in production Env, Hence I am looping around Delete column action
Is there are way like instead of deleting single column at a time, deleting multiple column or
to get a single or desired number of columns from a collection..
Example : I have collection of 8 columns and I need only one column based on the header ?
BP_Collection_Out = BP_Collection_In...
If I give like that getting error like this :
Internal : Could not execute code stage because exception thrown by code stage: Unrecognized database format 'D:\BluePrism.xlsx'.
Getting this error now : Internal : Could not execute code stage because exception thrown by code stage: Not a valid file name.
please correct me if any thing wrong with syntax
Hi Sivagelli, I tried this and getting some other error related to authentication :
Internal : Could not execute code stage because exception thrown by code stage: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
In the OLEDB VBO -> Set Connection : there is a "Connection String" input parameter missing for me. What could be the issue ? should I get updated VBO ? Please help
I am also getting same issue, I have tried instruction provided @ https://social.msdn.microsoft.com/F...-registered-on-the-local-machine?forum=vstsdb ,
I have installed the AccessDatabaseEngine.exe but still getting same error. Please help
I am using Windows 7 64 bit, and office 2007
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
Thank you VJ it's working,
I have a text in the collection like :
2008 | Month | Address | Data | Name
So I need only the last value coming after the de limiter "|" symbol. What would be the best approach.. tried with split option but its gives column wise for each record in the collection....
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?
Yeap, its working... Could you please explain bit more on how did you framed this : "Name LIKE '*location*'" and any reference material to learn more on this kind.. Thanks ~VJ
Actually, I am deleting those files from an web app, I have already designed 2 actions which will select and delete those files based on value I pass on the value field, which I made dynamic when I spy that element in Application modular. Soo now I have to pass the value only if it contains...
I am getting a list of File names in an collection, And I want to delete the files, if its name contains location in it.. I have attached an moc data of the collection :
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..
Deleted all the unwanted code and added the "Exit For" as soon as the match is found... Now its working exactly as expected.. Thank you very much for your help...
This is how the code looks now :
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.