Text search in excel file

[GHK151112112]

I saved the Revit Duct Pressure Drop file as excel file and want to extract Critical path string from it.

Is there a way to seacrh for “critical” and return the index number contains "critical"
I tried String.IndexOf, Contains, ContainsKey, List.ContainsItem but none works.

[Einar_Raknes]

A screenshot from your trials would help us understand your problem better. Have you tried this?`

or this:

[Einar_Raknes]

Try to change the lacing to longest. Read about lacing here: http://dynamoprimer.com/06_Designing-with-Lists/6-1_whats-a-list.html

[GHK151112112]

[Konrad_K_Sobon]

try String.Contains

[GHK151112112]

Thanks a lot. It seems it worked but it says “operation failed” !?

[Konrad_K_Sobon]

well its all these nulls you got in that list. just replace them with something else before passing it into the string node.

[GHK151112112]

Done ! Thanks.