ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   input to 2nd column help (https://www.excelbanter.com/excel-discussion-misc-queries/29615-input-2nd-column-help.html)

stn0795

input to 2nd column help
 

Hi there,

I have a small script with output is *.xls file. However, all place in
column A.
I want that all "Name1" place in Column A, and all "Name2" place in
column B whenever output file execute.

For Ex,
fgrep "Name1" temp.txt out.xls
fgrep "Name2" temp.txt out.xls

What should I put more here to get the "Name2" place in the column B
when I execute?
Your assistance is apprecite!!

Thanks
Son


--
stn0795
------------------------------------------------------------------------
stn0795's Profile: http://www.excelforum.com/member.php...o&userid=24112
View this thread: http://www.excelforum.com/showthread...hreadid=377161


Dave Peterson

How about an alternative?

fgrep "Name1" temp.txt out1.txt
fgrep "Name2" temp.txt out2.txt

Now open out1.txt.
Then open out2.txt
copy the data in out2.txt and paste into B1 of out1.txt



stn0795 wrote:

Hi there,

I have a small script with output is *.xls file. However, all place in
column A.
I want that all "Name1" place in Column A, and all "Name2" place in
column B whenever output file execute.

For Ex,
fgrep "Name1" temp.txt out.xls
fgrep "Name2" temp.txt out.xls

What should I put more here to get the "Name2" place in the column B
when I execute?
Your assistance is apprecite!!

Thanks
Son

--
stn0795
------------------------------------------------------------------------
stn0795's Profile: http://www.excelforum.com/member.php...o&userid=24112
View this thread: http://www.excelforum.com/showthread...hreadid=377161


--

Dave Peterson


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com