Reformat log file

heikki81, on Wednesday July 9, 2008 01:15:51 PM

Hello,

I've got a log that has to be reformatted in a better readable format. I can extract the ip properly, but not the port. Maybe you guys can help me.
example code:
10.0.0.2,"","OK","ServerName;H1313308;InstanceName;MSSQLSERVER;IsClu stered;No;Version;8.00.194;np;\\H1313308\pipe\sql\ query;tcp;4133;;"
10.0.0.3,"","OK","ServerName;PROWIN03;InstanceName;MSSQLSERVER;IsClu stered;No;Version;8.00.194;tcp;1433;np;\\PROWIN03\ pipe\\sql\query;;"
10.0.0.4,"","OK","ServerName;PROWIN07;InstanceName;MSSQLSERVER;IsClu stered;No;Version;8.00.194;tcp;1433;np;\\PROWIN07\ pipe\\sql\query;;"
10.0.0.9,"","OK","ServerName;PROWINDEV;InstanceName;MSSQLSERVER;IsCl ustered;No;Version;8.00.194;tcp;1433;np;\\PROWINDE V\pipe\\sql\query;;"
10.0.0.10,"","OK","ServerName;VDS-238462;InstanceName;MSSQLSERVER;IsClustered;No;Ver sion;8.00.194;tcp;1433;np;\\VDS-238462\pipe\\sql\query;;"
The correct format has to be:
ip:port
example from the first line:
10.0.0.2:4133

Thx in advance

Configuration: Windows XP
Internet Explorer 6.0

Reply to heikki81 Report this message to moderators Go to last message

1This message seems useful, vote!
This message does not seem useful, vote!
Report this message to moderators

mohsikhan89, on Wednesday July 9, 2008 01:54:31 PM

hi

Here a Windows XP/2K batch script
:: EDLOG.BAT Usage: EDLOG Log_File > Edited_Log
@echo off & setlocal EnableDelayedExpansion
for /F "tokens=1* delims=," %%a in ('type "%*"') do (
set ip=%%a
set port=%%b
set port=!port:*tcp;=!
set port=!port:"=!
for /F "tokens=1 delims=;" %%j in ("!port!") do set port=%%j
echo.!ip!:!port!
)
:: End_Of_Batch

Reply to mohsikhan89

Ask your question Reply

Results for

Monitor Log file useing DOC BATCH Hello, I want to monitor a log file of a service. If service is running normal then this get update in every 15min. So I want to monitor if the log file is getting updated in every 15min or not. If its not updating then it means service is not... en.kioskea.net/forum/affich-8373-monitor-log-file-useing-doc-batch

FAT16 ,32 logicalfile structures and operatio hi i need information about fat16,32 logical file structure and operation for an hard drive en.kioskea.net/forum/affich-4440-fat16-32-logicalfile-structures-and-operatio

Xp crash Hello, My xp professional has crashed. It will not let me go into safe mode or anything. It just keeps rebooting itself over and over. F8 doesn't work either. Whether I have the xp recovery disc in or not, it comes up "Cannot find log file... en.kioskea.net/forum/affich-20995-xp-crash

Voir les réponses

Results for

What are Cookies?Cookies are small files saved on your computer when you visit some web sites. They may contain things like passwords so you can log onto the site without entering again and again your login and password. They are not spy or dangerous programs but... en.kioskea.net/faq/sujet-3-what-are-cookies

Backup Outlook 2003 dataBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application... en.kioskea.net/faq/sujet-47-backup-outlook-2003-data

Exporting Display using the xdmcp commandExport Display using the xdmcp command Intro Gnome based system KDE based system Intro Here below is a brief explanation on how to log in remotely under graphic mode. Gnome based system Edit the following file:... en.kioskea.net/faq/sujet-803-exporting-display-using-the-xdmcp-command

Voir les réponses

Results for

Computer shuts off at random, the restarts.Hello, My computer suddenly started shutting off, then, after a second or two, restarting -- as if I turned it off and on. There are no error messages in the log files. In the BIOS, I set it not to restart, but it does. The only thing that shows up in... en.kioskea.net/forum/affich-27438-computer-shuts-off-at-random-the-restarts

Uninstall Jmicron drives - NO DVD DriveHello, Im having problems which ill post separately but i believe this may be part of the cause (as its is one of the 3 errors in the log files (jraid (9), cdrom (15) and disk(51)). Basically if i uninstall the Jmicron (raid?) drivers from xp on... en.kioskea.net/forum/affich-11864-uninstall-jmicron-drives-no-dvd-drive

Log file for share folder sessionHello, I have a working group with 5 computers, 1 pc works as data server and backup server,it has a share folder call backup,every midnight, all 5 computer backup their C: drive to backup folder by using norton ghost,the problem is sometimes some... en.kioskea.net/forum/affich-5266-log-file-for-share-folder-session

Voir les réponses

Results for

Download PHP Edit PHPEdit is an environment of inserted development (IDE) under Windows for language PHP. It gives a big number of functions allowing to develop more efficiently: Syntactic coloring Auto-complete of functions integrated Debugger PHP en.kioskea.net/telecharger/telecharger-140-php-edit

Download File SplitzFile Splitz is a Windows utility allowing splitting up all sorts of files in smaller pieces. Afterward you can recombine to reform the origin file. Cut the files of big sizes, of all types, in smaller fragments, next reform the original version with... en.kioskea.net/telecharger/telecharger-517-file-splitz

Download Filezilla ServerFileZilla Server is a waiter FTP for Windows developed there open source. It includes numerous functionalities such as the support of SSL, the possibility of taking back cancel downloads, management of directories,... en.kioskea.net/telecharger/telecharger-172-filezilla-server

Voir les réponses

Results for

Canada students file complaint against Facebook: mediaThe logo of social networking website 'Facebook' is displayed on a computer screen. Students at the University of Ottawa have filed an official complaint against Facebook, accusing the social networking website of violating Canada's... en.kioskea.net/actualites/canada-students-file-complaint-against-facebook-media-10420-actualite.php3

Updated Firefox browser eyes world download recordThis file photo shows the logo for Mozilla Foundation. Mozilla on Tuesday released an improved version of its Firefox web browser that has gained popularity as a free alternative to Microsoft's ubiquitous Internet Explorer. Mozilla on Tuesday... en.kioskea.net/actualites/updated-firefox-browser-eyes-world-download-record-10456-actualite.php3

Microsoft expands online business software servicesThis 27 December 2005 file photo shows the logo for Microsoft at their office in Herndon, Virginia. Microsoft announced Monday that it is expanding the range of business software it makes available as a service on the Internet. Microsoft announced... en.kioskea.net/actualites/microsoft-expands-online-business-software-services-10174-actualite.php3

Voir les réponses

Results for

Processes - mad - mad.exe mad.exe (mad stands for Microsoft System Attendant) is a Microsoft Exchange generic process which writes log files and manages address books. The process mad.exe is not in any way a virus, a worm, a Trojan horse, spyware, or adware. It is a process... en.kioskea.net/processus/mad-exe.php3

Attack detection - Monitoring event logs One of the best ways to detect intrusions is to monitor event logs (sometimes called logs for short). In general, servers store logs of their activity, and in particular any errors encountered, in files. Therefore, after a computer attack, it is rare... en.kioskea.net/detection/surveillance-journaux-logs.php3

Attack detection - Analysing logs One of the best ways to detect intrusions is to monitor event logs (sometimes called logs for short). In general, servers store logs of their activity, and in particular any errors encountered, in files. Therefore, after a computer attack, it is rare... en.kioskea.net/detection/detection-attaques-reseau.php3

Voir les réponses