DosTips.com

hi Aacini, i think i figured it out! The mistake is about SPACING!!! Because in the data i posted over here is start from the beginning. thats why when you the space is 23 character to reach "user information" hence the code is like the following. if "!line:~23,16!" neq "Use...

This is to clarify for those who will use this as a reference for batch file processing.. The input data i provided in earlier post might be inaccurate( i didn't include option number and option text column ) for the actual batch file processing, hence i would like to explain in detail what the inpu...

Thanks Aacini and Foxidrive, really appreciate your help!! Yes, i am new to window scripting,I also knew that you have put in so much of effort.. So, i am trying to understand Aacini work to try to modify the require change.. However, would you able to enlighten me some of the code you wrote. It wil...

how about this, as i was refer to what you guys am helping me on.. i try to think about the pseudocode first for /f "delims=" %%a in ('type "file.txt" ^|find ". . :"') do ( :: print the line :: but if find "Menu information:" OR "Menu text" OR "...

sorry typo, type too fast.. btw, i am now working on try to filter off the content to reach what @Aacini has offered previously.. i am thinking to work in 2 step.. first with the raw data > filter off > become the input what Aacini has done > then run the code > output. (C) SRC Secure Solutions bv i...

Dear Foxidrive and Aacini, I am so pleased for your help.. the code work 98% which i was so happy.. @Aacini, I didn't aware that you will use the datai put in the post, and i thought u will use my dropbox one.. cause there is a missing part that didn't encode there but in the source file i uploaded ...

hi foxidrive, thanks for asking.. in fact, the output for column header of rc code, reviewer 1, reviewer 2, remark can be ignore.. i have done few manual output for reference.. thanks to ensure i didn't screw out the input file maybe u can use the dropbox version.. really appreciate ur help... input...

For the output in csv format can ignore rc code review1 review2 and remark.

hi,

changed.. sorry for the mistake..

i have provided the input and desired output files to dropbox. These are defintely the correct format
input
https://www.dropbox.com/s/mb8npfjkt95bkxy/input2.txt
output
https://www.dropbox.com/s/z20n9ob0b4lt49m/output.xls

Hope this round is clear the doubt.. i really appreciate all the effort u guys have provided..

sorry foxidrive, it is really my first time doing such task and i am not aware such thing will trouble u guys so much.. However, i dunno which way i can share the source data and desired output in a better way.. Plz enlighten me, so that in future request i will really ensure the source data is accu...

HI Squashman,

I am sorry and sincerely apologize as my boss didn't gave me a full picture at first

I hope the print screen will work for those who help me!!!..

As i am a beginner to tech forum.. I will definitely be more careful in the future post ...
Hope you guys dun mind...

input 3

http://www.flickr.com/photos/79704604@N03/7305702608/


output

http://www.flickr.com/photos/79704604@N03/7305702940/

many thanks

hi people, thanks for the help.. really appreciate as i cant attached a files here.. and copy and paste the source data will affect the format... hence i decided to do a print screen and put over here... I will share a fews link to showcase the inputs inputs 1 http://www.flickr.com/photos/79704604@N...

hi Aacini,

thanks for the help.. the code work for first part..
But when u look on my actual source file after that it seems doesn't has data in the output..

hhmm...
so could you assist me on this..
thanks