extract only two columns
-
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? -
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 buttonI 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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login