--- title: strings.containsStr() function description: > `strings.containsStr()` reports whether a string contains a specified substring. menu: flux_v0_ref: name: strings.containsStr parent: strings identifier: strings/containsStr weight: 101 --- `strings.containsStr()` reports whether a string contains a specified substring. ##### Function type signature ```js (substr: string, v: string) => bool ``` {{% caption %}} For more information, see [Function type signatures](/flux/v0/function-type-signatures/). {{% /caption %}} ## Parameters ### v ({{< req >}}) String value to search. ### substr ({{< req >}}) Substring value to search for. ## Examples ### Filter based on the presence of a substring in a column value ```js import "sampledata" import "strings" sampledata.string() |> filter(fn: (r) => strings.containsStr(v: r._value, substr: "5")) ``` {{< expand-wrapper >}} {{% expand "View example input and output" %}} #### Input data | _time | *tag | _value | | -------------------- | ---- | ----------- | | 2021-01-01T00:00:00Z | t1 | smpl_g9qczs | | 2021-01-01T00:00:10Z | t1 | smpl_0mgv9n | | 2021-01-01T00:00:20Z | t1 | smpl_phw664 | | 2021-01-01T00:00:30Z | t1 | smpl_guvzy4 | | 2021-01-01T00:00:40Z | t1 | smpl_5v3cce | | 2021-01-01T00:00:50Z | t1 | smpl_s9fmgy | | _time | *tag | _value | | -------------------- | ---- | ----------- | | 2021-01-01T00:00:00Z | t2 | smpl_b5eida | | 2021-01-01T00:00:10Z | t2 | smpl_eu4oxp | | 2021-01-01T00:00:20Z | t2 | smpl_5g7tz4 | | 2021-01-01T00:00:30Z | t2 | smpl_sox1ut | | 2021-01-01T00:00:40Z | t2 | smpl_wfm757 | | 2021-01-01T00:00:50Z | t2 | smpl_dtn2bv | #### Output data | _time | *tag | _value | | -------------------- | ---- | ----------- | | 2021-01-01T00:00:40Z | t1 | smpl_5v3cce | | _time | *tag | _value | | -------------------- | ---- | ----------- | | 2021-01-01T00:00:00Z | t2 | smpl_b5eida | | 2021-01-01T00:00:20Z | t2 | smpl_5g7tz4 | | 2021-01-01T00:00:40Z | t2 | smpl_wfm757 | {{% /expand %}} {{< /expand-wrapper >}}