I'm really struggling with the string functions in FME at the moment. I have a workbench reading JSON features from an API and I have one attribute where the results are in a list. The JSON extractor results the attributes like this:
["Medium"]
Or if there are multiple values, like so:
["Easy","Advanced"]
I want the results to be:
Medium
Intermediate,Easy
I want to remove the brackets and quotes using a single transformer and can't figure out the formatting for my life! Currently I have 3 separate "string replacers", each one removing a single character, but there must be a better way...I don't mind using a REGEX expression if someone can figure it out. I'm also open to using a different type of JSON query to extract these values? If there's a way to get the attributes without the brackets and quotes?
I also tried using the string pair replacer but I constantly get an error, and I can't seem to format it properly. I wish you could enter the pairs in table format instead of one long string for replacements...would make it so much easier to figure out!
Any advice would be appreciated 🙂
