Function to convert IP Address w.x.y.z to integer? #4063
-
|
I'd like to import a file of IPv4 addresses in the form w.x.y.z (e.g. 192.168.1.1) and convert them to the corresponding value as an integer. Does anyone have a function that can do this? Many thanks. PS I have seen the reverse function (integer -> string) many places, for example: https://sqlite-users.sqlite.narkive.com/mC4pSHS7/convert-integer-ip-address-to-string-ip-address-in-sqlite |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 6 replies
-
|
You can go to SQLiteStudio's custom functions (https://github.com/pawelsalawa/sqlitestudio/wiki/User_Manual#custom-sql-functions) and add these functions: https://github.com/pawelsalawa/sqlitestudio/wiki/Qt_script_ip2int Remember that such functions work only when you operate on the database from the SQLiteStudio. If you want such functions in your own application using SQLite, you need to register & implement them in your application. |
Beta Was this translation helpful? Give feedback.
-
|
This is great! It definitely makes me hit the Donate button! :-) Thanks. |
Beta Was this translation helpful? Give feedback.
-
|
A follow-on question: How can I find other functions that have been created? I'm teaching myself SQL, and this is a fun tool! |
Beta Was this translation helpful? Give feedback.
-
|
I understand you're asking for a SQLite built-in functions. These are listed & described at https://sqlite.org/lang_corefunc.html and its subpages. |
Beta Was this translation helpful? Give feedback.
-
|
I know about the SQLite built-in functions. I was looking for a list of the other goodies that you or others have created, similar to ip2int and int2ip... Thanks. |
Beta Was this translation helpful? Give feedback.
-
|
I see. There is not a lot of it, but there is a little bit: |
Beta Was this translation helpful? Give feedback.
-
|
Perfect! I wonder how I could have found that pagemyself? Perhaps the SQLiteStudio's custom functions page (https://github.com/pawelsalawa/sqlitestudio/wiki/User_Manual#custom-sql-functions) could have a link? Thanks again |
Beta Was this translation helpful? Give feedback.
-
|
It's available directly from the main wiki page: https://github.com/pawelsalawa/sqlitestudio/wiki Still, it's a good idea to add it where you suggested and I will do it in a moment. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks, again! |
Beta Was this translation helpful? Give feedback.
You can go to SQLiteStudio's custom functions (https://github.com/pawelsalawa/sqlitestudio/wiki/User_Manual#custom-sql-functions) and add these functions:
https://github.com/pawelsalawa/sqlitestudio/wiki/Qt_script_ip2int
https://github.com/pawelsalawa/sqlitestudio/wiki/Qt_script_int2ip
Remember that such functions work only when you operate on the database from the SQLiteStudio. If you want such functions in your own application using SQLite, you need to register & implement them in your application.