Split the string after 40 character

since_1995 — Fri, 15 Nov 2024 23:05:42 GMT

I am extracting the name from Snowflake.

Name has more than 40 characters. To make this easy, I am going to split the name and put the first 40 characters in Col1 and the rest in Col 2. I'm worried about splitting the string in the middle of a word.

For example:

Name is : " Talend Advantage International Consulting Solutions LLC"

here i have 55 characters,

If i split the first 40 characters in col1 it will be "Talend Advantage International Consultin"

Instead, i want to have "Talend Advantage International" in col1 and

"Solutions LLC" in col2

I want to avoid the middle word splitting.

Please help!!

Re: Split the string after 40 character

Anonymous — Wed, 23 Mar 2022 20:54:41 GMT

A routine like this will work. I've just knocked it up and it will need refining (it doesn't currently catch situations where the sentence size is smaller than the biggest word, for example). Have a play and refine as required....

package routines;

public class WholeWordSplit {

public static String[] splitSentence(String sentence, int sentenceSize) {

String[] returnVal;

String[] vals = sentence.split(" ");

int size = 0;

java.util.ArrayList<String> columns = new java.util.ArrayList<String>();

for(int i=0; i< vals.length; i++){

if(columns.size()<1 || (size+vals[i].length()+1) > sentenceSize){

columns.add(vals[i]);

size = vals[i].length();

}else{

String tmpStr = columns.remove(columns.size()-1);

tmpStr = tmpStr+" "+ vals[i];

columns.add(tmpStr);

size = tmpStr.length();

}

returnVal = columns.toArray(new String[columns.size()]);

return returnVal;

}

topic Re: Split the string after 40 character in Talend Studio

Split the string after 40 character

Re: Split the string after 40 character