ValueListToJSONArray(valueList; type) - 値一覧をJSON Array に変換

詳細
カテゴリ: FileMaker Custom Function
参照数: 1568

値の一覧を JSONArray に変換します。

FileMaker 18 以降対応

function(関数):
ValueListToJSONArray(valueList; type)
Sample input(入力例):
ValueListToJSONArray( List( ValueListToJSONArray("1¶2¶3¶¶5¶6"; JSONString); ValueListToJSONArray("1¶2¶3¶¶5¶6"; JSONString); ValueListToJSONArray("1¶2¶3¶¶5¶6"; JSONString); ); JSONRaw )
Sample output(出力例):
[["1","2","3","","5","6"],["1","2","3","","5","6"],["1","2","3","","5","6"]]
formula(式): 

// ValueListToJSONArray(valueList; type)
// valueList: 改行区切りの値一覧
// type: JSONSetElement のタイプ引数 (JSONString, JSONNumber, JSONObject, JSONArray, JSONBoolean, JSONNull, JSONRaw)
While(
  [
    ~i = 0;
    ~result="[]";
_=0];
  ~i < ValueCount(valueList);
  [
    value = GetValue(valueList; ~i + 1);
    ~result = JSONSetElement(~result; ~i; value; type);
    ~i = ~i + 1;
_=0];
  ~result
)