15.9 Parse and extract Key-Value pair
Data 1:
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:
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:
Data 2:
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:
Data 3:
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:
esProc Desktop and Excel Processing
15.8 Take out words
16.1 Count date by year and month
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/