How to remove empty strings from array elemnets

Question

Here I am Taking a string data and converting it into array elements but it is getting an empty array at last of all array elements and I am not be able to remove them easily.Please help.

let string_Data = `01226,Grover Cleveland,Anna,Uganda,Crucial Ltd,Tested Mutual B.V,Calvin Coolidge,
    77110,John F. Kennedy,hora,Bosnia Herzegovina,Formal,Papal Corporation,Franklin Roosevelt,
    29552,Lyndon B. Johnson,Margaret,Palau,Summaries Holdings Inc,Customize,Rutherford B. Hayes,`;

let making_Array = csv => {
  var data = [];

  for (let dataAry of csv.split('\n')) {

    data.push(dataAry.split(','));
  }
  return data;

}
console.log(making_Array(string_Data));

you have , at the end of each line, so there's an empty string after the last item. — Barmar
– Barmar, Commented Nov 15, 2022 at 17:57
Why your data has , at the end of each line? It seems like there is a column missing — Konrad
– Konrad, Commented Nov 15, 2022 at 17:57

Yanick Rochon · Accepted Answer · 2022-11-15 18:28:14Z

1

Instead of manipulating arrays, you can prepare the string before being split.

let string_Data = `01226,Grover Cleveland,Anna,Uganda,Crucial Ltd,Tested Mutual B.V,Calvin Coolidge,
    77110,John F. Kennedy,hora,Bosnia Herzegovina,Formal,Papal Corporation,Franklin Roosevelt,
    29552,Lyndon B. Johnson,Margaret,Palau,Summaries Holdings Inc,Customize,Rutherford B. Hayes,`;

let making_Array = csv => {
  var data = [];

  for (let dataAry of csv.split('\n')) {
    // 1. trim both ends of the line for white space, tab, etc.
    // 2. remove any last trailing comma
    // 3. split using comma separator
    data.push(dataAry.trim().replace(/,$/, '').split(','));
  }
  return data;

}
console.log(making_Array(string_Data));

FWIW the entire function can be streamlined, and enhanced like this:

let header = ['id', 'col1', 'col2', 'col3', 'col4', 'col5', 'col6'];

let string_Data = `01226,Grover Cleveland,Anna,Uganda,Crucial Ltd,Tested Mutual B.V,Calvin Coolidge,
    77110,John F. Kennedy,hora,Bosnia Herzegovina,Formal,Papal Corporation,Franklin Roosevelt,
    29552,Lyndon B. Johnson,Margaret,Palau,Summaries Holdings Inc,Customize,Rutherford B. Hayes,`;

let making_Array = csv => csv
  .split('\n')
  .map(line => line
    .trim()             // 1. trim both ends of the line        
    .replace(/,$/, '')  // 2. remove any last trailing comma
    .split(','))        // 3. split using comma separator
    .map(cols => Object.fromEntries(new Map(header
      .map((colName, index) => [colName, cols[index] || '']))));

console.log(making_Array(string_Data));

edited Nov 15, 2022 at 18:28

answered Nov 15, 2022 at 18:09

Yanick Rochon

53.8k30 gold badges146 silver badges231 bronze badges

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

3 Comments

victoriousVINAY Over a year ago

Thanks a lot. It is of great help I tried replace too but didn't know where to use it.Thank you

Yanick Rochon Over a year ago

No problem! If you want to convert the array to some object, take a look at the edit I just posted. Cheers!

victoriousVINAY Over a year ago

how would you know , its my second step of the program. U r awsome

chovy · Accepted Answer · 2022-11-15 18:00:49Z

1

This will remove empty strings, but it'll also remove falsey values.

const values = arr.filter(Boolean);

answered Nov 15, 2022 at 18:00

chovy

76.2k63 gold badges249 silver badges324 bronze badges

2 Comments

Barmar Over a year ago

Probably not a good idea for a CSV, as it will remove empty values in the middle of the line. That will cause different rows to have different columns.

victoriousVINAY Over a year ago

that's why we are separating it with \n at first

Barmar · Accepted Answer · 2022-11-15 18:04:28Z

0

The empty string is because of the , at the end of each line.

You can use the slice() method to remove the last element of the array.

data.push(dataAry.split(',').slice(0, -1))

When you use a negative index as the end of a slice, it counts from the end.

edited Nov 15, 2022 at 18:04

answered Nov 15, 2022 at 17:58

Barmar

789k57 gold badges554 silver badges669 bronze badges

1 Comment

Metro Smurf Over a year ago

For reference, the -1 parameter counts backwards: Negative index counts back from the end of the array — if end < 0, end + array.length is used So in this case, the last element of the array is removed.

Collectives™ on Stack Overflow

How to remove empty strings from array elemnets

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related