I have a process (attached) to read through the files in a folder (sample file attached) and build up a table based on the contents.
In the process there is a condition to check the name and record the name or not in the table based on a particular name. I can not make the condition to work. All the files are picked up and the condition does not work.
At the moment I have the condition as left(From,6) <> “Sammie”, but I tried all sort of ways. It looks like there is some hidden characters that are are preventing for the condition to be true.
Any ideas on how to make the condition to be true? What am I doing wrong?