Hello,
I’m new to AWS Quicksight. I created a dataset based on an imported file (from another cloud service provider). The dataset includes a “tags” field, which is a comma delimited string. Within that dataset, I’m trying to create a calculated field to extract the “costcenter” value from this “tags” field. I’ve tried multiple string functions (including substring and locate), and thus far haven’t been successful. I’d appreciate any ideas on how I can extract the “costcenter” value into its own field. Is this even possible? For each record, the position of the “costcenter” key/value pair (within the “tags” field) isn’t always consistent, nor is the value’s length.
Here are a few sample values from this “tags” field:
Value/Record 1: “costcenter”: “123456789”,“description”: “Test environment”,“workload”:“core”
Value/Record 2: “description”: “test environment”,“costcenter”: “22222”,“maintenance”:“none”
Value/Record 3: “maintenance”: “none”,“description”: “dev environment”,“costCenter”: “444444”
Thanks in advance!!