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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Extracting mutiple data items from DB with JSON string format column
Yes perfect! Thanks Mikrom! [smile] -
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... -
Extracting Values from a nested JSON
@Mikrom your a Superstar! This works a treat. Thank you for your guidance! -
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... -
extracting values from multiple lines into a seperate output file
Thats done the trick! Brill Thanks for your help :) -
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... -
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... -
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... -
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>... -
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... -
Extract out of Log file
Perfect! I can't thank you enough for all your help on this, even my noob questions! :) -
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 -
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... -
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... -
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... -
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...
