Write a perl or VB script to scan a large text file and extract some information.

Completed Posted Oct 9, 2015 Paid on delivery
Completed Paid on delivery

Need a script to run on windows that will scan a large text file containing plain text and some <XML> tags. It should read the text file and save the required content within the XML tags to a new file delimited by comma. There will be two separate identifier within the XML SOAP message, hence the values for each XML tags should be saved in two separate files based on the SOAP message identifier. It should also search for matching values within the file and matching records should be saved to a new file.

Below requirement details with some example might help you understand what needs to be done. Please provide the script with a your test file so that I can run it and verify before making the changes of some values to match my file and run it again.

Requirement/example:

1. First SOAP message format: <S:envelope xmlns……..><bn2:submitRequest xmlns:bn2=“http……><tag1>abc</tag1><tag2>def</tag2><tag3>ghi</tag3>……

Please note the SOAP message identifier here is <bn2:submitRequest ….

search the .txt file and save values of SOAP message XML tags to a test file as follows:

One Heading using all common tags, then all values delimited by comma:

Heading: tag1,tag2,tag3,……

Values : abc,def,ghi

jkl,mno,pqr

stu,vwx,yza

The above results should be saved as filename: [url removed, login to view]

2. Second SOAP message format <S:envelope xmlns……..><bn2:submitResponse xmlns:bn2=“http……><tag1>abc</tag1><tag2>def</tag2><tag3>ghi</tag3>……

Please note the SOAP message identifier here is <bn2:submitResponse ….

Search the .txt file and save values of SOAP message XML tags to a test file as follows:

One Heading using all common tags, then all values delimited by comma:

Heading: tag1,tag2,tag3,……

Values : abc,def,ghi

jkl,mno,pqr

stu,vwx,yza

The above results should be saved as filename:: [url removed, login to view]

Use all values for <tag1> (there will be about 1000 tag1 values within SumitRequest) from step 1 to search for matching values of <tag1> in step 2. If a match is found i.e. <tag1> from step 1=<tag1> from step 2 (numeric value) (there will be about 1000 tag1 values within SumitResponse) then use the value of <tag2> from step 1 and search the file to find a string e.g “MESSAGE” and once string “MESSAGE” is found then start finding a match for <tag2> from the next line of "MESSAGE" string. The value of tag2 will be something like "FIELD20: <tag2 value>". If value of <tag2> from step 1 is matched with the value of Field20: <tag2 value> then search the values of step 2 to find if <tag3> contains a value of “1” for <errorcode> i.e <errorcode>1</errorcode> (tag3 changed to errorcode1). If it matches then find the matching <tag1> from step 1 and save all values of SubmitRequest within the soap message to a new file called [url removed, login to view]

I hope it makes sense. If not please ask questions before starting the work. Also, this task is very urgent so if you cannot do it within next 12 hours then please do not bid. Payment will be only made if the script to extract the expected result is provided.

It is to be run on a windows PC so either VBscript or a perl script will be ideal option.

Thank you

Perl Visual Basic

Project ID: #8650429

About the project

15 proposals Remote project Active Oct 9, 2015

Awarded to:

GeniuSBraiN

Hello, I can do the job in less time, and 100% accurate - I'm a Visual Basic programmer, I write programs in VB6 since 2007, in VB.Net since 2014. - Have long experience with winsock applications, FTP connections, More

$85 AUD in 3 days
(0 Reviews)
0.0

15 freelancers are bidding on average $137 for this job

gangabass

I'm one of the best Perl developers here and I'm expert in data processing/parsing that's why I'm sure you'll be impressed with my work. I can create Perl program will will process your text file and extract data you More

$133 AUD in 2 days
(184 Reviews)
6.1
dims

Hello, I prefer Perl and have a lot experience here. I work with large files and good in RegExp Regards, Dmitry

$130 AUD in 5 days
(131 Reviews)
6.2
freelance4hire80

hi, I can write a Perl script to run from window for this project please provide sample input xml files and output files (tab delimiter/csv) to get started

$133 AUD in 1 day
(42 Reviews)
6.2
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready More

$147 AUD in 9 days
(6 Reviews)
6.2
techvolcano

Hello, We are experts in perl. We can write this script for you. Ready to give u a demo. Thanks.

$100 AUD in 3 days
(132 Reviews)
5.9
mantumalakar10

Hello, I will create this project using vb so please contact me , I can finish this program in 12 hrs. so dont worry just contact me and send me some demo text file . Regards, Mantu

$83 AUD in 3 days
(11 Reviews)
3.7
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$166 AUD in 5 days
(6 Reviews)
3.4
pnjadhav

A proposal has not yet been provided

$277 AUD in 5 days
(1 Review)
2.1
rohitkarwa

A proposal has not yet been provided

$166 AUD in 2 days
(0 Reviews)
0.0
juanzapico

Is Perl or VB required on this project? If not I can do this via Java or Python but I will prefer java since its faster. I can create a simple UI for you so you can browse the xml file and the output file for convenien More

$155 AUD in 3 days
(0 Reviews)
0.0
jazarie2

proposed using nodejs, application will be windows friendly and cross platform. single line deployment.

$111 AUD in 3 days
(0 Reviews)
0.0
pynetvn

A proposal has not yet been provided

$94 AUD in 0 days
(0 Reviews)
0.0
godwinay

I need both a sample input file and its expected result to get me started the project. Thanks.

$100 AUD in 1 day
(0 Reviews)
0.0