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 dencom 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
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?
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
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... -
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
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])$/ &&...
