Want to replace WhiteSpace from array of String

Question

private static final String SQL_INSERT = "INSERT INTO ${table}(${keys}) VALUES(${values})";
private static final String SQL_CREATE = "CREATE TABLE ${table}(${keys} VARCHAR(20) NOT NULL)";
private static final String TABLE_REGEX = "\\$\\{table\\}";
private static final String KEYS_REGEX = "\\$\\{keys\\}";
private static final String VALUES_REGEX = "\\$\\{values\\}";

String[] headerRow = csvReader.readNext();//getting(Machine Name , Value)
String[] stripedHeaderRow = StringUtils.stripAll(headerRow);

String query2 = SQL_CREATE.replaceFirst(TABLE_REGEX, tableName);
query2 = query2.replaceFirst(KEYS_REGEX, StringUtils.join(headerRow, " VARCHAR(20) NOT NULL,"));

Result:

"Machine Name, Value"

Expected result:

"MachineName , Value"

Do you expect `stripAll()` to remove those spaces? The [documentation](https://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringUtils.html#stripAll-java.lang.String...-) clearly states "Strips whitespace from the start and end of every String in an array." — André Stannek, Jul 26 '18 at 10:28

score 0 · Answer 1 · answered Jul 26 '18 at 10:31

0

You can do it with regular expression in JAVA. for example:

String a = "Hello    World!!";
 a = a.replaceAll("\\s","");

Now the value of a = "HelloWorld!!"

answered Jul 26 '18 at 10:31

Gourango Sutradhar

1,461
10
16

i want to remove whitespace from an array of string ,in your case you are removing spaces from a string... – Liyakat Shaikh Jul 26 '18 at 11:14
In this case you just have to make a loop for the array. – Gourango Sutradhar Jul 26 '18 at 11:17
`for(int i = 0 ; i < a.length; i++){ a[i] = a[i].replaceAll("\\s",""); }` – Gourango Sutradhar Jul 26 '18 at 11:18

score 0 · Accepted Answer · answered Jul 26 '18 at 10:49

Assuming your array is in temp variable,

Here is how you can get all spaces trimmed between every string.

String[] temp = {"My Name Is", "And so Far", "All good", "Really?", 
                             "That makes no sense to me", "Oh! Somehthing Like This"};
Stream<String> stream = Arrays.stream(temp);
temp = stream.map(str -> str.replaceAll("\\s",""))
         .toArray(size -> new String[size]);

Now if printing it, it would give this..

for(String st : temp)
        System.out.println(st);

Output:-

MyNameIs
AndsoFar
Allgood
Really?
Thatmakesnosensetome
Oh!SomehthingLikeThis

Thanks for the Idea Man – Liyakat Shaikh Jul 26 '18 at 10:54 — Liyakat Shaikh, Jul 26 '18 at 10:54

score 0 · Answer 3 · answered Jul 26 '18 at 11:21

I created arrayList to modify the array of String contents,

List<String> al = new ArrayList<String>();
for (String element: headerRow) 
     { 
         al.add(element.replace(' ', '_')); 

    }
String[] stripedHeaderRow = al.toArray(new String[al.size()]);//Creating new array of String

//This will fulfill my result.

Want to replace WhiteSpace from array of String

3 Answers3