colRegex | teradatamlspk | pyspark2teradataml - colRegex - Teradata Vantage

For the colRegex function, PySpark returns result based on Scala or Java regex; teradatamlspk returns based on Python RegEx.

The following two examples show that the return are different in PySpark and teradatamlspk.

PySpark

df.select(df.colRegex("`(Col.)`")).show()

+----+----+
|Col1|Col2|
+----+----+
|   a|   1|
|   b|   2|
|   c|   3|
+----+----+

teradatamlspk

>>> df.select(df.colRegex("(Col.)")).show()

+----+----+
|Col1|Col2|
+----+----+
|   c|   3|
|   b|   2|
|   a|   1|
+----+----+