Käynnissä

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

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

Taidot: Perl, Visual Basic

Näytä lisää: what is string matching, what is a search string, vb note, text string search, string matching in c, starting with visual basic, some search string, search text string, need a help to write a will, matching string, find perl, finding matches, finding match, c# read and write text file, common string, vb script process large text file, read large text file vb script, import text file excel vb script, extract lines text file perl, extract column text file find number times appears perl, exporting text file excel vb script, perl mysql script log output text file, perl script extract data text file, extract entries text file perl, html file script add information text file

Tietoa työnantajasta:
( 0 arvostelua ) Sydney, Australia

Projektin tunnus: #8650429

Myönnetty käyttäjälle:

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, Lisää

85 $ AUD 3 päivässä
(0 arvostelua)
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 Lisää

133 $ AUD 2 päivässä
(184 arvostelua)
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 5 päivässä
(131 arvostelua)
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 1 päivässä
(42 arvostelua)
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 Lisää

147 $ AUD 9 päivässä
(6 arvostelua)
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 3 päivässä
(132 arvostelua)
5.9
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Lisää

100 $ AUD 3 päivässä
(7 arvostelua)
3.8
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 3 päivässä
(11 arvostelua)
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 5 päivässä
(6 arvostelua)
3.4
pnjadhav

A proposal has not yet been provided

277 $ AUD 5 päivässä
(1 arvostelu)
2.1
rohitkarwa

A proposal has not yet been provided

166 $ AUD 2 päivässä
(0 arvostelua)
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 Lisää

155 $ AUD 3 päivässä
(0 arvostelua)
0.0
qprotex

Dear Client, My name is Miguel Febres and you can find my CV and Certificates in the following links: [url removed, login to view] [url removed, login to view] Lisää

166 $ AUD 1 päivässä
(0 arvostelua)
0.0
jazarie2

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

111 $ AUD 3 päivässä
(0 arvostelua)
0.0
pynetvn

A proposal has not yet been provided

94 $ AUD 0 päivässä
(0 arvostelua)
0.0
godwinay

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

100 $ AUD 1 päivässä
(0 arvostelua)
0.0