Ultraedit split csv file

That is important because the CSV files use Unix line endings. So be careful not modifying in any way an opened CSV file. Pressing key Del modifies with this setting the opened file without being able to undo this modification.

Best would be to work always with a copy of the file to split on using this option which is highly recommend for working with such large files. Uncheck at Editor display - Miscellaneous the option Disable line numbers. The other configuration settings do not really matter in this case. The CSV files are not syntax highlighted at all. Therefore code folding is not applied automatically on file open and there is not done a search for function strings by UltraEdit on the not syntax highlighted CSV files.

The UltraEdit script in the attached ZIP file is designed for splitting up the active file on start of script execution. So the script file must be added to the Script list and executed from this list. On using the ribbon mode click on last ribbon tab Advanced in fourth group Script on second item All scripts to open the Scripts window.

The button Add can be used to add the script without or with a description. Then the script can be executed by clicking on same ribbon tab in same group on item Play script , or by opening the Script list by checking this item on ribbon tab Layout and double clicking on the script in the list. The script creates the files in the directory of the active file on script start.

The file name is the found value string in fourth data column. The file extension of the active file on script start is used also for the file extension of the created files. The script opens the output window and shows the file name of each saved file during the script execution. There is the boolean variable bShowFullProgress at top of the script of which value can be modified to true to get even more information displayed during execution of the script in the output window.

There is also at top of the script the variable nMaxLinesPerBlock with the value This value defines how many lines with same value in fourth data column are copied at once from the file to split to the new file.

It was not possible with using bit and not bit UltraEdit v UltraEdit respectively Windows could not allocate a large enough memory block for all lines with data value APA. That would have perhaps worked with using bit UltraEdit. And how to use it? That's quite simple. Download it from the server and store it in your scripts folder.

This function is only needed for merging contents in files found in a folder. Function GetListOfFiles is not required for copying the contents of all open files into a new file. Save the script file and add it to your script list. That's it. It is ready for usage. On execution you will be asked for the main options of the script.

Other options like listing the files processed in the output window or which text should be inserted above every text copied from a file must be enabled by modifying the script. The script is completely commented and therefore it should be no problem even for script newbies to make personal adaptations. Please read the comment at top of the script file for further details. And it supports optionally also to insert the file name of the source CSV file as additional text at start or end of every row of the copied data lines.

Both script files were last updated on If you have found a mistake in the script code, a typo or grammar mistake, or something is not clear, or if there is a problem with one of the two scripts, then please post a reply here and inform me. Suggestions for further enhancements are also welcome. Please insert at top of the localized script below the copyright line a line with your alias name for the translation, something like Translated by: xxx in your language.