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:

Data Sharing

  1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...