I am trying to write a script that converts any occurrence where a number is within the text "saturated ()", to remove the saturated (), leaving only the number. I thought I could edit a recode script, but had no success. Thank you in advance.
Names Default To Here( 1 );
dt = Data Table( "Book1_Sheet1" );
dt << Begin Data Update;
dt << Recode Column(
dt:Area,
{Map Value(
_rcOrig,
{"saturated( ######### )", "#########"},
Unmatched( _rcNow )
)},
Update Properties( 1 ),
Target Column( :Area )
);
dt << End Data Update;