CODEWITHSUNDEEP
regexvimcsv
help
help

Reputation: 307

How to replace CSV column separators with numbered labels in Vim?

I want to replace a series of pipeline characters with different values. How would I do this with regular expressions?

Example:

This | is | a | sentence
And | this | is | the | second | one

Final result:

This new is new2 a new3 sentence
And new this new2 is new3 the new4 second new5 one

Upvotes: 2

Views: 401

Answers (2)

ib.
ib.

Reputation: 28964

If substitution values differ only in the numbers at the ends, use the command

:let n=[0] | %s/|/\='new'.map(n,'v:val+1')[0]/g

(See my answer to the question "gVim find/replace with counter" for detailed description of the technique.)

In case of substitution values that differ essentially from each other, change the command to substitute not a serial number of an occurrence, but an item of a replacement list with that number as an index.

:let n=[-1] | %s/|/\=['one','two','three'][map(n,'v:val+1')[0]]/g

To perform the substitutions on every line independently of each other, use the :global command to iterate one of the above commands through the lines of a buffer.

:g/^/let n=[0] | s/|/\='new'.map(n,'v:val+1')[0]/g

Similarly,

:g/^/let n=[-1] | s/|/\=['one','two','three'][map(n,'v:val+1')[0]]/g

Upvotes: 2

Fredrik Pihl
Fredrik Pihl

Reputation: 45662

Define a function:

fun CountUp()
  let ret = g:i
  let g:i = g:i + 1
  return ret
endf

Now, use:

:let i = 1 | %s/|/\="new" . CountUp()/g

Upvotes: 0

Related Questions