Spark - Scala从数据帧中的列中删除开头和结尾的特殊字符

import org.apache.spark.sql.functions._

// 创建一个示例数据帧
val df = spark.createDataFrame(Seq(
  ("#Hello!", "$World"),
  ("@Spark", "%Scala"),
  ("*BigData*", "&Analytics")
)).toDF("col1", "col2")

// 使用regexp_replace函数删除特殊字符
val cleanedDF = df.withColumn("col1_cleaned", regexp_replace(col("col1"), "[^a-zA-Z0-9 ]", ""))
                  .withColumn("col2_cleaned", regexp_replace(col("col2"), "[^a-zA-Z0-9 ]", ""))

cleanedDF.show()