Hi IRPA Team
We need to read a txt file and get some values and then validate them. It seems to me that there aren´t SDK activities for this type of file, so I thought I'd make a custom script... but I don't know how to continue it... Is there any other way to do it?
As can you see in the print screen attached txt-file-analize.png, we need:
(1) Get the value of the 2nd line and validate that it´s equal to G3040..
(2) Get the value of the 2nd line and validate that it´s equal to a part of the file name.
(3) Get the total number of columns (or characters) for each line starting with D000...and verify that the total number of columns is equal to 52
(4) For each line starting with D000..verify that the column from 45 to 48 it´s equal to 2022.
Could you help me?