The written text is more than one line in the cell

Hello all :slight_smile:

I am facing a issue that consists on that when robot writes info that reads from several PDFs using regex, the written text (it is an IBAN account) is more than one line in the cell. Then, if I want to merge this table with another data base, the robot does not match the info because there is more than one line in the cell.

How can I solve this issue?

Many thanks!
Angel

Hi @Angel_Llull

Did u need the information to be written in each cell one by one ?

Hi @NIVED_NAMBIAR ,

Yes, one by one. But I think I have found “the solution”. Each IBAN has 24 digits, and the ones the robot did not match had 25, so I have used substring(0,24).

1 Like