We’ve posted a new Expert Spotlight! Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.
regex code,How to do this?include and exclude chars?
I use this tool,Word List Updater 2.7:
All i want is to filter(exclude) all email domains and this type of chars: ®©�ØÇÖÄüèöµÃ‖｜¦ and include this: :^/\\,.+ .;
The code bellow exclude this too: ^/\\,.+:;
This is my list i want to filter:
so the final list must look like this:
All i want is to filter(exclude) all email domains and this type of chars: ®©�ØÇÖÄüèöµÃ‖｜¦ and include this: :^/\\,.+ .;
The code bellow exclude this too: ^/\\,.+:;
^[^/\\{«»„““”‘’|\n\t….,;`^"<>'}+:?®© �ØÇÖÄüèöµÃ ‖｜¦]*$
This is my list i want to filter:
john>123
john:123
john;123
john/123
john@123
john!123
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
èáàúùóò
acan
itoh
ö
ü
｜
‖
Ã
Ä
Ö
Ç
Ø
RE
�^�O�OsG���
w���n���
john-123
john_123
marcy
µ
john
marcy
michael
test
&lt;
&lt
&gt;
&gt
&lt;&gt;
&
&
�
^
��
¦
johnny$1234
john~123
john)123
john(123
so the final list must look like this:
john>123
john:123
john;123
john/123
john@123
john!123
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
acan
itoh
RE
john-123
john_123
marcy
john
marcy
michael
test
^
johnny$1234
john~123
john)123
john(123
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
no no doesn't work this is the rez. plz try to use same tool as mine is easy to find and clean
john/123
test:123
test;123
john@123
john!123
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
èáàúùóò
acan
itoh
ö
ü
｜
‖
Ã
Ä
Ö
Ç
Ø
RE
�^�O�OsG���
w���n���
john-123
john_123
marcy
µ
john
marcy
michael
test
&lt;
&lt
&gt;
&gt
&lt;&gt;
&
&
�
^
��
¦
johnny$1234
john~123
john)123
john(123
Try the following code.. it works based on your input and output data posted in the question..
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?)).*([$>:;/@!#%^=*&+\\\-_$~)(]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$"} | Out-File C:\temp\output.txt
ur result, this must desseapear too: �^�O�OsG���
and this 2 lines too:
john@yahoo.com
john@live.com
can handle huge txt files right? 8-10 gb?
I added 2 new lines, 2 emails...so no emails
and this 2 lines too:
john@yahoo.com
john@live.com
can handle huge txt files right? 8-10 gb?
I added 2 new lines, 2 emails...so no emails
john/123
test:123
test;123
john@123
john@yahoo.com
john@live.com
john!123
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
�^�O�OsG���
john-123
john_123
^
johnny$1234
john~123
john)123
john(123
Try..
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?|�)).*([$>:;/@!#%^=*&+\\\-_$~)(]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$"} | Out-File C:\temp\output.txt
si final final list must look like this
Input list:
output list:
---------------
Input list:
john/123
test:123
test;123
john@123
john!123
john@yahoo.com
john@live.com
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
èáàúùóò
acan
itoh
ö
ü
｜
‖
Ã
Ä
Ö
Ç
Ø
RE
�^�O�OsG���
w���n���
john-123
john_123
marcy
µ
john
marcy
michael
test
&lt;
&lt
&gt;
&gt
&lt;&gt;
&
&
�
^
��
¦
johnny$1234
john~123
john)123
john(123
output list:
---------------
john/123
test:123
test;123
john@123
john!123
john#123
john%123
john^123
john=123
john*1
john&1
john+1
john\123
acan
itoh
RE
john-123
john_123
marcy
john
marcy
michael
test
johnny$1234
john~123
john)123
john(123
Try..
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?|�)).*([$>:;/@!#%^=*&+\\\-_$~)(]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$" -and $_ -notmatch '\w+@\w+\.\w+'} | Out-File C:\temp\output.txt
yes yes perfecttt just wondering to be everything perfect can u do this too modify a bit ur script? :
1.handle huge files? (10-20-50 gb) ?
2.can u remove extra spaces?
3.can u remove duplicates from huge files using this regex?
for example,input:
output:
------------
1.handle huge files? (10-20-50 gb) ?
2.can u remove extra spaces?
3.can u remove duplicates from huge files using this regex?
for example,input:
john
john
john^123
money
carlos 123
marcos 123
john&123
john&123
output:
------------
john
john^123
money
carlos123
marcos123
john&123
1.handle huge files? (10-20-50 gb) ?Not sure, I have not tested it..
2.can u remove duplicates from huge files using this regex?
3.can u remove extra spaces?
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?|�)).*([$>:;/@!#%^=*&+\\\-_$~)(]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$" -and $_ -notmatch '\w+@\w+\.\w+'} | %{$_.Trim()} | Select -Unique | Out-File C:\temp\output.txt
doesn't work,can't see :
input
-------
output(this 3 liens doesn't appear ):
----------
input
-------
money
carlos 123
marcos 123
output(this 3 liens doesn't appear ):
----------
money
carlos 123
marcos 123
Try..
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?|�)).*([$>:;/@!#%^=*&+\\\-_$~)(\s]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$" -and $_ -notmatch '\w+@\w+\.\w+'} | %{$_.Trim()} | Select -Unique | Out-File C:\temp\output.txt
i can see in ur snapshot :
carlos 123
marcos 123
i want:
carlos123
marcos123
no extra spaces at all
My output is this,i used ur last string:
carlos 123
marcos 123
i want:
carlos123
marcos123
no extra spaces at all
My output is this,i used ur last string:
john/123
test:123
test;123
john@123
john^123
john!123
john#123
john%123
john=123
john*1
john&1
john+1
john\123
acan
itoh
RE
john-123
john_123
marcy
john
michael
test
^
johnny$1234
john~123
john)123
john(123
Try..
GC C:\temp\input.txt | ?{$_ -match "^(?!(&|\?|�)).*([$>:;/@!#%^=*&+\\\-_$~)(\s]).*(?<!;)$|^[a-zA-Z].*[a-zA-Z]$" -and $_ -notmatch '\w+@\w+\.\w+'} | %{$_.Trim() -replace "\s"} | Select -Unique | Out-File C:\temp\output.txt
Oh my God!!!!!!!!!!! hard work uhh u have steel nervs Subsun mmm it seems to remove also duplicates,amazing i just hope to handle HUGE txt files like 8 gb or 20 gb i will test tomorrow with huge txt files i hope to work fine
Premium Content
You need an Expert Office subscription to comment.Start Free Trial