If OR statement not executing properly

I cannot get this one to execute, please help me execute this statement. Its not displaying AAAAA if it compares the string B3000.

Please Login or Register  to view this content.

Any help would be appreciated.

There is a comma in your string comparison "B3000:," hence it would not match to string "B3000" ? That could be the problem, otherwise, you should provide a more complete chunk of your code, there are 2 "If"'s right at the start of this snippet.

Show the part where you are setting the value to Audit ?

I feel that Audit contains whole data B3000:,B3001:,..... in this manner. So you need to split this into array and then check for the value.



________________________________________________________________________________________________
if something has helped please click

I have not failed. I've just found 10,000 ways that won't work.

Thomas A. Edison

Hi
Below is the audit code:

Please Login or Register  to view this content.

Thanks

So, let's say fldArray(UBound(fldArray)) contains only "B3000:,B3001:,",
InStr(Audit, ":") would return 6.

This line

Please Login or Register  to view this content.

would then translate into

Please Login or Register  to view this content.

which would be equals to "B3000". Hence comparison with "B3000:," would return a False

So how would we go about comparing it, cuz I get the output in a bulkfile(text file) and got to compare it before it writes to bulkfile.

Originally Posted by FDibbins

I suggest that you upload a dummy sample file, showing the data you are working with and what your expected answer would be. That way, members dont have to guess at what you are working with!
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I used Instr function to solve the above problem.