How to count words in a comma separated .csv file
Thread poster: Helmaninquiel
Helmaninquiel
Local time: 03:45
English to Spanish
+ ...
Oct 15, 2012

Hi all,
I have a folder with .csv files which must be opened using Notepad++ (or anyother with UTF8 support).
The files contain text in two languages. Instead of being in separated columns, they are separated by commas, so there's no way to copy and paste source text in a new document.
I have tried to use SDL Studio and some segments are ok, but others are incomplete and missing.
Do you know another way to extract source text?
Thanks in advance,
Best.


Direct link Reply with quote
 
Joakim Braun  Identity Verified
Sweden
Local time: 03:45
German to Swedish
+ ...
Replace Oct 15, 2012

Replace commas with tabs and paste into a spreadsheet?

Direct link Reply with quote
 

Anna Haxen  Identity Verified
Denmark
Local time: 03:45
Member (2005)
English to Danish
+ ...
Have you tried opening with Excel? Oct 15, 2012

I have often worked with comma separated .csv data files, which I could open with Excel and have the data displayed in separate columns. Maybe you can do this with your files and have the text displayed in separate columns? You can then copy and paste the source text into Word and get your word count.

Direct link Reply with quote
 
Helmaninquiel
Local time: 03:45
English to Spanish
+ ...
TOPIC STARTER
Thank you, but it doesn't work Oct 15, 2012

Joakim Braun wrote:

Replace commas with tabs and paste into a spreadsheet?


Comma dissapears, but both source and target text are in the same line.
Thanks for your help


Direct link Reply with quote
 
Helmaninquiel
Local time: 03:45
English to Spanish
+ ...
TOPIC STARTER
Thank you, but it doen't work with this file Oct 15, 2012

Anna Haxen wrote:

I have often worked with comma separated .csv data files, which I could open with Excel and have the data displayed in separate columns. Maybe you can do this with your files and have the text displayed in separate columns? You can then copy and paste the source text into Word and get your word count.



I tried that, but source and target columns are in the same cell.
Thank you


[Edited at 2012-10-15 17:32 GMT]


Direct link Reply with quote
 

Anna Haxen  Identity Verified
Denmark
Local time: 03:45
Member (2005)
English to Danish
+ ...
How did you open it? Oct 15, 2012

You have to make certain selections when opening the file to open it correctly but I can't remember what they are unless I have an actual file to open. If you send me one of the files, I could try.

Direct link Reply with quote
 
Helmaninquiel
Local time: 03:45
English to Spanish
+ ...
TOPIC STARTER
Excel and Notepad++ Oct 15, 2012

Anna Haxen wrote:

You have to make certain selections when opening the file to open it correctly but I can't remember what they are unless I have an actual file to open. If you send me one of the files, I could try.


I just double-clicked for opening it with Excel or selected Open with>NotePad++.
I appreciate all your help.
I will send you a small file. But, if you can't separate into columns in your first try, forget about it. You already spent time with this


Direct link Reply with quote
 

Anna Haxen  Identity Verified
Denmark
Local time: 03:45
Member (2005)
English to Danish
+ ...
Send me a message via my profile Oct 15, 2012

- and I will reply to give you my email address so that you can attach the file.

Direct link Reply with quote
 

Hans Lenting  Identity Verified
Netherlands
Member (2006)
German to Dutch
+ ...
Don't open CSV by double-clicking on it Oct 15, 2012

Helmaninquiel wrote:

I just double-clicked for opening it with Excel or selected Open with>NotePad++.


That indeed is not the proper way to open a CSV file when you want to convert it to an Excel sheet.

Many CSV files contain a warning in the first lines that they shouldn't be opened that way.

This is the right way to do it: http://cas.sdss.org/dr4/en/help/howto/graph/open.asp


Direct link Reply with quote
 
Helmaninquiel
Local time: 03:45
English to Spanish
+ ...
TOPIC STARTER
You are right Oct 16, 2012

Hans Lenting wrote:

Helmaninquiel wrote:

I just double-clicked for opening it with Excel or selected Open with>NotePad++.


That indeed is not the proper way to open a CSV file when you want to convert it to an Excel sheet.

Many CSV files contain a warning in the first lines that they shouldn't be opened that way.

This is the right way to do it: http://cas.sdss.org/dr4/en/help/howto/graph/open.asp


Thank you.
I just tought I had to remove manually to get the wordcount


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to count words in a comma separated .csv file

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search