<div>
Will the <b>\\89.1.1.133\HAGEMEYER\</b> be the same for all lines in the file?<br />
<br />
Will the <b>CDHM</b> be the same for all lines?
</div>


Will the \\89.1.1.133\HAGEMEYER\ be the same for all lines in the file?

Will the CDHM be the same for all lines?

<div>
<div class="content wysiwyg-content">
Hi All,<br />
I have a text file which contains many rows (1000's of lines) of the below.<br />
BIB9407/002,\\89.1.1.133\H<wbr />AGEMEYER\C<wbr />DHM2140812<wbr />\NE045673\<wbr />00000001.p<wbr />df<br />
<br />
I need to make it look like<br />
BIB9407/002,CDHM2140812\NE<wbr />045673\000<wbr />00001.pdf<br />
<br />
So remove everything after the first , upto CDHM<br />
<br />
I can do this easily using find replace but I need to automate this <br />
<br />
Any guidance on how to script this will be appreciated it does not have to be in Powershell it can be VB script/batch.<br />
<br />
Regards<br />
<br />
John Harris
</div>
</div>


Hi All,
I have a text file which contains many rows (1000's of lines) of the below.
BIB9407/002,\\89.1.1.133\HAGEMEYER\CDHM2140812\NE045673\00000001.pdf

I need to make it look like
BIB9407/002,CDHM2140812\NE045673\00000001.pdf

So remove everything after the first , upto CDHM

I can do this easily using find replace but I need to automate this 

Any guidance on how to script this will be appreciated it does not have to be in Powershell it can be VB script/batch.

Regards

John Harris

POwershell Script

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

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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.