Forum Discussion
How to extract specific key value pair from a comma separated key values
Hi Manichin ,
You need to split twice.
1.Split the column by custom text: "WorkSpaceName":"
2.Remove [Column1.1]. Split the [Column1.2] by """ and split at left-most delimiter.
3.[Column1.2.1] is the wrokspace name, remove [Column1.2.2] and rename [Column1.2.1].
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Manichin ,
You need to split twice.
1.Split the column by custom text: "WorkSpaceName":"
2.Remove [Column1.1]. Split the [Column1.2] by """ and split at left-most delimiter.
3.[Column1.2.1] is the wrokspace name, remove [Column1.2.2] and rename [Column1.2.1].
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.