Parse info found between the third quotation marks: {"id"=>abcd, "value"=>"efgh"}

BusinessApplications

Hello guys,

Can you help me extract the info found between the third quotation marks from this?

{"id"=>abcd, "value"=>"efgh"}

The id can have either 3 or 4 characters and the info in the last quotation marks can have a different number of characters as well. I need to extract efgh.

Do you have any ideas?

Thank you!

DKazatsky2

Hi @BusinessApplications,

Give this a try.

=SUBSTITUTE(RIGHT([ColumnName]@row, (LEN(([ColumnName]@row)) - FIND(",", [ColumnName]@row) - 11)), "\"}", "")

Hope this helps,

Dave

BusinessApplications

I found the right answer in case anyone will need it:

=LEFT(RIGHT(Account@row, LEN(Account@row) - FIND("=>", Account@row, 10) - 2), LEN(RIGHT(Account@row, LEN(Account@row) - FIND("=>", Account@row, 10) - 2)) - 2)