Substring alpha characters from an alpha numeric string using Javascript

Question

I have a file that contains employee numbers alongside the employee name and then the department. It looks like this:

0234569884566781DOE, JOHN K KF ("KF" is the department)

2487231227879636WHITE, ERIC C KF

0234569884566781DOE, JOHN KRT ("RT" is the department. Some do not have a space after the middle initial like the first two examples)

and so on.

I am trying to do a substring where the output is the employees full name i.e. DOE, JOHN K. How would I set up the substring to only get the full name and nothing else?

The starting position will always be 16 because the employee number is always 16 digits. But I am not sure what the end position would be because the name obviously differs in length for each person.

Post the code that reads from that "file".

Salman Arshad
– Salman Arshad

2019-12-05 18:13:59 +00:00
Commented Dec 5, 2019 at 18:13 — Salman Arshad
– Salman Arshad, Commented Dec 5, 2019 at 18:13
.slice(16, -2) .

Jonas Wilms
– Jonas Wilms

2019-12-05 18:17:13 +00:00
Commented Dec 5, 2019 at 18:17 — Jonas Wilms
– Jonas Wilms, Commented Dec 5, 2019 at 18:17

Bibberty · Accepted Answer · 2019-12-05 18:18:50Z

1

Hope this helps,

const staff = [
"0234569884566781DOE, JOHN K KF",
"2487231227879636WHITE, ERIC C KF",
"2487231227879636BLACK, JANE CRF"
];

const names = staff.map(line => {
  let n = line.substring(16);
  n = n.substring(0, n.length-2);
  return n.trim();
});

console.log(names);

answered Dec 5, 2019 at 18:18

Bibberty

4,7762 gold badges10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

adiga Over a year ago

@Bri if an answer resolves your issue, please mark it as accepted by clicking on the grey checkmark on the left of it.

Cobolt · Accepted Answer · 2019-12-05 18:20:59Z

0

Here is one way

const pieces = '2487231227879636WHITE, ERIC C KF'.split(' ')
pieces.pop() // remove department
const lastName = pieces[0].substr(16)
pieces.reverse()
pieces.pop() // remove first name with employee num prefix
const name = lastName + pieces.join(' ')

answered Dec 5, 2019 at 18:20

Cobolt

9532 gold badges11 silver badges25 bronze badges

Comments

KevBot · Accepted Answer · 2019-12-05 18:56:15Z

0

You can use a little bit of regex to accomplish this:

const employees = [
  "0234569884566781DOE, JOHN K KF",
  "2487231227879636WHITE, ERIC C KF",
  "2487231227879636BLACK, JANE CRF"
];
const regex = /^\d+([a-z, ]+?) ?[a-z]{2}$/i;
const names = employees.map(data => data.match(regex)[1]);
console.log(names);

answered Dec 5, 2019 at 18:56

KevBot

19k5 gold badges54 silver badges71 bronze badges

Collectives™ on Stack Overflow

Substring alpha characters from an alpha numeric string using Javascript

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related