Regex R Script - How to output results into new column?

[latimert]

Hello,

I have the following RegEx that I'm trying to output into a new column.

RegEx: (QLD|NSW|ACT|VIC|TAS|NT|SA|WA) *([0-9]{2,3})

The column I'm targetting is a text column called SHOP_NAME and I want to output the results to a new column called "STATE_SHOP"

I've been unable to find answers on how to write the R script to achieve this.

[lbendlin]

R scripts expect a data frame as input (ie a table) and they produce another table as output.

Consume the table from the prior step, add your regex column, and then use the resulting table in the rest of your Power Query script.