15.9 Parse and extract Key-Value pair

 

Data 1:

imagepng

Script 1-1:

=spl("=?1.property()",A1)

The function property is used to read the attribute value from a KV string. When there is no parameter, it means to return all attributes to form a table sequence.
Result 1-1:

imagepng

Script 1-2:

=spl("=?1.property@v(""A"")",A1)

The function property is used to read the attribute value of A from a KV string. @v means that it will be parsed into a value after reading it out.
Result 1-2:

imagepng

Data 2:

imagepng

Script 2:

=spl("=?1.property@vcj()",A1)

The function property is used to read the attribute value from a KV string. When there is no parameter, it means to return all attributes to form a table sequence. @v means that the string is read first and then parsed into the value; the option @c means that the sectioned strings are separated by a comma or semicolon.

Result 2:

imagepng

Data 3:

imagepng

Script 3:

=spl("=replace(replace(?1,""{"",""""),""}"",""="").property@vc()",A1)

Change the format of KV string to K=V.
The function property is used to read the attribute value from a KV string. When there is no parameter, it means to return all attributes to form a table sequence. @v means that the string is read first and then parsed into the value; the option @j means that the name and value of byte strings are separated by comma or semicolon.

Result 3:

imagepng


esProc Desktop and Excel Processing
15.8 Take out words
16.1 Count date by year and month