Hello…
I have an excel file, from which I need to transfer a certain part of the data to a new sheet.
that data begins with the line containing “HOST:BANK” and ends with “Napomena: Po prijemu kartica blagajnik je obavezan poslati potpisan dnevnik”
I leave you an example of the file below.
does anyone know how this could be done?
20230725 - MC Debit.xlsx (25.4 KB)
Hi @dvojinovic,
Try reading the excel file and store it in a data table.
Convert the datatable to string using output data table activity.
Do string manipulation to get the from and to line desired
Convert the string to datatable
Use write range to write the data table to the desired sheet.
Please note that you will have to do this string manipulation for all the instances of the from and to the string value and remove that from the original string once the first instance is written.
Cheers