What is the keyboard command to move from the current position to the previous or next column when in column mode?
What? Key LEFT and RIGHT move the caret one character (= column as shown in status bar at bottom) left and right.
Or do you have a CSV file opened with tab as delimiter or already converted to fixed column width and you want to move the caret to begin of previous or next data field?
Well, for the text editor UltraEdit ALL files are just text files. There is no special content based arrangement of the data in a file defined by content or file extension like in spreadsheet or database applications.
The keys Ctrl+Left and Ctrl+Right move the caret left or right to beginning of previous or next word as in most Windows applications displaying text.
If you often work with CSV files with tab as delimiter, you could use two macros with hotkeys assigned stored in a macro file being set to be automatically loaded on start of UltraEdit.
Macro PrevDataColumn
IfColNumGt 1
Loop
Key Ctrl+LEFT ARROW
IfColNum 1
ExitLoop
EndIf
Key LEFT ARROW
IfCharIs 9
Key RIGHT ARROW
ExitLoop
EndIf
EndLoop
EndIf
Macro NextDataColumn
IfEof
ExitMacro
EndIf
IfCharIs 13
ExitMacro
EndIf
IfCharIs 10
ExitMacro
EndIf
Loop
Key Ctrl+RIGHT ARROW
IfCharIs 13
ExitLoop
EndIf
IfCharIs 10
ExitLoop
EndIf
IfEof
ExitLoop
EndIf
Key LEFT ARROW
IfCharIs 9
Key RIGHT ARROW
ExitLoop
EndIf
Key RIGHT ARROW
EndLoop
The tab character has decimal value 9. This value can be modified for other delimiters. The macros are designed to stop moving the caret on beginning or end of current line.
Please note that macro NextDataColumn would interpret a line-feed (decimal value 10) without a preceding carriage return (decimal value 10) also as "end of line" even with configuration setting Only recognize DOS terminated lines (CR/LF) as new lines for editing enabled and option Never prompt to convert files to DOS format selected above to get data fields with line breaks inside a field displayed correct. Microsoft applications usually store line breaks inside a data field with line-feed only without a preceding carriage return while end of data row is always stored with carriage return plus line-feed.
Or do you have a CSV file opened with tab as delimiter or already converted to fixed column width and you want to move the caret to begin of previous or next data field?
Well, for the text editor UltraEdit ALL files are just text files. There is no special content based arrangement of the data in a file defined by content or file extension like in spreadsheet or database applications.
The keys Ctrl+Left and Ctrl+Right move the caret left or right to beginning of previous or next word as in most Windows applications displaying text.
If you often work with CSV files with tab as delimiter, you could use two macros with hotkeys assigned stored in a macro file being set to be automatically loaded on start of UltraEdit.
Macro PrevDataColumn
IfColNumGt 1
Loop
Key Ctrl+LEFT ARROW
IfColNum 1
ExitLoop
EndIf
Key LEFT ARROW
IfCharIs 9
Key RIGHT ARROW
ExitLoop
EndIf
EndLoop
EndIf
Macro NextDataColumn
IfEof
ExitMacro
EndIf
IfCharIs 13
ExitMacro
EndIf
IfCharIs 10
ExitMacro
EndIf
Loop
Key Ctrl+RIGHT ARROW
IfCharIs 13
ExitLoop
EndIf
IfCharIs 10
ExitLoop
EndIf
IfEof
ExitLoop
EndIf
Key LEFT ARROW
IfCharIs 9
Key RIGHT ARROW
ExitLoop
EndIf
Key RIGHT ARROW
EndLoop
The tab character has decimal value 9. This value can be modified for other delimiters. The macros are designed to stop moving the caret on beginning or end of current line.
Please note that macro NextDataColumn would interpret a line-feed (decimal value 10) without a preceding carriage return (decimal value 10) also as "end of line" even with configuration setting Only recognize DOS terminated lines (CR/LF) as new lines for editing enabled and option Never prompt to convert files to DOS format selected above to get data fields with line breaks inside a field displayed correct. Microsoft applications usually store line breaks inside a data field with line-feed only without a preceding carriage return while end of data row is always stored with carriage return plus line-feed.
