Way to Get Rid of or Split by Quotation Marks

Questions and Help
1

Hello TB Community,

I am dealing with some data from an API pull - is there some way to replace or split by quotation marks ""? I am able to split the data down to what I need without involving quotation marks, but then I am eventually left with data that looks like this: "3314 W 86th St" "Cleveland, OH 44102"

So yeah- just wondering if there is a way to somehow get rid of the quotation marks, Thank you :slight_smile:

Sample Data:
["comps": [["bathrooms": 2, "newConstructionType": "", "lotAreaUnits": "Square Feet", "formattedChip": ["location": [["fullValue": "3314 W 86th St"], ["fullValue": "Cleveland, OH 44102"]]], "isPremierBuilder": no, "isShowcaseListing": "", "hdpUrl": "/homedetails/3314-W-86th-St-Cleveland-OH-44102/33358489_zpid/", "lotAreaValue": 4586.868, "parentRegion": ["name": "West Boulevard"], "address": ["city": "Cleveland", "state": "OH", "streetAddress": "3314 W 86th St", "zipcode": "44102"], "state": "OH

2

Hi @ajduna7,

You can split or replace on a quotation mark by escaping it as follows. Let me know if it works for your use case.

Address: {formparagraph: name=address; default=3314 W 86th St" "Cleveland, OH 44102}

Cleaned address: {=replace(address, "\"", "")}

2 Likes
3

This worked perfectly-- Thank you Ashwin!!

1 Like