Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Multiple whitespaces as a separator in variable explorer #4581

Closed
bcolsen opened this issue Jun 10, 2017 · 2 comments
Closed

Multiple whitespaces as a separator in variable explorer #4581

bcolsen opened this issue Jun 10, 2017 · 2 comments

Comments

@bcolsen
Copy link
Member

bcolsen commented Jun 10, 2017

Currently the data import wizard doesn't play nicely with text data with multiple spaces as delimiters(or maybe I don't play nicely with the data importer ;-). This is common in fixed width data sets like this:

FIRST  LAST           STATE     TELEPHONE      AGE   WEIGHT
John   Smith          WA        418-Y11-4111    26    3.0456
Mary   Hartford       CA        319-Z19-4341     5   13.5687
Evan   Nolan          IL        219-532-c301   145   45.7890

Putting a ' ' (a space) in a the 'other' text box gives this:

screenshot from 2017-06-09 22-54-23

When it could give this:

screenshot from 2017-06-09 22-59-21

I can submit a pull request to add a "whitespace" radio button to have this option, if you think that's a good direction to go.

@ccordoba12
Copy link
Member

I can submit a pull request to add a "whitespace" radio button to have this option, if you think that's a good direction to go.

Sounds good to me, but I don't understand where that option would be placed.

@bcolsen
Copy link
Member Author

bcolsen commented Jun 10, 2017

something like this:

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants