topic Re: How do I write a script to recode to remove partial text? in Discussions

How do I write a script to recode to remove partial text?

KRT — Fri, 09 Jun 2023 19:52:05 GMT

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;

Re: How do I write a script to recode to remove partial text?

DonMcCormack — Fri, 09 Jul 2021 20:52:55 GMT

Try this. I tried to write the regular expression to recognize any correctly formatted number and ignore blanks or incorrectly formatted numbers.

Names Default To Here( 1 );
dt = Data Table( "Book1_Sheet1" );
dt << Begin Data Update;
dt << Recode Column(
	dt:Area,
	{Regex(
		_rcNow,
		"^saturated\((\-*)([\d\.]+)([eE]*)(\-*)(\d*)\)",
		"\1\2\3\4\5",
		GLOBALREPLACE
	)},
	Update Properties( 1 ),
	Target Column( :Area )
);
dt << End Data Update;

Re: How do I write a script to recode to remove partial text?

txnelson — Fri, 09 Jul 2021 20:58:18 GMT

Here is one way to change the values

Names Default To Here( 1 );
dt = Data Table( "Book1_Sheet1" );

For Each Row(
	If( Left( :Area, 10 ) == "saturated(",
		:Area == Word( 2, :Area, "()" )
	)
);