Forum Discussion

latimert's avatar
latimert
Regular Visitor
3 years ago

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

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.

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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.