- 0
Extracting select data from CSV file (one column)
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Posts
-
By hellowalkman · Posted
certainly seems so! :\ -
By News Staff · Posted
Get Microsoft Office 2021 Professional for Windows, now only $44.97 by Steven Parker Get all these essential Microsoft apps for your Windows PC Today's highlighted deal comes via our Apps + Software section of the Neowin Deals store, where you can score a lifetime license to Microsoft Office 2021 for Windows for only $44.97 (buying link below). This bundle is for families and small businesses who want classic Office apps and email. It includes Word, Excel, PowerPoint, Outlook, Teams, and OneNote. A one-time purchase installed on 1 Windows PC for use at home or work. Lifetime license for MS Word, Excel, PowerPoint, Outlook, Teams, & OneNote One-time purchase installed on 1 Windows PC for use at home or work Instant Delivery & Download – access your software license keys and download links instantly Free customer service – only the best support! Microsoft Office Professional 2021 (for Windows) includes: Microsoft Office Word Microsoft Office Excel Microsoft Office PowerPoint Microsoft Office Outlook Microsoft Office Teams Microsoft Office OneNote Microsoft Office Publisher Microsoft Office Access No faffing about with subscriptions, just classic apps that don't expire.Good to Know ONE-TIME PURCHASE INSTALLED ON 1 DEVICE Redemption deadline: redeem your code within 30 days of purchase Access options: desktop Full versions No subscriptions – no monthly/annual fees Version: 2021 Updates included A lifetime subscription to Microsoft Office 2021 Professional normally costs $219.99, but this deal can be yours for just $49.97, that's a saving of $180. For full terms, specifications, and license info, click the link below. Use MSO5 coupon for an additional $5 off. Expires June 29. Get Microsoft Office Professional 2021 deal for just $44.97, or learn more Although priced in U.S. dollars, this deal is available for digital purchase worldwide. We post these because we earn commission on each sale so as not to rely solely on advertising, which many of our readers block. It all helps toward paying staff reporters, servers and hosting costs. Other ways to support Neowin Whitelist Neowin by not blocking our ads Create a free member account to see fewer ads Make a donation to support our day to day running costs Subscribe to Neowin - for $14 a year, or $28 a year for an ad-free experience Disclosure: Neowin benefits from revenue of each sale made through our branded deals site powered by StackCommerce. -
By Alera · Posted
This is a common misnomer that Intel refuses to correct, E-Cores the E doesn't stand for efficiency in power (although they are more efficient than performance cores) but are actually "space efficient" which means they occupy much less space for same computational power thus allowing more of them in a footprint. -
-
By adrynalyne · Posted
If you have top secret documents from the government or your company, you will not use a user cloud service. Pete Hegseth would like a word. I doubt that security fiasco stops at Signal. Stop being so stupid that you think that your useless information on your PC is as important as you think it is. This is just another crude way of saying it shouldn't matter if have nothing to hide. Not everyone wants to become a product, but you do you. If you cared about the content, you would not use these documents and photos on Android and iPhone phones because the telemetry there is 100,000% worse than on Windows 11. I love the telemetry comment. You cannot prove one way or another if it's better or worse on Windows vs. iOS or Android.
-
-
Recent Achievements
-
Cole Multipass earned a badge
Reacting Well
-
JLP earned a badge
Reacting Well
-
Rhydderch earned a badge
Week One Done
-
dismuter went up a rank
Experienced
-
mevinyavin earned a badge
One Month Later
-
-
Popular Contributors
-
Tell a friend
Question
Cheryl_27
Have a CSV file w/ about 15 columns - when opened in spread sheet (also have couple of "CSV editor" prgms).
Want to take 1 of the columns (by what ever method), & get it into a text config file in another prgm.
When you look at any CSV file in a text editor, there are NO spaces after each comma & before next data (datum).
The syntax for the prgm (text file) I'm trying to enter the data into, shows no spaces to be used between each comma & next data. Just a command then data list, w/ each piece of data separated by commas, but no spaces. It appears when I enter the data (including spaces) in the other prgm's text file, it does NOT use it correctly. I'm * assuming * it's because of the spaces - but I'm no expert on this.
Everything I've tried w/ Open Office, Excell (older ver), the CVS editors, Notepad ++, always winds up putting a space after each comma - before next piece of data.
Even when I delete everything from the orig CVS file except the column I want, once opened in the spread sheets, then save it in .cvs format, then reopen it in something other than a spreadsheet (text editor, etc.), it either has no commas at all, or put spaces between data. In short, the spreadsheets aren't saving the edited files in the EXACT same CVS format (w/ no spaces) as the original CVS file.
Any ideas how to do it the way (I think) I need to do it, w/o introducing spaces? Thanks.
Link to comment
https://www.neowin.net/forum/topic/993490-extracting-select-data-from-csv-file-one-column/Share on other sites
6 answers to this question
Recommended Posts