Keyboard command to move between data columns

Keyboard command to move between data columns

1
NewbieNewbie
1

    Jul 11, 2011#1

    What is the keyboard command to move from the current position to the previous or next column when in column mode?

    6,603548
    Grand MasterGrand Master
    6,603548

      Jul 11, 2011#2

      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.