https://wiki.ultraedit.com/index.php?action=history&feed=atom&title=CSV_convert_to_fixed_width 2026-06-18T03:51:14Z Revision history for this page on the wiki MediaWiki 1.29.0 https://wiki.ultraedit.com/index.php?title=CSV_convert_to_fixed_width&diff=328&oldid=prev 2017-08-17T12:48:05Z

<p>Created page with &quot;<a href="/Category:Edit_tab" title="Category:Edit tab">Category:Edit tab</a> <a href="/File:Ultraedit_convert_csv_to_fixed_columns.png" title="File:Ultraedit convert csv to fixed columns.png">right|alt=screenshot of the CSV convert to fixed columns dialog</a> The &#039;&#039;&#039;convert to fixed width&#039;&#039;&#039; func...&quot;</p> <p><b>New page</b></p><div>[[Category:Edit tab]]<br /> [[File:Ultraedit convert csv to fixed columns.png|right|alt=screenshot of the CSV convert to fixed columns dialog]]<br /> The &#039;&#039;&#039;convert to fixed width&#039;&#039;&#039; function allows you to convert a file from character-delimited fields (e.g., CSV) to fixed columns. This is particularly useful where changes in column(s) are required but difficult due to varying field widths for each row. This complements the [[Convert fixed width to CSV]] feature.<br /> <br /> The &quot;Convert to fixed columns&quot; dialog offers the following options:<br /> <br /> &#039;&#039;&#039;Scan&#039;&#039;&#039;&lt;br&gt;<br /> When clicked, UltraEdit will scan the file (or first line based on the next setting) and determine the maximum field widths for each field. This will determine the maximum width required for each field and place the results (comma separated) in the &#039;&#039;&#039;Field widths&#039;&#039;&#039; entry box.<br /> <br /> &#039;&#039;&#039;Scan first line only&#039;&#039;&#039;&lt;br&gt;<br /> This will cause the &#039;&#039;&#039;Scan&#039;&#039;&#039; function to scan just the first line for the field widths.<br /> <br /> &#039;&#039;&#039;Ignore separator in quotes (&#039;)&#039;&#039;&#039;&lt;br&gt;<br /> If checked, separator characters which are enclosed in single quotes will not be taken into account when scanning to determine column spacing for alignment. <br /> <br /> &#039;&#039;&#039;Ignore separator in double quotes (&quot;)&#039;&#039;&#039;&lt;br&gt;<br /> If checked, separator characters which are enclosed in double quotes will not be taken into account when scanning to determine column spacing for alignment.<br /> <br /> &#039;&#039;&#039;Keep delimiter with fixed columns&#039;&#039;&#039;&lt;br&gt;<br /> This indicates that when converting to fixed width columns the delimiter character for the fields should not be removed. If this is not checked, the conversion will remove the delimiter between fields.<br /> <br /> &#039;&#039;&#039;Separator character&#039;&#039;&#039;&lt;br&gt;<br /> This specifies the delimiter character between fields. If this is a tab character &quot;^t&quot; should be entered. In all other cases, a single character should be entered. The editor uses this character to determine the field boundaries.<br /> <br /> &#039;&#039;&#039;Field widths&#039;&#039;&#039;&lt;br&gt;<br /> This is a list of comma separated field widths used for the conversion. If there are more fields than entries, the last entry will be used as the field width for the remaining fields. This allows you to set a single entry if all fields are required to be the same width. <br /> <br /> Please note: This field must not be left empty when the conversion to fixed columns is executed. It may be populated automatically by pressing the &#039;&#039;&#039;Scan&#039;&#039;&#039; button after specifying the conversion options, or you can manually enter field widths if desired.<br /> <br /> &#039;&#039;&#039;Convert&#039;&#039;&#039;&lt;br&gt;<br /> This performs the conversion from character delimited text to fixed column according to the settings above. The complete file will be converted. Please note that this may take some time for larger files. <br /> <br /> &lt;div class=&quot;idm-see-also&quot;&gt;<br /> See also: <br /> * [[Convert fixed width to CSV]]<br /> &lt;/div&gt;</div>

Idmadmin