Recent content by YGC

  1. Y

    Extract values as collection from text that has lines and spaces

    Hi gil.Silva, Amazing, that's going to solve my problem, thank you very much really. In some cases (for example line 3 of the values in the exported text, only the last 2 columns have values., being the others in blank. I don't think regex values can achieve this is there anyway to extract...
  2. Y

    Extract values as collection from text that has lines and spaces

    Hi everyone, I've been trying for a several time to extract specific values from a text file and put in into a collection, so i can work with the data. Next i show how is my text file is received: -This text has always de same structure. -I don't need the header at the begging of each page...
  3. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    Hi, there was a filter already applied on the sheet. Tried it with a new sheet and works perfectly fine. Thank you very much for your help! It was very useful.
  4. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    Hi, with one or two Autofilter lines i get the same error "Autofilter method of range class failed" . Can't figure out the reason...
  5. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    Still getting the same message error "Autofilter method of range class failed" with exactly the same code i posted before. The header is ok, is the first row in the Excel. Could be the reason the Excel version? Otherwise i don'´t know why it works fine for you.
  6. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    Thank you very much for the attention, I've been making the necesarry changes that you have mentioned . But i get an error message in the output data item which says : "Autofilter method of Range Class Failed". I tried to pass an specific range such ass (D10:D200000), but still does not work...
  7. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    Hi sivagelli, thanks for your quick response the excel sheet contains about 200.000 rows, in consequence i get an SystemOutofMemory error. to Apply a filter and the passing it to a collection could work too but since for my needs no additional transformation in the excel is needed, only the...
  8. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    I have an Excel workbook where is needed to remove all rows wherever appears a 0 value in a certain column before adding it into a collection (see attached picture as an example: When column D contains 0 value, that row must be deleted). I tried these actions with MS EXCEL VBO 1.Get Cell value...
  9. Y

    How to convert Excel to csv

    Hi VJ, That was! , I don't know how I couldn't see it earlier. You were right about the cell formatting in Column N. Now i have the csv file without the last comma. Thank you very much for your quick response and everything I appreciated it a lot. -YG.
  10. Y

    How to convert Excel to csv

    Hi VJR, The original excel look like in the picture attached here. I can't perceive anything unusual. Do you? Could be the extra column? -YG
  11. Y

    How to convert Excel to csv

    Hi VJR, your solution works perfectly fine. The only thing, when I transform my excel to xlCSV format (as I show in next picture). The last line ends with a comma. Is there anyway to avoid the last comma? or remove it using blueprism but without importing the excel file as a collection and...
  12. Y

    Solved Procedute to take a Print screen & Store in Data Item Using Blue Prism

    Hi, VJ Thank you very much ! it worked. It was my mistake, i wasn't providing any value for the Folder path input
  13. Y

    Solved Procedute to take a Print screen & Store in Data Item Using Blue Prism

    Hi Raimundasv, I get the same error "A generic error occurred in GDI+.", but i cannot see the problem with the action stage and path... Maybe mine is different, but.. could you please illuminate me? Thank you very much, y
Top