Closed saikoneru1997 closed 1 day ago
df.select('').withColumn('new_column1',regexp_extract(df.input_string,'(^[a-zA-Z][0-9])',1)).withColumn('new_column2',regexp_extract(df.input_string,'(^[a-zA-Z][0-9])([a-zA-Z][0-9]*$)',2)).show()
df.select('').withColumn('new_column1',regexp_extract(df.input_string,'(^[a-zA-Z][0-9])',1)).withColumn('new_column2',regexp_extract(df.input_string,'(^[a-zA-Z][0-9])([a-zA-Z][0-9]*$)',2)).show()