extract only two columns

kellyyer

hello guys, I was reviewing several solutions to have only two groups which are separated by ¡, but I have not succeeded, I need group or column 19 and 20, my file is large, I show you an example,

spell-class¡“.instant.ProjectileSpell”¡name¡explosivearrow¡spell-icon¡arrow¡description¡Cause¡an¡explosion¡where¡an¡arrow¡lands¡cast-item¡blaze_rod¡cooldown¡1¡projectile¡arrow¡velocity¡0¡require-hit-entity¡false¡cancel-damage¡true¡remove-projectile¡true¡max-distance¡30¡spells¡[explode]

I need these two columns
projectile¡arrow
Can anyone help me?

Scott Sumner

@kellyyer

So the comma character is a more-common delimiter than yours, but if you replace every comma in the following with your special delimiter, this should work or at least get you started:

Invoke Replace (press ctrl+h).
Find what zone: (?-s)^(?:.+?,){18}(.+?,.+?),.+ <–again replace every comma here!
Replace with zone: \1
Search mode: Regular expression
Action: Press the Replace All button

I encourage you to read about regular expressions, some ways to get started here. Try the above expression in some of the interactive regex sites to see how it works. Perhaps you will end up with a new technique in your data manipulation arsenal.