vicidial.org

by **Op3r** » Wed Jul 08, 2009 2:55 pm

Does any one know how to convert a comma delimited or pipe delimited to a tab delimited file on console?

I was trying to upload like 250k leads at 1 time as open office sucks when dealing with more than 65k rows.

by **okli** » Wed Jul 08, 2009 4:53 pm

Code: Select all: tr ',' '\t' < in.txt > out.txt

or

Code: Select all: sed 's/,/\t/g' in.txt > out.txt

In Windows I use Notepad++, or CSVEd for smaller files, or CygWin tools for large files.

by **Op3r** » Wed Jul 08, 2009 4:56 pm

ok thanks.

I just wasted 2 hours uploading 250k leads on 1 file using the web loader

by **okli** » Wed Jul 08, 2009 5:01 pm

You must be brave

I won't take the risk to upload more than 100k leads at once using the web list loader.

by **Op3r** » Wed Jul 08, 2009 5:21 pm

there's always the first time on everything

by **Op3r** » Wed Jul 08, 2009 5:46 pm

although I didint get to upload all the 250k leads as It only uploaded 223k leads but it was fun.

by **okli** » Thu Jul 09, 2009 7:22 am

223k must be a good result

I wonder- is there anyone uploaded more through the web loader? If yes- what were php.ini settings?

vicidial.org

convert pipe delimited to tab delimited csv

convert pipe delimited to tab delimited csv

Who is online