Hello carina0101,
As there is
need to compare file name with content of file (2nd line), first we need to
maintain file name in a separate variable. Either you hardcode it in a variable
(if its constant file name), else you use the “Get File Name” activity to
dynamically fetch the file name during bot execution and store it in a variable
(say VarFileName)
Once you have
stored the file name and also get the output of file text, you use a For Each
loop to browse through each row of the file and save the output in a list.
From that
point onwards, use For Each activity to call out each item from the list (row in
your file) and carry out the validations (can club one or more of below in For Each activity as much possible to make it more efficient, however I suggest you start simple with having one For Each for each task below)
Ex.
- call 2nd
item and pick first 5 chars using custom script and compare if its equal
to G3040
- call
2nd item and pick 6th to 8th char using custom script, also obtain file
name from VarFileName – collect 7th to 9th chars and compare both values
if matching
- pass
each item in a for each loop and set flag to a variable on how many items begin
with D000,
- another
for each loop to pass the D000 rows to count number of chars in the line
if equal to 52,
- another
for each loop to pass the D000 rows to identify if char 45 to 48 is equal
to 2022
PS: There will
be a bit of custom code required only for some string operations like - to pick
specific characters of the each item/row (like first 5 chars of line 2, first 4
chars of line 3 onwards, char number 6th to 8th to compare with file name and
so on). These can be achieved by using very useful and simple JavaScript string
methods detailed here
Hope this
outline helps setup your automation use case.
Regards,
Vishal Rathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.