Breaking News: Grepper is joining You.com. Read the official announcement!

pyspark find string position

Cristian Agudelo answered on July 27, 2022 Popularity 2/10 Helpfulness 1/10

answer pyspark find string position

pyspark find string position

Comment

import pyspark.sql.functions as F

df2 = df.withColumn('position', F.expr('locate(subtext, text) - 1'))

df2.show(truncate=False)
+-------------------------+-------+--------+
|text                     |subtext|position|
+-------------------------+-------+--------+
|Where is my string?      |is     |6       |
|Hm, this one is different|on     |9       |
+-------------------------+-------+--------+

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: find position pyspark string whatever

Link to this answer
Share Copy Link