Greetings!!
This is output of third party application --
==================================================
Order : 1
IP Address : 123.123.123.123
Status : Succeed
Country : IJKL
Network Name : BCDEFGHI
Owner Name : LMNOPQ( SOMETHING SOMETHING)
From IP : 123.123.123.123
To IP : 123.123.123.123
Allocated : Yes
Contact Name : ABCD ABCD ABCD
Address : ABCD ABCD ABCD ABCD ABCD ABCD
Email : ABCD@ABCD.COM
Abuse Email : ABCD@ABCD.COM
Phone : +91-11-222222222
Fax : +91-11-222222222
Whois Source : ABCDEF
Host Name :
Resolved Name :
==================================================
==================================================
Order : 2
IP Address : 123.123.123.123
Status : Succeed
Country : ABCDEFGHI
Network Name : ABCDEFGHI
Owner Name : LMNOPQ( SOMETHING SOMETHING)
From IP : 123.123.123.123
To IP : 123.123.123.123
Allocated : Yes
Contact Name : LMNOPQ
Address : LMNOPQ( SOMETHING SOMETHING)
Email : ABCD@ABCD.COM
Abuse Email : ABCD@ABCD.COM
Phone : +91-11-222222222
Fax : +91-11-222222222
Whois Source : ABCDEFG
Host Name :
Resolved Name :
==================================================
Need to do the following on this --
1. Remove the space after the Heading name but before the colon as this
Order: 1
IP Address: 123.123.123.123
Status: Succeed
Country: ABCDEFGHI
2. Remove the separator lines.
Kindly help with a macro to do the same. If the input is not displayed as it should be please check the attached text file.
Best Regards,
Mahesh
Bookmarks