EDIFACT How to group, spilt, sort and sum up values from a EDI string into variables in VB.NET -

-

i new vb.net 2008. have tricky task resolve, regarding extracting characters (values) long string, extracted values text shall summed , sorted keywords, reformatted , saved csv file.

it looks longer :

unh+ram6957'company1by500c10'zew+reqest6957'company2sl200c20'company1sl300c10'zew

the values seperated ' .

as first step splitted string make readable, used function like:

dim lineoftext string   dim integer   dim arytextfile() string      lineoftext = p_edi     arytextfile = lineoftext.split("'")        = 0 ubound(arytextfile)         console.writeline((arytextfile(i)))       next

now result looks like:

unb+unoa:1+ccp:zew+ste:zew+100901:1200+2010917283 unh+m000001+ordrsp:d:96a:un:egt102 bgm+02g::zew+nomres24364+34 dtm+z05:0:805 dtm+137:201009011000:203 dtm+z01:201009090400201009100400:719 rff+ahi:gscompany1 nad+zso+ccp::zew nad+zsh+gsstatkraft::zew tdt+41g++70 loc+z11+:::ttf lin+1+23 loc+z11+:::ttf qty+z05:0:kw1 dtm+2:201009090400201009100400:719 nad+zus+gsbnp::zew lin+2+23 loc+z11+:::ttf qty+z05:0:kw1 dtm+2:201009090400201009100400:719 nad+zus+gsbpa::zew

so far good:

now have extract date , time header: line looks like:

**dtm+137**:201009011000:203 should dtm+137:2010.09.01-10:00:203 , store 'incomming_dtm' variable example

now message period interresting know: line looke like:

**dtm+z01**:201009090400201009100400:719 output should like: dtm+z01 2010.09.09-04:00, 2010.09.10-04:00 , store 'period_dtm' variable

as next step need parse next lines until reaches keyword lin like:

lin+1+23 loc+z11+:::ttf qty+z05:0:kw1 dtm+2:201009090400201009100400:719 nad+zus+gsbnp::zew nad+zsh+company1rph n001::zew (p character in word -> sell qty:0 kw/h)  lin+2+23 loc+z11+:::ttf qty+z05:0:kw1 dtm+2:201009090400201009100400:719 nad+zus+gsbpa::zew nad+zsh+company1rrh n001::zew (r character in word -> buy qty:0 kw/h)

and store keywords "qty" "dtm" "nad+zsh" , following characters variables.

then need parse until reaches next lin keyword , store keywords there vaiables again. goal of complicated exercise is, sum values of qty , nad+zsh+company1rvh , nad+zsh+company1rph

if have closer @ last zwo charaters in company1rrh , company1rph see rh , ph, rh means buy , ph means sell. maybe possible store buy or sell contract vaiable each lin?

i need sum sells , buys found in string. every lin marks time period of 1 hour, have 24 series per string contains 24 lin every lin have time period, buy or sell keywords , quantity.

can please me task?

as first step, storing keywords , follwoing characters variables start. might until parser reaches lin, store found values csv file or array?, parse until next lin , on...

i create csv file out of results like: csv should contain 24 records 1 per every hour per every lin..

dim csvdata = & "," & "traded_qty" & "," & dtm+z01 & "," & "n" & "," & qty & "," & "kwh/h" & "," & contract  console.writeline(csvdata)  creating csv file true flag -> append data csv.    dim csvfile string = "c:\test.csv"      dim outfile io.streamwriter = my.computer.filesystem.opentextfilewriter(csvfile, true)

any ideas highly welcome, consider complex task espacial new vb.net.

thank in advance!

i see "edi" in code. if edi format, should have, or able get, kind of edi specification. likely, fixed-length specification, meaning "value x characters 1 9", "value y characters 10 11", "value z character 12", etc.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more