better, added statement to bash script to include

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #373,326 by boxley 4/3/13 1:30:01 PM Reply	better, added statement to bash script to include an echo of the variable I need in the file. So I get my new 500+ files for %f in (*.txt) do type "%f" >> new.txt cats all 500+ files into one file use notebook++ search and replace to remove all of the line feeds to have just one long line use search and replace to add a linefeed just in front of the unique variable name and voila, a single column that I needed for excel. Now off to learn excel merging Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free American and do not reflect the opinions of any person or company that I have had professional relations with in the past 57 years. meep
Post #373,340 by altmann 4/3/13 3:00:07 PM Reply	Excel VBA Could have used VBA to pull in the file contents.
Post #373,343 by boxley 4/3/13 3:30:30 PM Reply	Re: Excel VBA, couldn't remember any :-) Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free American and do not reflect the opinions of any person or company that I have had professional relations with in the past 57 years. meep
Post #373,387 by pwhysall 4/4/13 1:57:21 AM Reply	F1, or record the macro, or use a fancy pants text import. I use an unholy combination of C#, Python, Excel and sed to munge data around (don't ask, it's one of those things where the progenitor of the thing that makes the report files did that thing where the output looks pretty on screen but is actually about as machine-readable as a punch in the face) these days.

up an odious creek sans paddle - (boxley) - (20) - April 2, 2013, 04:26:12 PM EDT

Sounds like an ideal application for Python. - (Another Scott) - (5) - April 2, 2013, 04:32:45 PM EDT

cannot use external software - (boxley) - (4) - April 2, 2013, 04:48:27 PM EDT

Will "sort" help? It's there in Winders. "sort /?" -NT - (Another Scott) - (2) - April 2, 2013, 05:16:22 PM EDT

its there but I need to remember how to do loops in - (boxley) - (1) - April 2, 2013, 05:22:36 PM EDT

Here... - (folkert) - April 2, 2013, 05:26:14 PM EDT

Now you know... - (folkert) - April 2, 2013, 05:19:13 PM EDT

The sort of thing I'd use Emacs for - (malraux) - (6) - April 2, 2013, 07:48:23 PM EDT

no emacs -NT - (boxley) - (5) - April 2, 2013, 08:56:36 PM EDT

Its downloadable - (folkert) - (4) - April 2, 2013, 09:30:56 PM EDT

He can't download anything... -NT - (malraux) - (2) - April 2, 2013, 10:01:27 PM EDT

download it at home - (lincoln) - (1) - April 3, 2013, 09:25:11 AM EDT

Not worth the risk. - (Another Scott) - April 3, 2013, 09:57:55 AM EDT

NSA DOD rules in place -NT - (boxley) - April 3, 2013, 09:59:14 AM EDT

How does the filename convert to the cell reference? -NT - (scoenye) - (1) - April 3, 2013, 07:45:55 AM EDT

file name references a spec - (boxley) - April 3, 2013, 10:01:24 AM EDT

Small files fitting in a spreadsheet? - (crazy) - April 3, 2013, 07:47:40 AM EDT

better, added statement to bash script to include - (boxley) - (3) - April 3, 2013, 01:30:01 PM EDT

Excel VBA - (altmann) - (2) - April 3, 2013, 03:00:07 PM EDT

Re: Excel VBA, couldn't remember any :-) -NT - (boxley) - (1) - April 3, 2013, 03:30:30 PM EDT

F1, or record the macro, or use a fancy pants - (pwhysall) - April 4, 2013, 01:57:21 AM EDT

iwethey.org

And don't forget the fire ants.
92 ms