Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Traverse all records - return REGEX/VALUES pattern and count
Agree that SQL is not a great vehicle for this, but it is where all the data resides and is currently my only avenue to go down. In regards to the other question from Frederico - in the data set you present - 456 would have a count of 4, THEN 4561 would have a count of 2, 45612 would have a...- tcerv79
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Traverse all records - return REGEX/VALUES pattern and count
In my case I am trying to see if there has been anyone who has devised a way to obtain an output that would traverse through all records for a given column and find all the patterns (whether it returns REGEX or the VALUES), then count how many times that exists. I know a lot of 1 counts would...- tcerv79
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Can you use awk to search through a .doc file and extrapolate data?
Awesome. I will give that a try! Thanks! -
Can you use awk to search through a .doc file and extrapolate data?
I have many .doc files that all have the same formatting and hard coded questions (Facility Code, File Name, File Date, Total Records). These questions are always the same in each .doc I am trying to pull the data after each specific set of questions as shown below a... -
Max Length Column Checks
Ha..of course you did, and now that I am trying it out I see that. Thanks again and my apologies for my lack of awk knowledge. -
Max Length Column Checks
Annihilannic....Never even thought, or knew really about maxwidth. I will definitely do that. It appears like it will work as I expect. I was looking at defining the LENGTH and setting it equal to 1 and when it was not equal returning the error, but this was in theory. You always have great answers. -
Max Length Column Checks
I have a flat file that is |(pipe) delimited and it has multiple records. I want to check each record and between all pipes for a preset amount of characters that I have define and have it fail if the characters exceed the check. Here is an example: |THOMAS|CROWN|05/01/2009|123 MAIN... -
-
Leading zeros in currency check
What if you do not want to edit the data? Just see if it exists incorrectly? -
Currency Reg Expression
The strings that should PASS this check are as follows: 0.00 -1.23 1.23 10.20 100.23 0.23 -0.23 WHAT SHOULD NOT PASS THIS EXPRESSION IS 000.00 0001.23 -00012.23 -0000.23 0000.43 Any help would be FANTASTIC -
awk GUI?
Yes this will be used by WinDoze (XP mainly) But I have no idea of what I would like to use or what is even possible. I quickly glanced at WinBatch and I have to download the trial to see if it will allow my awk code or compiled awk exe allowed in a front-end GUI. I am new to creating a GUI that... -
awk GUI?
This may be a stretch, but is there a way to attach awk non-compiled code or compiled awk (exe) within a GUI? I am trying to see if there is one to handle the below... Create a simple GUI front-end that provides some ease of use functionality. Maybe not integrate with it, but but launch the... -
Currency Reg Expression
Thank you for pointing out the redundancy. That helps! What is the difference then between (|-) and -? , as I am unsure. Essentially if the field NEEDS to be in this format 123.00 or -123.00 anything else(blanks or empty strings or whitespace, $ within the field, or a-zA-Z TEXT) should NOT be in... -
Currency Reg Expression
Currently the regular expression we are using to define currency is not returning results where we expect. If we receive a currency that has text in it, this does not fail. Does anyone have a better reg exp they can suggest to replace the below? if(Currency !~ /^((|-)[0-9]+\.[0-9][0-9])$/ &&...
