|
9
|
DonationCoder.com Software / Post New Requests Here / Re: CSV/Excel Parsing & Formatting Utility
|
on: April 25, 2012, 04:44:47 PM
|
|
last thing if we type Missing Dialogue with PGNO1 PGNO2 PGNO3 and so on as they are refering to page numbers is that possible these Page numbers will go directly to the page number field ? just numbers not the PGNO just numbers after that so it will be like if we have a missing dialogue to save time to do things manually we will mention that this missingdialogue is on page number this and that it will take the Time Code in and out with actor name and put the page number to page number field like this EP Page NO TIME IN TIME OUT ACTOR ............................. 6 2 05 , 45 , 11 05 , 47 ,25 Ayla
hope you understand .. Regards
|
|
|
|
|
11
|
DonationCoder.com Software / Post New Requests Here / Re: CSV/Excel Parsing & Formatting Utility
|
on: April 25, 2012, 09:00:22 AM
|
yep  i am very happy its just work fine .. can make error report manually ... and can get froma csv file with in a jiffy it looks like a pro tool to me . with every thing one need .. ath can you add this thing also if in any place something like (Song............) written it will take it as song and mark as song in excel format ... thr will be more than 6 dots which will indicate that how long song is ... and it will be inside the () Thanks
|
|
|
|
|
13
|
DonationCoder.com Software / Post New Requests Here / CSV/Excel Parsing & Formatting Utility
|
on: April 23, 2012, 05:54:01 PM
|
|
Hello i have a csv file which has 4 columns Time in , Time out , Name , Text "00:04:37:08","00:04:38:20","AYLA","May I take my phone back Duran?",
now what i want that .. i also have a excel file which has many columns .. few with TC IN .. TC OUT Actor name what i want is to have tool in which i import the csv file and where ever the text Missing dialogues or Missing Dialogue or Missing Dialogue! or Missing Dialogues! come like this one "00:10:24:16","00:10:25:11","DÜRİYE","missing dialogue!",
it copy the Time in code to my excel TC IN Column and Time out to TC OUT Columnn And as Duriye is actor name it copy that Name to Actor Name column that is all and so on just check the line 1 by one where ever it comes it gives me the result on that excel format check the samples Thanks
|
|
|
|
|
22
|
DonationCoder.com Software / Post New Requests Here / Text Parsing and Output ( Result in Excel, load multiple DOC,RTF,Word Files )
|
on: March 10, 2012, 03:25:28 PM
|
|
Hello Donation Coder I need a Text Parsing Tool which import Word Files like RTF DOC DOCX and give result in Excel after calculation of NO of total lines spoken by per actor read below for description (see attached file for out put result and also one one SCRIPT is attached Script i means Drama script).
This tool is used to import any script or scripts upon wish and it gives us the number of lines for all the actors with the option of removing (reac) and other things. and it gives us an excel file with the actor name on the left and the lines per episode.
( many actor names are very large do check them )
Example: If the actor name is not followed by a sentence then the whole line doesn't count.
It must not count the lines which just have only reactions which are inside ( ) ... if there are dialogues contain these reactions it must count them.. but need to have some option to remove any thing inside the ()
well scripts are in DOC RTF DOCX format .... and each word file is 1 episode need to follow the same script format which is attached and its i rtf format but need the tool to load and calculate from any word file in the attached excel file ....personges (French word which means Actor) are actors name taken from the script automatically ... just skip commediens row as we have put the row containing different actor names manually ... in episodes you can see number of episodes ... example very first actress is rosy she has spoken 20 lines in episode 40 and so on .. and after it gives total number of lines spoken by rosy from episode 40 to 60 i think it can be on .net with office integration or what ever best you people think ... can code in any programming language...
i am not sure if i am allowed to put my msn id .. but if i am doing wrong Admin you can edit the post .. my msn id is princesssaira at hotmail.com if any more information needed can contact me Thanks
|
|
|
|
|