Creating a string into a boolean to use for a condition

Help Activities
, , ,
1

I am currently navigating and iterating through a dataTable (in_CurrentForms) of forms I’ve created from scraping a pdf
Information Looks like this:
image

Form Titles are blurred out due to privacy.

I created an Assign one called testPrefix which for an example would grab CCP of the first form. The second assign I created is called testPrefixNext which in this example would be CIL

image
image733×303 5.82 KB

Once the iteration ends it loops through each of these and hits this error
image

Is there a way to turn testPrefixNext into some sort of boolean condition, where if it’s present continue the normal process of scraping or if it doesn’t exist in this case where it says There is no row at the position, I can end the process?

Thanks!

1 Like
2

Hey @ajeffers,

Try this as condition please.

in_CurrentForms.rows(currentRow + 1) is not Nothing

Thanks :slight_smile:

3

Could I put in_CurrentForms.rows(currentRow +1) is Nothing and this would simply state that there is no value?

1 Like
4

image

1 Like
5

Apologies, I left a space by mistake. PFB

in_CurrentForms.rows(currentRow + 1) isNot Nothing

1 Like
6

Attempting this now! I will let you know if it works!

1 Like