How to escape % in String.Format?

JavaAndroidStringSyntax

Java Problem Overview

I am storing a SQL query in my strings.xml file and I want to use String.Format to build the final string in code. The SELECT statement uses a like, something like this:

SELECT Field1, Field2 FROM mytable WHERE Field1 LIKE '%something%'

In order to format that I replace 'something' with %1$s so it becomes:

SELECT Field1, Field2 FROM mytable WHERE Field1 LIKE \'%%1$s%\'

I escape the single quotes with the backslash. However I am not able to escape the % sign.

How can I include a like statement in my strings.xml file?

Java Solutions

Solution 1 - Java

To escape %, you will need to double it up: %%.

Solution 2 - Java

To complement the previous stated solution, use:

str = str.replace("%", "%%");

Solution 3 - Java

This is a stronger regex replace that won't replace %% that are already doubled in the input.

str = str.replaceAll("(?:[^%]|\\A)%(?:[^%]|\\z)", "%%");
Categories
Recommended Java Solutions
Recommended Android Solutions
Recommended String Solutions
Recommended Syntax Solutions

Previous Solution:

Typedef function pointer?

C++CPointersTypedef

Next Solution:

Select elements by attribute in CSS

CssHtmlCss SelectorsCustom Data-Attribute

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionMatthewView Question on Stackoverflow
Solution 1 - JavalimcView Answer on Stackoverflow
Solution 2 - JavaCavaleiroView Answer on Stackoverflow
Solution 3 - JavaToilalView Answer on Stackoverflow