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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mmiah1982

    Extracting mutiple data items from DB with JSON string format column

    Yes perfect! Thanks Mikrom! [smile]
  2. mmiah1982

    Extracting mutiple data items from DB with JSON string format column

    Hi, Just need some assistance if someone can point me in the right direction it would be greatly appreciated. I have the following table structure contactID attributes 1234...
  3. mmiah1982

    Extracting Values from a nested JSON

    @Mikrom your a Superstar! This works a treat. Thank you for your guidance!
  4. mmiah1982

    Extracting Values from a nested JSON

    Hi, I'd like to extract certain values from an API call which is returning a nested JSON file. This is some of the Python I use to call the API: Current API Call classification = client.classifyProduct(Text =text, EndpointArn = endpoint ) #API call for document classification, calling...
  5. mmiah1982

    extracting values from multiple lines into a seperate output file

    Thats done the trick! Brill Thanks for your help :)
  6. mmiah1982

    extracting values from multiple lines into a seperate output file

    Thanks that's brilliant almost gives it what I need, one thing though for each result found it's returning the row 6 times? so for the extract of the log file above it returns the following, the same line repeated 6 times? Date Time Event IP Address ConnID DN 11/07/12 15:49:05.448...
  7. mmiah1982

    extracting values from multiple lines into a seperate output file

    Thanks I do seem to have left some key details out apologies Is there a single RequestReleaseCall line or can be more ? <---- Single on a line but many instances which I'd like to extract If there are more RequestReleaseCall lines, only the first has to be extracted or all ? <--- All Are...
  8. mmiah1982

    extracting values from multiple lines into a seperate output file

    Thanks Ferkhe, "Regarding extracting pieces from the other lines too, just add more similar regular expressions and prints. Just spare the \n from the end of printed strings, excepting the last one." My log file has many instances of the word AttributeConnID and AttributeThis DN, it is only...
  9. mmiah1982

    extracting values from multiple lines into a seperate output file

    This is what I have so far, the bit I struggle with mostly is extracting the lines below my initial line to get the values I'm interested in I think there's also some issue with my syntax? use strict; use warnings; print " Date\tTime\tEvent\tIP Address\tConnID\tDN\n "; @ARGV = <@ARGV>...
  10. mmiah1982

    extracting values from multiple lines into a seperate output file

    Hi, I’m using perl on windows v5.10.1 and would like to extract out of a log file extract below to produce output as below, does anyone know how to extract the items highlighted in red? The format of the log file is pretty much consistent throughout: Log extract CCurClgA=901922494724...
  11. mmiah1982

    Extract out of Log file

    Perfect! I can't thank you enough for all your help on this, even my noob questions! :)
  12. mmiah1982

    Extract out of Log file

    Thanks Again for the explanation :) Adding Globbing didn't seem to work get following error Global symbol @argv requires explicit package name at Find.pl M
  13. mmiah1982

    Extract out of Log file

    Thanks Feherke! I think that's almost exactly what I'm after!!! One additional tweak is at the moment the input file is the name of a single file that you choose, if the input was a list of files in a directory how would i read this in? So the script would be in the directory containing all...
  14. mmiah1982

    Extract out of Log file

    Hi Interesting. Please specify your operating system, shell/command interpreter and Perl version. -- Windows XP, Perl v5.10.1[/b] Actually extracts this lines which contain "Primary" anywhere and contain something looking as IP address as their 7th or later word and the 5th word is either...
  15. mmiah1982

    Extract out of Log file

    Hi Feherke, Thanks for you reply, I'm just getting to grips with perl so my code is more than likely far from perfect ;) Ideally I'd like to put everything within the perl file so all i pass through the command line is the name of my perlscript and the input and output files. I've attempted...
  16. mmiah1982

    Extract out of Log file

    Hello I have a log file which I'm looking to extract certain lines containing keywords so far I have managed to produce the script below which extracts any line containg words EventEstablished and Primay into a text file output as below 11/06/12 09:54:04.549 Trc 04542 EventEstablished sent to...

Part and Inventory Search

Back
Top