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?
String.format() you might consider using MessageFormat() instead.
To escape %, you will need to double it up: %%.
To complement the previous stated solution, use:
str = str.replace("%", "%%");
This is a stronger regex replace that won't replace %% that are already doubled in the input.
str = str.replaceAll("(?:[^%]|\\A)%(?:[^%]|\\z)", "%%");
Follow WeChat
Success story sharing
Want to stay one step ahead of the latest teleworks?
Subscribe Now相似问题
- How do I read / convert an InputStream into a String in Java?
- How do I make the first letter of a string uppercase in JavaScript?
- How to replace all occurrences of a string in JavaScript
- How to escape single quotes within single quoted strings
- How do I break a string in YAML over multiple lines?
- How to concatenate string variables in Bash
- How do I convert a String to an int in Java?
