Reading from excel as strings vlook up

Lists-Logic
41

Do you have an email I can send the project too? it is too big to upload.
Here is what you will see and need to do in the 3D view. BTW it is the same thing that you will need for the other post you are working on. Same exact family.

image
image.png1267×623 63.5 KB

42

It’s likely too big to email as well. Can you post it to Google Drive or another file sharing service?

43

I can wetransfer it using your email. then you can download it from them.

44

It’s failing because you’re looking for an exact match, which doesn’t exist in that column. That’s why I said to use String.Contains.

Edit:
Changing your codeblock line from
DestinationEXCEL==Destination;
to
String.Contains(DestinationEXCEL<1L>,Destination<1L>,false);
will return the correct number of “matches”.

2 Likes
45

Jackpot! can you explain what’s going on in that code please? What does the <> mean and the 1L and the false?

46

It’s the same inputs as the String.Contains node (str, searchFor, ignoreCase), so the false is telling it not to ignore the string case. The <1L> notation is the DesignScipt syntax for list levels. So the codeblock is running as though the node was set to use list levels @L1.

1 Like