<div>
Not sure I understand, what do you want the resultant file to look like?<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
I want it to look the exact same but shortened to 18 characters, like this:<br><br>12345^2020-2021^This is the line I^05152020<br>&nbsp;67891^2019-2020^This is the line I^05152020<br>&nbsp; etc.<br>&nbsp; etc.<br>So, the data is still the same but only truncate the lines between the 2nd and 3rd caret.<br><br>
</div>


<div>
As an fyi, I use the file to populate a field which has an 18 character limit.
</div>


Developer & Coffee Roaster

Scott Fell

tracyms

<div>
Thank Bill! I'll test it and let you know how it works.
</div>


<div>
Hi Bill, we ended up using a script on the server side of our ERP to do the work instead of using a batch file. I'm sorry it took a bit to get back to you. We're in the middle of a data migration and working out all the kinks. Thanks for this, I'll keep in my back pocket! :-)
</div>


<div>
<div class="content wysiwyg-content">
I'm looking for a way to truncate text to 18 characters (if it's not already 18 characters) before it's copied to a folder. The text structure will always &nbsp;be the same and I need to truncate the lines between the 2nd and 3rd caret:<br />
<br />
<br />
12345^2020-2021^This is the line I need to have truncated to 18 characters^05152020<br />
67891^2019-2020^This is the line I need to have truncated to 18 characters^05152020<br />
etc.<br />
etc.<br />
<br />
I already have a batch to copy the file but wondering if I can use a batch to truncate it first, then copy it? The file is on a Windows server. Thanks!<br />
<br />
<br />
<br />
Tracy
</div>
</div>


I'm looking for a way to truncate text to 18 characters (if it's not already 18 characters) before it's copied to a folder. The text structure will always  be the same and I need to truncate the lines between the 2nd and 3rd caret:


12345^2020-2021^This is the line I need to have truncated to 18 characters^05152020
67891^2019-2020^This is the line I need to have truncated to 18 characters^05152020
etc.
etc.

I already have a batch to copy the file but wondering if I can use a batch to truncate it first, then copy it? The file is on a Windows server. Thanks!



Tracy

Truncate Text in Text File

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.