Tek Info

Test your restores, not your backups...

Bill Prew

IT Professional

Albert Widjaja

<div>
Wow this works amazingly oBdA &nbsp;thank you very much. <br />
I just didn't try the email feature yet but I will. <br />
Many thanks.<br />
I will need to open a few more tickets since there will be more data I will hope to calculate and display as well from that file and perhaps 1 more file at least. <br />
I hope you chime in on this to help me through as you did this time.<br />
<br />
Oh and only Ref# is constant in every file for all lines of data, the Imp can change..
</div>


Wow this works amazingly oBdA  thank you very much.
I just didn't try the email feature yet but I will.
Many thanks.
I will need to open a few more tickets since there will be more data I will hope to calculate and display as well from that file and perhaps 1 more file at least.
I hope you chime in on this to help me through as you did this time.

Oh and only Ref# is constant in every file for all lines of data, the Imp can change..

<div>
Extremly helpful. Look forward to more assistance.
</div>


Extremly helpful. Look forward to more assistance.

<div>
<div class="content wysiwyg-content">
I would like to extract data from a Source.in file and save it to either another file called Output.out<br />
The goal is to then copy the contents of the Output.out to the body of an email which can be sent out. <br />
Please see that attached Source.in file.<br />
<br />
I would like the Output.out text file to summarize the following data:<br />
<br />
<br />
Ref#: &nbsp;1009<br />
<br />
Item: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Full P: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Part P:<br />
10-1000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0<br />
11-1111 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0<br />
<br />
<br />
Thanks in advance for your help.<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/02_w08/1444365/Source.in" target="_blank" class="file-inline" title="Source.in (662 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Source.in</a>
</div>
</div>


Source.in

I would like to extract data from a Source.in file and save it to either another file called Output.out
The goal is to then copy the contents of the Output.out to the body of an email which can be sent out. 
Please see that attached Source.in file.

I would like the Output.out text file to summarize the following data:


Ref#:  1009

Item:                 Full P:          Part P:
10-1000          2                  0
11-1111          1                  0


Thanks in advance for your help.

Extract date from text file to another text file

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.