Output Of FIND command in dos to Excel File.


 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions Output Of FIND command in dos to Excel File.
# 1  
Old 03-11-2010
Output Of FIND command in dos to Excel File.

Hi
I want to export DOS output of find command in Excel.
However I want information to be in different column and not in same.

I am using this command

Code:
 
set /p String_to_search='Enter String to search !'
set /p File_to_search='Enter File to search !'
findstr /N "%String_to_search%" "%File_to_search%" > test2.xls

This is outputting the data to a single column.
Output is like 4:Hello in same column
I want
4|Hello in different column.
How to do it ?
Please help !
I also want to set column Names for my excel.
So desired output should look like:

Line |Text
4 | Hello
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How do I redirect output from "find", either to a file or another command?

I'm trying to find out what happened to the rogue game that apt-get told me it installed, so I thought I would find the file. I went to the root and entered: find -name "rog*.*" I get a large number of lines saying my access is denied in various directories. I figure I'll practice my Unix... (14 Replies)
Discussion started by: arghvark
14 Replies

2. UNIX for Beginners Questions & Answers

For loop output to excel file

Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help? The output which I get Server1 : count... (1 Reply)
Discussion started by: srilaxman
1 Replies

3. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

4. Shell Programming and Scripting

Help with Passing the Output of grep to sed command - to find and replace a string in a file.

I have a file example.txt as follows :SomeTextGoesHere $$TODAY_DT=20140818 $$TODAY_DT=20140818 $$TODAY_DT=20140818I need to automatically update the date (20140818) in the above file, by getting the new date as argument, using a shell script. (It would even be better if I could pass... (5 Replies)
Discussion started by: SriRamKrish
5 Replies

5. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies

6. Shell Programming and Scripting

Find command don't output anything, but file is there

Please if You can help me debug why nothing is found by this command? # echo "Zeus Robot" >> /home/vps/190/test # cat /home/vps/190/test Zeus Robot # find /home/vps -type f -mtime 2 -size -1000k -exec grep -l "Zeus Robot" {} \; >> out # cat out # cat /home/vps/190/test Zeus Robot Why... (6 Replies)
Discussion started by: postcd
6 Replies

7. Shell Programming and Scripting

UNIX command to count blank lines in a file in DOS format

Hi Team, The content of the file is as follows. asdf 234 asdf asdf dsfg gh 67 78 The file is in DOS format (not in Unix Format). The file is transferred to Unix. I need a unix command to check the number of blank lines in a input (comming from Windows). If it is greater than... (4 Replies)
Discussion started by: kmanivan82
4 Replies

8. Shell Programming and Scripting

Help to get the Output of PL/SQL procedure In a Excel or Text File

Hi, Could anyone please guide me to get the output of the PL/SQL procedure in a Excel file or Text File... Thanks (1 Reply)
Discussion started by: funonnet
1 Replies

9. Windows & DOS: Issues & Discussions

Split Data in one column into 2 column in Excel using DOS or VBScript

Hi I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns. Current Data: 1,Hi Everyone,I am 7,New To Dos,And 17,VB Script,i could 110,have tried this thing 1800,in UNIX Desired Output CELL1|CELL 2 1 |Hi... (3 Replies)
Discussion started by: dashing201
3 Replies

10. Shell Programming and Scripting

oracle query output in excel file

Hi All, I have seen many examples of spooling query output in csv file. But I want to spool the query results in proper excel file. Can you guys help me on this? (4 Replies)
Discussion started by: yabhi_22
4 Replies
Login or Register to Ask a Question
libcaca DOS conio.h compatibility layer(3caca)			      libcaca			    libcaca DOS conio.h compatibility layer(3caca)

NAME
libcaca DOS conio.h compatibility layer - Functions __extern char * caca_conio_cgets (char *str) DOS conio.h cgets() equivalent. __extern void caca_conio_clreol (void) DOS conio.h clreol() equivalent. __extern void caca_conio_clrscr (void) DOS conio.h clrscr() equivalent. __extern int caca_conio_cprintf (const char *format,...) DOS conio.h cprintf() equivalent. __extern int caca_conio_cputs (const char *str) DOS conio.h cputs() equivalent. __extern int caca_conio_cscanf (char *format,...) DOS stdio.h cscanf() equivalent. __extern void caca_conio_delay (unsigned int) DOS dos.h delay() equivalent. __extern void caca_conio_delline (void) DOS conio.h delline() equivalent. __extern int caca_conio_getch (void) DOS conio.h getch() equivalent. __extern int caca_conio_getche (void) DOS conio.h getche() equivalent. __extern char * caca_conio_getpass (const char *prompt) DOS conio.h getpass() equivalent. __extern int caca_conio_gettext (int left, int top, int right, int bottom, void *destin) DOS conio.h gettext() equivalent. __extern void caca_conio_gettextinfo (struct caca_conio_text_info *r) DOS conio.h gettextinfo() equivalent. __extern void caca_conio_gotoxy (int x, int y) DOS conio.h gotoxy() equivalent. __extern void caca_conio_highvideo (void) DOS conio.h highvideo() equivalent. __extern void caca_conio_insline (void) DOS conio.h insline() equivalent. __extern int caca_conio_kbhit (void) DOS conio.h kbhit() equivalent. __extern void caca_conio_lowvideo (void) DOS conio.h lowvideo() equivalent. __extern int caca_conio_movetext (int left, int top, int right, int bottom, int destleft, int desttop) DOS conio.h movetext() equivalent. __extern void caca_conio_normvideo (void) DOS conio.h normvideo() equivalent. __extern void caca_conio_nosound (void) DOS dos.h nosound() equivalent. __extern int caca_conio_printf (const char *format,...) DOS stdio.h printf() equivalent. __extern int caca_conio_putch (int ch) DOS conio.h putch() equivalent. __extern int caca_conio_puttext (int left, int top, int right, int bottom, void *destin) DOS conio.h puttext() equivalent. __extern void caca_conio__setcursortype (int cur_t) DOS conio.h _setcursortype() equivalent. __extern void caca_conio_sleep (unsigned int) DOS dos.h sleep() equivalent. __extern void caca_conio_sound (unsigned int) DOS dos.h sound() equivalent. __extern void caca_conio_textattr (int newattr) DOS conio.h textattr() equivalent. __extern void caca_conio_textbackground (int newcolor) DOS conio.h textbackground() equivalent. __extern void caca_conio_textcolor (int newcolor) DOS conio.h textcolor() equivalent. __extern void caca_conio_textmode (int newmode) DOS conio.h textmode() equivalent. __extern int caca_conio_ungetch (int ch) DOS conio.h ungetch() equivalent. __extern int caca_conio_wherex (void) DOS conio.h wherex() equivalent. __extern int caca_conio_wherey (void) DOS conio.h wherey() equivalent. __extern void caca_conio_window (int left, int top, int right, int bottom) DOS conio.h window() equivalent. Detailed Description These functions implement DOS-like functions for high-level text operations. Author Generated automatically by Doxygen for libcaca from the source code. Version 0.99.beta18 Fri Apr 6 2012 libcaca DOS conio.h compatibility layer(3caca)