You are here: PSPad forum > English discussion forum > Re: Regular Expresion (Range + Integers only) CSV

Re: Regular Expresion (Range + Integers only) CSV

#1 Regular Expresion (Range + Integers only) CSV

Posted by: maki | Date: 2020-04-24 15:18 | IP: IP Logged

^([1-9]|[1-7][0-9]|80)$

Find Only Integer 1-80

Input:
123,80
1245,65
12329,80.3
12330,12.43103448
12331,114
12332,17.85714286
12333,27.10344828
12334,120.4285714
12335,27.44444444
12336,17.48076923
12337,13.75409836

"," - separator CSV cell

Shouldbe Output result:
65
80

Error: any Match NOT FOUND!

Edited 3 time(s). Last edit at 2020-04-24 15:20 by maki.

Options: Reply | Quote | Up ^


#2 Re: Regular Expresion (Range + Integers only) CSV

Posted by: pspad | Date: 2020-04-24 15:28 | IP: IP Logged

Any match found is correct according to you expression.

Options: Reply | Quote | Up ^


#3 Re: Regular Expresion (Range + Integers only) CSV

Posted by: maki | Date: 2020-04-24 15:32 | IP: IP Logged

Problem with "."
Works with ","

Integers Only support only "," (CSV)

I am looking for a workaround

Edited 1 time(s). Last edit at 2020-04-24 15:33 by maki.

Options: Reply | Quote | Up ^


#4 Re: Regular Expresion (Range + Integers only) CSV

Posted by: pspad | Date: 2020-04-24 15:38 | IP: IP Logged

Problem is with ^ char in your exoression

Options: Reply | Quote | Up ^


#5 Re: Regular Expresion (Range + Integers only) CSV

Posted by: maki | Date: 2020-04-24 16:14 | IP: IP Logged

Without "^"

However, there is still a problem with Integers Only

image

Number 15 and 13 - correct

Other Number Wrong

Edited 3 time(s). Last edit at 2020-04-24 16:19 by maki.

Options: Reply | Quote | Up ^






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