Creating Regular expressions

Question

I have some google sheet code I put into an HTML doc.

I want to remove the sheets code but have no clue how(and i did research it, just don't understand it, must be getting old)

The code has lines that are in this format

<td data-sheets-value="{" 1":2,"2":"briar="" rose"}"="">Briar Rose</td>

<td data-sheets-value="{" 1":2,"2":"jane="" yolan"}"="">Jane Yolan</td>

I want to search and replace all the code from the word data sheet to the > bracket...so that the lines read

<td>Briar Rose</td>

<td>Jane Yolan</td>

Hoping someone can help me learn how.

Thanks.

Jon Fritz · Accepted Answer

I'm guessing the actual code has correct single and double quote nesting. If so, you can clean out the attributes pretty easily (DW will have problems if there are code errors in the attribute quote structure though)...

1. Open the Find & Replace Tool (Ctrl + Shift + F in CC2017.1 or Ctrl + F in older versions)
2. Click the Advanced tab
3. Choose Find In "Current Document" and set the dropdown to "td"
4. For the next line, set the 4 drop down menus to...
"With Attribute"
"data-sheets-value"
"="
"[any value]"

5. For the Action, set "Remove Attribute" "data-sheets-value"
6. Hit Replace All

If it works correctly, you can then change the Current Document in step 1 to Entire Current Local Site...

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded