Hi,
File link: https://drive.google.com/file/d/0B3oygD ... sp=sharing
After.
File link: https://drive.google.com/file/d/0B3oygD ... sp=sharing
Thanks.
Search found 68 matches
- 19 Oct 2015 14:39
- Forum: DOS Batch Forum
- Topic: Search for String
- Replies: 15
- Views: 12466
- 19 Oct 2015 09:17
- Forum: DOS Batch Forum
- Topic: Search for String
- Replies: 15
- Views: 12466
Re: Search for String
Hi,
Post deleted
Post deleted
- 18 Oct 2015 10:45
- Forum: DOS Batch Forum
- Topic: Search for String
- Replies: 15
- Views: 12466
Search for String
Hi, Copy REPORT DATE :dd/mm/yyyy from the 3rd line situated in centre to the first line of text file. BRANCH :abcdefg Branch space space space REPORT DATE :19/08/2015 space space space Report 1 findstr /v "^To Ln Code BRANCH :" sample.txt >sample_revised.txt 1. I want to search a text file...
- 19 Aug 2015 22:18
- Forum: DOS Batch Forum
- Topic: Fixed Width Text file
- Replies: 17
- Views: 13049
Re: Fixed Width Text file
Hi, Sorry for delay reply. Thanks Dave Benham your codes are working as per requirements. Right now the out file(result file) output is single line it does not copy the first line header from test file and result produce single line from test file 2nd line to out file. :: Define a function to right ...
- 13 Aug 2015 09:45
- Forum: DOS Batch Forum
- Topic: Fixed Width Text file
- Replies: 17
- Views: 13049
Re: Fixed Width Text file
Hi, Thanks Squashman for the reply. Does each tab delimited field need to be a certain length. Yes 2,15,19,4,38,35,13,15,2,10 (if no data then also needs white space of 10) Before 11(tab)626350837(tab)6263506492(tab)ID(tab)Friends Limousine Service(tab)111 Glenn Way #-2(tab)Lamar(tab)Ana(tab)y(tab)R...
- 13 Aug 2015 02:55
- Forum: DOS Batch Forum
- Topic: Fixed Width Text file
- Replies: 17
- Views: 13049
Fixed Width Text file
Hi, I have an Tab delimited Text file and would like to reset it to fixed width padding spaces where required. Existing tab text file 11(tab)626350837(tab)6263506492(tab)ID(tab)Friends Limousine Service(tab)111 Glenn Way #-2(tab)Lamar(tab)Ana(tab)y(tab)Racheal Required fixed width text file 11626350...
- 21 Mar 2015 01:24
- Forum: DOS Batch Forum
- Topic: Delete Lines
- Replies: 6
- Views: 7246
Re: Delete Lines
Hi, Foxidrive you are genius. There's an invisible character at the beginning of the line and the PAGE: X is on the end of the line. That's 100% true the invisible character is page break sign. The X was to displayed to show that they will change on each page. Genius foxidrive, provide some solution...
- 10 Mar 2015 01:54
- Forum: DOS Batch Forum
- Topic: Delete Lines
- Replies: 6
- Views: 7246
Delete Lines
Hi, I need to delete these lines company name company name company name branch branch name ledger printing 02/07/2014 July 2014 PAGE: X as they reoccur in text file repeatedly. Any simple way to whip out instantly, Only the PAGE: X changes else is constant. Thanks.
- 25 Nov 2014 11:18
- Forum: DOS Batch Forum
- Topic: Increment the numbers
- Replies: 9
- Views: 5512
Re: Increment the numbers
Antonio, Thankyou for explantion, grateful to you. Thankyou Dave Benham , it was my mistake and your script is 100% and its outputs the results. Help required Dave, I want to export/append the data to csv files, the first field will decide the CSV file name, if its 123456 then it will append the da...
- 24 Nov 2014 12:47
- Forum: DOS Batch Forum
- Topic: Increment the numbers
- Replies: 9
- Views: 5512
Re: Increment the numbers
Hi Dave Benham, The out file does not give any results. On your suggestion if i remove the header and convert the tab to pipe delimiters will that work. Test file sample. 2125305|21|407871|10|1706|28374 2125306|344|407881|10|1706|15423 2125307|556|407891|40|1706|28707 2125308|676|407901|25|351|28707...
- 24 Nov 2014 09:22
- Forum: DOS Batch Forum
- Topic: Increment the numbers
- Replies: 9
- Views: 5512
Increment the numbers
Hi, I use to do this in Ms Excel now i want to try on batch scripting for its robustness. Increment the numbers in the rows starting at field 7 using the parameters in field 3(start) and 4(end), and to format each of the cells with leading zeros to have a 6 decimal number, and save as tab delimited ...
- 23 Nov 2014 04:51
- Forum: DOS Batch Forum
- Topic: Convert Tab text file to Pipe Delimiter CSV file
- Replies: 3
- Views: 5671
Re: Convert Tab text file to Pipe Delimiter CSV file
Thanks Dave Benham its works perfectly.
Thankyou.
Thankyou.
- 21 Nov 2014 02:06
- Forum: DOS Batch Forum
- Topic: Convert Tab text file to Pipe Delimiter CSV file
- Replies: 3
- Views: 5671
Convert Tab text file to Pipe Delimiter CSV file
Hi, I have tab delimited text file in that i want to change the 2nd field value and convert the tab/spaces to pipe delimted CSV file. Now i have conversion list, if 1 in 2 field it will be converted to 101000011, if 3 then 101000033. Is that possibe to achieve via batch file. dot(.) for display of t...
- 05 Nov 2014 16:34
- Forum: DOS Batch Forum
- Topic: Move the Contents of Text file
- Replies: 4
- Views: 3213
Re: Move the Contents of Text file
Hi,
SUPERB, EXCELLENT Aacini
Thanks.
SUPERB, EXCELLENT Aacini
Thanks.
- 05 Nov 2014 14:47
- Forum: DOS Batch Forum
- Topic: Move the Contents of Text file
- Replies: 4
- Views: 3213
Re: Move the Contents of Text file
Hello, Sample data. 23102014 2230002100310000101028330 000000071800002643333455446821348 2210002100210000022711 000000164200002643138993934699262 222130210021000010104 000000020600002643580679455001503 22315021002103010000029 000000021200002643339123491688650 223100210021030100000295 000000021200002...