import org.apache.spark.sql.functions._
val testString = " I am X. X Works for Y."
val testDF = Seq (testString).toDF
val testDF1 = testDF.withColumn("new", explode(split($"value".cast("String"), "\\s+"))).withColumn("value" ,regexp_replace(col("new"), "[.]*", "")).drop("new")