pyspark.sql.functions.instr¶

pyspark.sql.functions.instr(str: ColumnOrName, substr: str) → pyspark.sql.column.Column¶

Locate the position of the first occurrence of substr column in the given string. Returns null if either of the arguments are null.

Notes

The position is not zero based, but 1 based index. Returns 0 if substr could not be found in str.

>>> df = spark.createDataFrame([('abcd',)], ['s',])
>>> df.select(instr(df.s, 'b').alias('s')).collect()
[Row(s=2)]

pyspark.sql.functions.initcap

pyspark.sql.functions.length