Cats Slave: 2015

2015年11月25日星期三

ReNamer, Script for delete BEFORE or AFTER specific strings

Some PascalScripts for ReNamer

This Script search and delete filename AFTER the specific strings, include itself.

{ This script cut filename by string - }
const
SEARCH_STRING = 'specific strings here';
var
BaseName: WideString; Length, Position: Integer;
begin
BaseName := WideExtractBaseName(FileName);
Length := WideLength(BaseName);
Position := WidePos(SEARCH_STRING, BaseName);
WideDelete(BaseName, Position-1, Length-Position+2);
FileName := BaseName + WideExtractFileExt(FileName);
end.

This Script opposite to Search and delete filename BEFORE the specific strings, include itself too.

Custom Functions Unique()

Original Function Unique() returns each columns's unique rows in the provided source range.

This script return unique data in provided source range (in each cells) . Rows are returned and sorted.

var cache = CacheService.getUserCache();
function uniqueEach(input) {
cache.put("unique", input); // drop input data into cache
var input = cache.get("unique").toString().split(",").sort(); // receive input as 1D array and sort it
var result = new Array();
var cell = input[0]; // give initial value to avoid error
result.push(cell);
for (i in input) {
if (cell != input[i]) {
cell = input[i];
result.push(cell);
}
}
return result;
}

Use CacheService to get a simple and fast bunch of data.

And sort make data processing more easy.

Cache Service in Apps Script

Cache Service allows a script to temporarily cache results.

But puts values like Array into Cache, when you take it out will become a String.

Example :

#00	#01	#02
#10	#11	#12

Put array into cache when get will return a string.

#00,#01,#02,#10,#11,#12

So we can use Split string, return result to a array object.

#00

#01

#02

#10

#11

#12

var cache = CacheService.getUserCache();
function putCache(key, array) {
cache.put(key, array);
}
function getCache(key) {
var result = cache.get(key).toString().split(",");
return result;
}

2015年9月27日星期日

QGIS : Merge two layers using Raster calculator include NoData values 合併圖層

Press Ctrl+Alt+M open commander

Open Processing algorithm: Raster calculator

QGIS 2.10.x

Main input layer

Select first input layer ( as variable a, DEM, sea level == NoData )

Sea = white area

2015年9月25日星期五

ImageMagick : Image split in two halves 左右分割

convert [path][filename.extension] [-options] -crop 2x1@ -set filename:tile "%t_%[fx:not(page.x)]" "[path]%[filename:tile].[extension]"

Split file into two images for right [filename_0] and left [filename_1].

Example :

convert image.png -crop 2x1@ -set filename:tile "%t_%[fx:not(page.x)]" "%[filename:tile].png"

Result : Right side image_0.png and left side image_1.png