Search found 66 matches

by zagix
24 Jan 2018 11:11
Forum: DOS Batch Forum
Topic: Remove Empty lines and copy selected lines to new text file
Replies: 4
Views: 1386

Re: Remove Empty lines and copy selected lines to new text file

Hi, Thanks aGerman for script, a little help is required for data cleaning. Like on Line 2 remove space before the data (space) xx Like on Line 4 of text file, on single line Date = xx/xx/xx Value Date = yy/yy/yy is there delete all before (=) and copy only date and value date, move value date to ne...
by zagix
23 Jan 2018 08:59
Forum: DOS Batch Forum
Topic: Remove Empty lines and copy selected lines to new text file
Replies: 4
Views: 1386

Remove Empty lines and copy selected lines to new text file

Hi, In my text file first of all i want to delete all the empty rows/lines. Then where Level = 1 will be taken as first line and below line 1,2,4,6,7,9 to be copied to new text file. Sample data some data xxxxxx some data xxxxxx some data xxxxxx some data xxxxxx Level = 1 some data here.........1 so...
by zagix
02 Jun 2017 11:53
Forum: DOS Batch Forum
Topic: Search in csv file for Match
Replies: 3
Views: 1356

Re: Search in csv file for Match

Hi,

Thanks Antonio for helping.
It's completely reconciliation of entries, previously we used to make printouts and then rectify it manually.
I have attached the sample data to my dropbox kindly have look to it.

https://www.dropbox.com/s/8q1319btwyas4 ... 1.csv?dl=0
https://www.dropbox.com/s/ymt7wsqhgos5d ... 2.csv?dl=0

Thanks in advance.
by zagix
01 Jun 2017 14:54
Forum: DOS Batch Forum
Topic: Search in csv file for Match
Replies: 3
Views: 1356

Re: Search in csv file for Match

Hi, Thanks Antonio for helping. It's completely reconciliation of entries, previously we used to make printouts and then rectify it manually. I have attached the sample data to my dropbox kindly have look to it. https://www.dropbox.com/s/8q1319btwyas44r/file1.csv?dl=0 https://www.dropbox.com/s/ymt7w...
by zagix
31 May 2017 04:34
Forum: DOS Batch Forum
Topic: Search in csv file for Match
Replies: 3
Views: 1356

Search in csv file for Match

Hi, I need help for solving this, on daily basis around 600 entries are reconciled manually. I have two comma separated csv files, File1.csv & File2.csv, 1st row header Date,Particulars,Amount,Type,Balance. Startiing from Column Particulars of File1.csv into column Particulars of File2.csv for s...
by zagix
20 Nov 2016 20:47
Forum: DOS Batch Forum
Topic: Concatenate multiple files
Replies: 1
Views: 884

Concatenate multiple files

Hi, I have 50 text files in one directory, (C:\combined). I want merge them to a single file but with one condition that to verify each file date and which is mentioned on line 2 DATE : dd/mm/yyyy. Merge all the file of Today's date only to new file c:\Real\Report.txt, and to move all those merged f...
by zagix
20 Jul 2016 22:03
Forum: DOS Batch Forum
Topic: Search in XML files
Replies: 8
Views: 2438

Re: Search in XML files

Hi, Compo, on testing i am getting this error. PS C:\Users\S> C:\Test\LatLonAlt.ps1 Get-Content : Cannot bind argument to parameter 'Path' because it is null. At C:\Test\LatLonAlt.ps1:11 char:32 + [XML] $Content = Get-Content <<<< $File.FullName + CategoryInfo : InvalidData: (:) [Get-Content], Param...
by zagix
15 Jul 2016 13:54
Forum: DOS Batch Forum
Topic: Search in XML files
Replies: 8
Views: 2438

Re: Search in XML files

Hi,

Aacini, i need some more help.

Search value in c:\xml and its sub folders, and if value is found in any of xml file then get the tag <clntId> and <priority> values on the console.

Thanks in advance.
by zagix
14 Jul 2016 21:46
Forum: DOS Batch Forum
Topic: Search in XML files
Replies: 8
Views: 2438

Re: Search in XML files

Hi,

Thanks Aacini.
by zagix
14 Jul 2016 21:23
Forum: DOS Batch Forum
Topic: Search in XML files
Replies: 8
Views: 2438

Search in XML files

Hi, I have multiples of XML files in folder c:/xml and need to search for a numeric value or string, without opening the files and once the value is located then display the particular file name on console, condition is that it should run the search on all the xml files and output the search result ...
by zagix
15 Jun 2016 02:51
Forum: DOS Batch Forum
Topic: Search and copy files from particular folder
Replies: 3
Views: 1289

Re: Search and copy files from particular folder

Hi,

Sorry for delay in reply.

Thanks works perfectly.
by zagix
11 Jun 2016 08:53
Forum: DOS Batch Forum
Topic: Search and copy files from particular folder
Replies: 3
Views: 1289

Search and copy files from particular folder

Hi, I need to copy .pdf's files from particular folder to destination folder. The folder Root is at C:\Backup and in them multiple sub-folders are there. C:\Backup --root folder Database--sub-folder 01012016--sub-folder,sub-folder,sub-folder,sub-folder,IME 02012016--sub-folder,sub-folder,sub-folder,...
by zagix
20 Oct 2015 01:40
Forum: DOS Batch Forum
Topic: Search for String
Replies: 15
Views: 4261

Re: Search for String

Hi, Thank you very much for your help Aacini,Penpen,Yury and Squashman for helping me. One more query if i want to delete this lines also. |----------------------------------------------------------------------------------------------------------------------------------------------------------------...
by zagix
19 Oct 2015 09:17
Forum: DOS Batch Forum
Topic: Search for String
Replies: 15
Views: 4261

Re: Search for String

Hi,
Post deleted