DosTips.com

If we move the COMPANY field as the first column of the text file we receive, then would it be easier to write the script for each company. COMPANY Date Time stamp Date Time stamp Employee Name CBJ 02-12-2012 00:00:00 02-12-2012 00:00:00 Kathy LBU 02-12-2012 00:00:00 02-12-2012 00:00:00 Nick SOH 02-...

If some employees have a middle initials then they are separated by a space.

Sometimes we do get more than 6 fields but any additional field would be after the company name, like employee ID, job title which are separated by spaces.

Yes, the fields are separated by spaces. Employee names have space in them, but company doesn't have any space.

Hi Alan, This the format of the file we receive is Date Time stamp Date Time stamp Employee Name COMPANY 02-12-2012 00:00:00 02-12-2012 00:00:00 Kathy CBJ 02-12-2012 00:00:00 02-12-2012 00:00:00 Nick LBU 02-12-2012 00:00:00 02-12-2012 00:00:00 Hunter SOH So after the fixed time-stamp format we have ...

we have company names as CBJ, LBU, SOH. The script should search the incoming.txt file for the company name CBJ and create a new file called CBJ.txt with the output of findstr "CBJ" in it and then move it from C:\temp\incoming.txt to D:\temp\CBJ.txt. And then search for company string LBU ...

Hi, I am new to DOS scripting and have a new requirement where I have a incoming.txt file which have multiple company names and i need to find a strings(company name) and create a new file as companyname.txt C:\temp\incoming.txt has the below sample data in it 02-12-2012 00:00:0002-12-2012 00:00:00H...