Recent content by Rita Reis Cabrita

Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...

Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...

Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...

Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...

Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...

Hello Community, Hope you're fine! Just started to learn applying OLE DB in BP... I've studied online how to configure queries and I think that I'm understanding it well. However, this is not working and BP answers with this error: "Internal: Could not execute code stage because exception...

Hello Community, Hope you're fine! Just started to learn applying OLE DB in BP... I've studied online how to configure queries and I think that I'm understanding it well. However, this is not working and BP answers with this error: "Internal: Could not execute code stage because exception...

Hello Community, Hope you're fine! Just started to learn applying OLE DB in BP... I've studied online how to configure queries and I think that I'm understanding it well. However, this is not working and BP answers with this error: "Internal: Could not execute code stage because exception...

Hello Community, Hope you're fine! Just started to learn applying OLE DB in BP... I've studied online how to configure queries and I think that I'm understanding it well. However, this is not working and BP answers with this error: "Internal: Could not execute code stage because exception...

Hi everyone! Hope that you guys can help me. I have a file (with file type: 'file') that can be opened manually to Notepad. I want to extract that file information to a collection and text mining it. I tried to import it with CSV with MS VBO Excel and it split the data at ' , ' and I want it to...

Hi everyone! Hope that you guys can help me. I have a file (with file type: 'file') that can be opened manually to Notepad. I want to extract that file information to a collection and text mining it. I tried to import it with CSV with MS VBO Excel and it split the data at ' , ' and I want it to...

Thanks a lot for you help!!

Hello everyone! Does anyone know how to tell BP to go to a colored cell in Excel? Imagine it is in Col C and I want the robot to go down until it finds a colored cell. Is this possible? Tks, Rita