Tuesday, 20 December 2022

Pentaho - JavaScript to find string position & find substring

var text = Field_000;

var start_pos = text.indexOf(" W=");

var end_pos = text.indexOf(", U=");

var out_record_count = text.substring(start_pos+3, end_pos);

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...