You are here: PSPad forum > English discussion forum > How to extract the number of instances of a given number from 01 to 80 in separate lines

How to extract the number of instances of a given number from 01 to 80 in separate lines

#1 How to extract the number of instances of a given number from 01 to 80 in separate lines

Posted by: maki | Date: 2019-07-01 21:19 | IP: IP Logged

How to extract the number of match of a number from 01 to 80 in separate lines:

Example:

Input:
01
01
01
01
01
02
02
03
03
03
04
05
06
06
06
06
06
06
06
06
...

Output (CSV Comma Separated):
01,05
02,02
03,03
04,01
05,01
06,05

image

Edited 3 time(s). Last edit at 2019-07-01 21:25 by maki.

Options: Reply | Quote | Up ^


#2 Re: How to extract the number of instances of a given number from 01 to 80 in separate lines

Posted by: Stefan | Date: 2019-07-02 07:22 | IP: IP Logged

maki:
How to ...

You have to write a script for that (or find a dedicated tool)

 

 

 

--
Stefan (pleased user since 1722)
Do you know you can spend Jan a beer? (click here)
Inofficial FAQs + Infos + Special Settings

Options: Reply | Quote | Up ^


#3 Re: How to extract the number of instances of a given number from 01 to 80 in separate lines

Posted by: maki | Date: 2019-07-02 10:50 | IP: IP Logged

Stefan - There are thousands of different tools on softpedia.com, but I have not found a single tool that would allow different manipulations on numbers.

Options: Reply | Quote | Up ^


#4 Re: How to extract the number of instances of a given number from 01 to 80 in separate lines

Posted by: maki | Date: 2019-07-02 11:02 | IP: IP Logged

Or maybe add two options:
Multiline RegEx AND Multiline None and MultiCount Matches

Edited 1 time(s). Last edit at 2019-07-02 11:02 by maki.

Options: Reply | Quote | Up ^


#5 Re: How to extract the number of instances of a given number from 01 to 80 in separate lines

Posted by: Vany | Date: 2019-07-04 06:58 | IP: IP Logged

use Pivot tables in some spreadsheet if you don't mind to script it by yourself

--
Vany
(PSPad 5.5.1.812 x32, W10h/p x64 en/cs)

Options: Reply | Quote | Up ^






Editor PSPad - freeware editor, © 2001 - 2024 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR