copy paste from excel

[MathiasLund]

Hi there,
great repo!!

Is it possible to make a pasteSplit functionality that also handles copy-paste from Excel?
I've tried different regex's but I can't seem to make it work.

this is my code:

<ReactTagsInput addOnPaste={true} pasteSplit={ data => { return data .replace(/[\n\r]/g, ' ') .split(' ') .map(d => d.trim()) }} ref="tags" value={this.state.keywords} onChange={this.handleChange} />

and this is my dummy data from excel:

but doing this regex: [\n\r] splits up all of the words between whitespace.
So for instance: "danish pastry", becomes "danish" and "pastry".

any ideas? thanks! :)

[wildeyes]

you should look for \t in your regex.

[jonicious]

I am currently dealing with the same issue. Adding \t to my list of separators did not work. Currently my code looks like this:

pasteSplit(data) {
  const separators = [',', ';', '\\(', '\\)', '\\*', '/', ':', '\\?', '\n', '\t'];
  return data.split(new RegExp(separators.join('|'), 'g')).map(d => d.trim());
}

Help really appreciated!

[wildeyes]

@jonicious try pasting the data into an editor that allows you to see all chars, even invisible ones (like sublime text) to see what the seperators are.

[jonicious]

@MathiasLund I got it working like this: http://stackoverflow.com/a/42008610/3276759 cc @wildeyes

[jonicious]

This solution is better: http://stackoverflow.com/a/42008826/3276759

[olahol]

Added your answer to FAQ @jonicious. Thank you.

[jonicious]

@olahol Thanks. Opened a PR for improving the answer to give credit to the person who solved the problem on Stack Overflow. See #129. :)