HI Dave -
This works great for me situation, many thanks!!!
Now I understand beggars can't be choosers, but this is running "slow" when cycling through a big file. Is this expected behavior? And by slow I mean about ~1 minute for a 3k row file.
Other than, absolutely fantastic!!
Search found 507 matches
- 14 Apr 2021 07:04
- Forum: DOS Batch Forum
- Topic: Safely parse nearly any CSV with pure batch
- Replies: 2
- Views: 3116
- 08 Apr 2021 02:16
- Forum: DOS Batch Forum
- Topic: JREPL to extract unique values from 16million row file?
- Replies: 6
- Views: 300
Re: JREPL to extract unique values from 16million row file?
Antonio -
That worked wonderfully!! 16+ millions rows very quickly. Thank you again for this, much appreciated!!
That worked wonderfully!! 16+ millions rows very quickly. Thank you again for this, much appreciated!!
- 04 Apr 2021 10:19
- Forum: DOS Batch Forum
- Topic: JREPL to extract unique values from 16million row file?
- Replies: 6
- Views: 300
Re: JREPL to extract unique values from 16million row file?
Hi Aacini !
Thank you ! Basically I need to pull all the unique values in column 8. Is that possible?
Thank you ! Basically I need to pull all the unique values in column 8. Is that possible?
- 03 Apr 2021 06:44
- Forum: DOS Batch Forum
- Topic: JREPL to extract unique values from 16million row file?
- Replies: 6
- Views: 300
JREPL to extract unique values from 16million row file?
HI Dave/Team - I have a text file that is 16 million rows and I need to extract the unique values from the 8th position of the file. "Property Gross Royalties" "Commercial" "Actual" "Final" "FY14" "Jan" "Periodic" "O-20003921" "FDR" "PA" 120 "Sides" "Commercial" "Actual" "Final" "FY14" "Jan" "Period...
- 22 Mar 2021 19:22
- Forum: DOS Batch Forum
- Topic: Using multiple strings for FINDSTR - is this OK?
- Replies: 3
- Views: 680
Re: Using multiple strings for FINDSTR - is this OK?
Dave -
As usual, you are the man! Thank you so much for your help here! This has actually cascading into my updating a few of my other scripts as well based on the concept here.
Thank you again!!
As usual, you are the man! Thank you so much for your help here! This has actually cascading into my updating a few of my other scripts as well based on the concept here.
Thank you again!!
- 17 Mar 2021 04:08
- Forum: DOS Batch Forum
- Topic: Using multiple strings for FINDSTR - is this OK?
- Replies: 3
- Views: 680
Re: Using multiple strings for FINDSTR - is this OK?
In searching some old threads from Fox and others, this seems to be the preffered approach: @ECHO OFF ::-- If one or more Data Management CRITICAL Errors detected, build kickout file --:: FINDSTR /I /C:"ORA-"^ /C:"Fetch of Driver Member"^ /C:"Error: 3303"^ /C:"Error: 3304"^ /C:"Error: 3335"^ /C:"Err...
- 17 Mar 2021 03:15
- Forum: DOS Batch Forum
- Topic: Using multiple strings for FINDSTR - is this OK?
- Replies: 3
- Views: 680
Using multiple strings for FINDSTR - is this OK?
Hi Folks - I have the following logic that I need to check multiple strings. If 1 or more are found from my first check, then need to include other and spool all content to a file. The logic is working but wondering if there is a better way? Also, I'd like to use ORA- as one of my strings but the "-...
- 16 Mar 2021 18:40
- Forum: DOS Batch Forum
- Topic: Issue declaring an array and then using it's value
- Replies: 8
- Views: 889
Re: Issue declaring an array and then using it's value
HI Compo -
I understand now. Yes, you are right I don't need to be as detailed as it was, unnecessary. I have used your suggestion and have been testing the last few days and everything is working as expected!! Thank you again!!
I understand now. Yes, you are right I don't need to be as detailed as it was, unnecessary. I have used your suggestion and have been testing the last few days and everything is working as expected!! Thank you again!!
- 14 Mar 2021 03:47
- Forum: DOS Batch Forum
- Topic: Issue declaring an array and then using it's value
- Replies: 8
- Views: 889
Re: Issue declaring an array and then using it's value
Hi Compo - I replaced my section with yours: SETLOCAL ENABLEEXTENSIONS DISABLEDELAYEDEXPANSION FOR /F "DELIMS==" %%G IN ('"(SET STR[%COMPUTERNAME%].) 2>NUL"') DO SET "%%G=" SET "_ALL=:5210/Oracle/Drm/ProcessManager|server1.client.com|" FOR %%A IN ( "HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa%_ALL%...
- 13 Mar 2021 03:54
- Forum: DOS Batch Forum
- Topic: Issue declaring an array and then using it's value
- Replies: 8
- Views: 889
Re: Issue declaring an array and then using it's value
Hi Compo - Thanks so much, that certainly cuts down on the amount of lines necessary. My only question is how would I set all my variables so I can access them? You have set _ENV here, but how do I set all of them from above? FOR %%G IN ("!STR[%COMPUTERNAME%].ENV!") DO ENDLOCAL & SET "_ENV=%%~G" Or ...
- 12 Mar 2021 04:43
- Forum: DOS Batch Forum
- Topic: Issue declaring an array and then using it's value
- Replies: 8
- Views: 889
Re: Issue declaring an array and then using it's value
I think I got it. I need to set all of the variables with an array first and then implement and ENDLOCAL: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR %%A IN ( "HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa:5210/Oracle/Drm/ProcessManager|server1.client.com|server001.onetakeda.com" "HYPER-UTIL-TST|TE...
- 12 Mar 2021 04:28
- Forum: DOS Batch Forum
- Topic: Issue declaring an array and then using it's value
- Replies: 8
- Views: 889
Issue declaring an array and then using it's value
Hi Folks - I have an automation routine setup that performs a bunch of tasks. In all of my scripts, I first call an "environment" file to set a handful of variables for the given operation. In looking over my "environment" file, there is an opportunity to use an array to populate some variables to e...
- 10 Feb 2021 15:06
- Forum: DOS Batch Forum
- Topic: JREPL Usage - read text file with commas and replace empty value
- Replies: 12
- Views: 2492
Re: JREPL Usage - read text file with commas and replace empty value
Hi Dave -
I used the following and it seems to work:
Do you forsee any issues with this update?
I used the following and it seems to work:
Code: Select all
/exc "1,'USE FOR TERM'
- 10 Feb 2021 13:43
- Forum: DOS Batch Forum
- Topic: JREPL Usage - read text file with commas and replace empty value
- Replies: 12
- Views: 2492
Re: JREPL Usage - read text file with commas and replace empty value
Hi Dave - I just tried the suggestion but unfortunately doesn't seem to work. Here are the contents of my first column, could the comma be causing an issue? CALL "%UTILPATH%Batch\JREPL" "^((?:[^|]*\|){17})\s*(?=$|\|)" "$1Projected Start Date Missing" /A /exc "1,'(USE FOR TERM)|'b" /f "%FDMEE_BIN%%DA...
- 10 Feb 2021 11:49
- Forum: DOS Batch Forum
- Topic: JREPL Usage - read text file with commas and replace empty value
- Replies: 12
- Views: 2492
Re: JREPL Usage - read text file with commas and replace empty value
HI Dave - I'm hoping this would be an easy tweak but there is a new business need. Per the above JREPL solution you suggested, it's working like a charm!! I do need to add a piece of logic that ignore certain rows that contain a specific string, is that possible? If the first column contains a strin...