Extract data

[marusla]

Hello i have this text, someone could help me to extract data from this column: datos=%7B%22fecha%22%3A%2220250620110916%22%2C%22fechaFinal%22%3A%2220250620%22%2C%22data%22%3A%22056%22%2C%22secuencia%22%3A%22150222%22%2C%22 try to use parse like this LD "%22%3A%22" ld :fecha ld "%22%2C%22 but dont show me data

[marco_irmer · Accepted solution]

Your field value appears to be URL encoded. I ran it through the decodeURL() function and discovered that it appears to be JSON format (although your snippet is not complete).

If it's a fully formed JSON, then you might be able to use the DPL parser for JSON after the decodeURL() function.

[marusla]

Thank you!!!!