Search results

  1. L

    Merging two csv files into one

    Thank you for your kind answer. However, there is one thing misunderstood that might make things easier to understand. The intent of merging these two files is to create one import file to a program that is going to assign each "column" to a different table column. Thus, without maintaining keys...
  2. L

    Merging two csv files into one

    So I have two csv files that have a common key. gnu join by itself can produce lines of output for records which have a common key. What I would love to have happen, however, is when I use the -a 1 -a 2 , the program produce -e's values for each field of the merged output for the missing line...
  3. L

    Massaging text files

    I have a file with this format: Title 1 - Character Name - Character Name2 - CharacterB Name3 Title 2 - Character Name2 Title 3 - CharacterC Name4 and what I would like to end up with is a file like this: Character Name,Title 1 Character Name 2,Title 1,Title 2 CharacterB Name 3,Title 1...
  4. L

    vi map help sought

    I ended up building a gawk script that did what I was trying to accomplish. Thank you for verifying that the issue wasn't just one of me not understanding vi enough.
  5. L

    vi map help sought

    I was working with nvi, and had the problems I mentioned above - seems like vim has reproduced limitations from other vi's. My choice would have been to fix that stuff in vim - but perhaps the engine that executes commands just isn't complex enough to solve the issue. Maybe I will see if I...
  6. L

    vi map help sought

    My goal is to do the following vi actions in a map Find the 4th (or 5th if necessary) occurrence of the | symbol add to - or change - the letters between the 4th and 5th | symbols to XXX Seems like it would be simple. However, map Q 4f|lcwXXX^[ where the real command ends in an escape...
  7. L

    Trying to "accumulate" data - looking for help

    I have a data file of the basic form: aaa1 -> b -> c bbb2 -> b ccc3 -> d and what I want as a result is something like b,aaa1,bbb2 c,aaa1 d,ccc3 So I am trying this code: typeset -A CI if [ "$#" -eq 0 ] ; then echo "USAGE: $0 input_file" >&2 exit 1 fi prefix="--*> " exec <...
  8. L

    trying to solve a problem and looking for help

    trying to solve a problem and looking for help
Top