215
Hi
as I showing below text i want to remove underline text dynamically.
there is comma in the text i want to remove all the text before comma and comma itself also want to remove last ' " ' double quote. please help me with code
"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACZQAAAVWCAYAAAAAaa5JAAAMamlDQ1BJQ0MgUHJvZmlsZQAASImVVwdUU8kanluSkJDQAhGQEnoTRHqREkKLICBVsBGSQEKJMSGo2FBZVHDtIooVK6Lo6grIoiL2sij2vlhQUdbFgqKovEkBXfeV8/5z5s6Xb/75W2bun"
You could use the following code:
With(
{textValue: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACZQAAAVWCAYAAAAAaa5JAAAMamlDQ1BJQ0MgUHJvZmlsZQAASImVVwdUU8kanluSkJDQAhGQEnoTRHqREkKLICBVsBGSQEKJMSGo2FBZVHDtIooVK6Lo6grIoiL2sij2vlhQUdbFgqKovEkBXfeV8/5z5s6Xb/75W2bun"
},
Last(
Split(Left(textValue, Len(textValue) - 1), ",")
).Result
)
//I added in the 'With' code to make a temporary variable so that the rest of the code could be shorter, but that is just a preference. The rest splits the textValue by the character listed in quotes (the comma), then takes the last part and only shows that. I also put in code to take all of textValue except the last digit (the Left code).
Share
Report
All responses (
Answers (
