how to get the value of string based on my separator

Question

I need to get this string before my separator, in this case a pipe character ('|').

So if I have this data:

Malcolm Bell Landgraab | EMP-00012 | Consultant
Juliawati Sandra | EMP-00003 | Consultant

I want this output:

['Malcolm Bell Landgraab', 'EMP-00012', 'Consultant']
['Juliawati Sandra', 'EMP-00003', 'Consultant']

How can I accomplish this task?

Answer 1

I aM splitting it with respect to newline character and | character. This will work for you.

String inputString='Malcolm Bell Landgraab | EMP-00012 | Consultant\nJuliawati Sandra | EMP-00003 | Consultant';
String []rowsData=inputString.split('\n');

for(String individualROw : rowsData){
    String[] rowArray = individualROw.split('\\|');
        System.debug('[\''+rowArray[0].trim()+'\',\''+rowArray[1].trim()+'\',\''+rowArray[2].trim()+'\']\n' );
        }

If you only want record of Employee only Print rowArray[1] and you are good to go.

Answer 2

This will split it and remove whitespace:

String initialString = 'Malcolm Bell Landgraab | EMP-00012 | Consultant';
String[] results = initialString.trim().split('\\s*\\|\\s*');
system.debug(results);

Of course you will want to add in all the usual checks for null, errors, etc.

For a single string this will get you the EMP part as requested in your comments:

Note I am not the best at regex so best I can do at this point:

Pattern MyPattern = Pattern.compile('(?<=EMP)([^\\s\\|]*)(?=[$\\s\\|])');
Matcher MyMatcher = MyPattern.matcher(initialString);
Boolean result = MyMatcher.find();
String emp;
if(result){
    emp = 'EMP' + MyMatcher.group(0);
}
system.debug(emp);