hello please..,

i have a 4 lines of data (as below) in my source file

"DIAL" "MENENT" "NOBLENT NAME" "NETRK" "PDUCT" "PDUCT" "MTH" "EBC" "EBC NAME" "INV#" "INV COST" "INVUNTS" "TOTAL" "ACC"...

I am using this to write from variable to a file

Using writer As StreamWriter = New StreamWriter("C:\myfile.txt")

...

Hello Cozy,

its about 200 kb (around 7000 records in it)

thanks & Regards

asita

Hello Rjv,

thanks alot for your code, it gave me good idea , and i substituted in my code it is working fine

so now i have the whole cleaned data in...

Hello All,

with all your suggestions, i did like this

i left at one more thing that is how can i substitute comma between each field,

at present my data looks like...

Hi Phil

thank you very much to all for your valuable responses.

but seems to be phill is exactly matches what i am thinking(as of my knowledge also it is simple...

please share any ideas

please

thanks

asita

Hello Rjn,

Thanks for your reply, i know program a little bit , but not my main stream so could you please give some sample or some example or could you...

thanks rex for your idea, i will try that and let you know once i done

Thanks Steve thats wonderfull i will test it

i greatfull to you

Thanks a ton

asita

Thanks Steve,

Could you please Give me one simple exam how to enforce through a trigger

let say for ex: Dept View (Dept#, Name)

and table is Emp (empid, Name, Dept#)

now how can...

hello coldcoffee,

Thank you very much for yoyr help,

i tried it but it says this error

EXEC MASTER.SYS.XP_CREATE_SUBDIR 'c:\Temp\t1\midcap1\Eelzer24\'

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement'...

Could you assist me

can we send the table data as a message is it possible?

please...............

with help of palmen i did this it is working fine here

SELECT mcode,

SUM(CASE WHEN stname = 'Prescription' THEN TotalDocs ELSE 0 END)...

Hello Notes,

thank you very much for your reply,

i will go through it, mean while i was stucked with some urgent Quaretr end stuff

any way i will let you know once...