that txt file is SOOOOO big.......

CorCor

I have a 7GB txt file.

Figured out how to import it, but........

cant properly split it into columns.

And here's the kicker......cause I cant open it - I don't know what the delimiter is. All your typicals do not work.

I know it has about 70 columns.......cause I know what the headers are.....but......

Can't get it to split up properly.

Any clues?

Thanks

Corey

Input

Preparation

Accepted answers

geraldo

Hi,

This file is the delimiters is <tab> use \ t in the Delimiters option

[]

All comments

lmorrell

Hi Corey,

Just a stray thought, but would it be possible to use regex to identify the delimiter? If you have the header names and the order of the headers it could be possible to parse out the characters separating them with a regex replace.

big txt.yxmd

KaneG

You can bring it in with no delimiter to take a look at the format. Set up would be like below

danilang

Hi @CorCor

If neither of the excellent options listed by @KaneG, and @lmorrell work, can you post the first row as a .yxdb file?

If they work, can you mark them as solutions to help other users?

Thanks

Dan

CorCor

Well....I did as @KaneG suggested.....and then attached the first 100 rows here.

I don't see any delimiters. BUt then again - I am a newbie.

Now......interestingly enough......I know what the column headers should be.

I will now try to follow what @lmorrell suggested.

Thanks!

Corey

txt_file_issue.yxdb

geraldo

Hi,

This file is the delimiters is <tab> use \ t in the Delimiters option

[]

CorCor

@geraldo for the WIN!!!!!!!!

Bless you!

I am sure everyone else is rolling their eyes and saying, "of course" - but how did you know it was tabs??

Please educate a lowly freshman.

Thank

you!

Corey

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703