DosTips.com

any alternative ??

is it possible to get only mismatch cases without any formating in txt file.

file name 1 : 0215648897979 john rodrigs
file name 2 : 0215649987979 jonh bodrigs

Sir, Thanks for prompt reply, I dont want result in colour but in possible way like underline / Bold font etc. below is just example for understand the requirement. have checked CSDiff utility its very usefull but I can't use it in my office PC as its not permissible to use outside utility for secur...

Hi, I have 2 Txt file in folder with same format, i want batch file to match both txt files line by line and give any mismatch cases in new seprate file with details of mismatch in below format Mismatch details file name 1 : 021564 88 97979 jo hn r odrigs file name 2 : 021564 99 87979 jo nh b odrigs

its work... Many thanks

Hi,

I have multiple .prn files i want to rename as below ( a ren to act and m ren to mat )

file name rename to

a.prn act.prn
a1.prn act1.prn
a2.prn act2.prn
m.prn mat.prn
m1.prn mat1.prn
m2.prn mat2.prn

sir, In "c:\Report" folder there is only custome report.xlsx file( data file ) and (below code).bat file exist. after double click on bat file its only creats pause with below error and after enter vbs file deleted but txt file not created. Getting below error The system cannot find the pa...

Sir,

Thanks for the reply.

but now vbs file deleted and i have made changes to delete space between red and blue words and add 2 tab between but no txt file created. in folder only xlsx and bat file is exist.
i don't understand what is going wrong at my end.

can u pls help

Sir, Getting below error The system cannot find the path specified. The system cannot find the path specified. The system cannot find the path specified. The system cannot find the path specified. All Done and create file excel2csv.vbs file which showing msg : ---------------------------------------...

Yes, its work ...Thanks a lot for your prompt reply.

Sir, Thank u for your reply, but not getting as required. only file creates with .csv with no data. Required just like mail merge in word. below is the report template only fill in the blanks need to copy data from xlsx file. ------------------------------------------------------------------ XYZ LTD...

Sir, Can u pls do the small modification in below code. I just want to copy file name with "|" seprator at last column. current output with below code as ab.prn | fakjsdfla;djf;jadsf;lajdsfjasdfjalkfa required output as below fakjsdfla;djf;jadsf;lajdsfjasdfjalkfa | ab.prn Pls help. @echo o...

Hi, I have xls data file from which i want to create report just like mail merge but in txt file template. can any one provide macro to generate report. text file should auto save with file name "report & date" into in same folder where xls file. attached sample file for your ref. m ( ...

Perfect!! its work.

Thanks a lot

Sir, its only showing file name "|" again file name not copying data from file need to copy all data from each file to one new file adding file name to each row of data at starting with "|". getting output file as below with below code. ab.prn | ab.prn ab.prn | ab.prn 123.prn | 1...

Hi, I want to merge all .prn file to new txt file in folder with start file name and pipe seprated (|) in all row have using below code but its only merging. @echo off copy /A *.prn Newfile.txt requied output file is as below (filename) | ( data of file ) ab.prn | fakjsdfla;djf;jadsf;lajdsfjasdfjalk...