How to convert into an array of string into Key/Value format?

Question

Hello All, 
 
 Can someone please tell how we can make Key/Value from an array of string? I have an array lets say "arr1" containing the below value 
 
 arr1[1] Name:XYZ 
 arr2[2] Age:23, etc 
 
 Here Name and age is not declared as a variable, They act as string only. I want to make Name and Age as variables with respect to their stored values as "XYZ" and "23". So that I can easily call the values by calling Name or Age.

jayakumars · Accepted Answer

Hello Vivek, 
 
See below code, it may help you develop a more robust solution. I've quickly thrown together some code which will create a list of list of strings, which should a be a list of key/value pairs where the keys can be dynamic. Please note you may want to do some additional string cleaning, as the last value has the '>' character still in it. 
 
load( 
 local!data: "<a title='Welcome to appian' href:'https://../../Name=XYZ/Age=23/Profession=Student>", 
 local!subdata: keyval( 
 local!data, 
 "=", 
 "/" 
 ), 
 local!splitdata: split( 
 local!subdata, 
 "/" 
 ), 
 local!cleanSplitData: filter( 
 search( 
 "=", 
 _, 
 1 
 ), 
 local!splitdata 
 ), 
 /*If '=' is not found, search returns 0, which converts to false, and so those strings are removed from list*/ 
 local!groupedData: apply( 
 split( 
 _, 
 "=" 
 ), 
 local!cleanSplitData 
 ), 
 local!groupedData/*indexing this list will give you a pair, where [1] is the key, and [2] is the value*/ 
 
)

Ravi Roshan · Answer

Please check the below code: 
 
load( 
 local!str: "Name:xyz/age:30/profession:Student", 
 local!concatedStr: concat(local!str,"/"), 
 local!name: extract(local!concatedStr, "Name:", "/"), 
 local!age: extract(local!concatedStr, "age:", "/"), 
 local!profession : extract(local!concatedStr, "profession:", "/"), 
 local!array: { 
 Name: local!name, 
 Age: local!age, 
 Profession: local!profession 
 }, 
 local!array 
)