by Vitaly, Monday, May 16th, 2016
Opt-In List Manager 1.2.77 has been released.
What’s New
Extract And Clean->Clean Mail Lists: Capitalize First Letters.
This feature allows to capitalize the first letter of each word and lowercase the rest when words are separated by ” ” or “.” or “,” or any of those combined like “, ” “. ” etc.
Tags: Capitalize, Fields, Format, List
by Vitaly, Tuesday, April 12th, 2016
Opt-In List Manager 1.1.72 has been released.
What’s New
- Extract And Clean: “Reorder/Remove Fields” box allows up to 40 columns instead of 20.
- Filter/Keep Address, Join Lists and other tools allow up to 40 fields instead of 20.
- You can specify columns range using a ‘-‘ (example: 5-10).
Tags: Columns, Fields, Reorder
by Vitaly, Friday, March 25th, 2016
Opt-In List Manager 1.1.71 has been released.
What’s New
Added option “Sort Lists”->”Count Duplicates”.
Example
Source list:
user1@gmail.com,FirstName1,LastName1
user2@gmail.com,FirstName2,LastName2
user1@gmail.com,F1,L1
Output without “Remove Duplicates“:
2,user1@gmail.com,FirstName1,LastName1
2,user1@gmail.com,F1,L1
1,user2@gmail.com,FirstName2,LastName2
Output with “Remove Duplicates“:
2,user1@gmail.com,FirstName1,LastName1
1,user2@gmail.com,FirstName2,LastName2
Tags: Count, Duplicates, Sort
by Vitaly, Monday, February 15th, 2016
Accurate regular expression to match IPv4 address:
((([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))\.){3}(([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))
Tags: IPv4, Regular Expression
by Vitaly, Friday, February 12th, 2016
Web Proxy Checker Pro 1.8.46 released.
What’s New
Added support of MySQL databases.
Format of the MySQL source path:
mysql://connection_name/table_name/column1,column2,...[delimiter]/where_statement
Format of the MySQL output path:
mysql://connection_name/table_name/column1,column2,.../value1,value2,...
You can read more about MySQL source/output path formats here: MySQL Support (AV)
Output Values
- :$host – proxy host
- :$port – proxy port
- :$type – proxy type (https, socks4, socks5)
- :$user – proxy user name
- :$pass – proxy password
- :$extip – external IP address
- :$ccode – country code
MySQL Connections
Load from MySQL Table
Save to MySQL Table
Tags: MySQL, SQL
