Search found 507 matches

by SIMMS7400
14 Apr 2021 07:04
Forum: DOS Batch Forum
Topic: Safely parse nearly any CSV with pure batch
Replies: 2
Views: 3116

Re: Safely parse nearly any CSV with pure batch

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!!
by SIMMS7400
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!!
by SIMMS7400
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?
by SIMMS7400
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...
by SIMMS7400
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!!
by SIMMS7400
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...
by SIMMS7400
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 "-...
by SIMMS7400
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!!
by SIMMS7400
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%...
by SIMMS7400
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 ...
by SIMMS7400
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...
by SIMMS7400
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...
by SIMMS7400
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:

Code: Select all

/exc "1,'USE FOR TERM'
Do you forsee any issues with this update?
by SIMMS7400
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...
by SIMMS7400
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...