I am trying to recode column titles using regex to go from:
Mean(260-321-ACR-003.SI.PV, 0_113) to 0_113),Mean(260-321-ACR-003.SI.PVhowever I am getting $2$1 as a response
The steps I did are:
Recode- Column Names --> Red Tri --> Replace string
Search text: [^,]+
Use regular expression: checked mark
Replacement text: $2$1
Shouldn't the $2$1 refer to the first and second segments of the title?
------------------------------------------------------------
Here's an example of what I am getting instead:
Current Value Replacement Value
Jour $2$1
N Rows $2$1
Mean(260-321-ACR-003.SI.PV, 0_113) $2$1,$2$1
Mean(260-321-ACR-003.SI.PV, 0_118) $2$1,$2$1
Mean(260-321-ACR-003.SI.PV, 85_108) $2$1,$2$1
------------------------------------------------------------
Thank you!
