11-24-2009
Firstly you need to put any code between code tags as this makes your post more readable.
Secondly you need to be specific if you want help: -
"but that gives me an when I bcp data into table. something to do with format."
I assume the missing word here is error, in which case the error message / code (between code tags) would be more helpful than "something to do with format"
Good luck
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in... (6 Replies)
Discussion started by: metronomadic
6 Replies
2. Shell Programming and Scripting
I have an extremely large csv file that I need to search the second field, and upon matches update the last field...
I can pull the line with awk.. but apparently you cant use awk to directly update the file? So im curious if I can use sed to do this... The good news is the field I want to... (5 Replies)
Discussion started by: trey85stang
5 Replies
3. Shell Programming and Scripting
Please study the below script and the output
Script:
echo "Minimum ${host} ${process} response time=${min} ms" >> ${OUTDIR}/${OUTFILE};
echo "Maximum ${host} ${process} response time=${max} ms" >> ${OUTDIR}/${OUTFILE};
echo "Average ${host} ${process} response time=${avg} ms" >>... (0 Replies)
Discussion started by: ajincoep
0 Replies
4. Shell Programming and Scripting
Hi,
I have a filename.csv in which there are 3 colums, ie:
Name ; prefixnumber ; number
root ; 020 ; 1234567
user1,2,3 ; 070 ; 7654321
What I want is to merge colum 2 and 3 that it becomes 0201234567 or even better +31201234567 so the country number is used and drop the leading 0.... (9 Replies)
Discussion started by: necron
9 Replies
5. Shell Programming and Scripting
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Discussion started by: shell_boy23
5 Replies
6. Shell Programming and Scripting
Hello folks
I have a txt file of information about journal articles from different fields. I need to convert this information into a format that is easier for computers to manipulate for some research that I'm doing on how articles are cited. The file has some header information and then details... (8 Replies)
Discussion started by: ksk
8 Replies
7. Shell Programming and Scripting
Hello,
Beginning with shell scipting, I'm trying to find in a csv file, the lines where the field related to hostname is displayed as an FQDN intead the hostname. (some lines are correct) and the to correct that inside the file:
Novell,11.0,UNIX Server,bscpsiws02,TxffnX1tX1HiDoyBerrzWA==... (2 Replies)
Discussion started by: Wonto
2 Replies
8. Shell Programming and Scripting
have written a combined sed+awk to perform a lookup operation which works but looking to enhance it.
looking to match a record using any of the comma separated values + return selected fields from the record - including the field header. so:
cat foo
make,model,engine,trim,value... (6 Replies)
Discussion started by: jack.bauer
6 Replies
9. Shell Programming and Scripting
I have a csv file formatted like this:
2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances.
I have got this:
awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I would require your help to generate one output file after post processing of one CSV file as stated below
This file is just a small cut from a big file . Big file is having 20000 lines
PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9... (2 Replies)
Discussion started by: kshitij
2 Replies
LEARN ABOUT SUSE
lintian-info
LINTIAN-INFO(1) User Contributed Perl Documentation LINTIAN-INFO(1)
NAME
lintian-info - give detailed information about Lintian's error tags
SYNOPSIS
lintian-info [log-file...]
lintian-info --tags tag ...
DESCRIPTION
The lintian-info command parses the output of the lintian command and gives verbose information about the listed Lintian error tags, parses
a Lintian override file and gives verbose information about the tags included, or (if given the -t or --tags option) explains a given tag
or tags.
If no log-file is specified on the command line, this command expects its input on stdin. Thus, the output of lintian can either be piped
through lintian-info or a log file produced by lintian can be processed with this command. (Note, though, that the lintian command has a
command line option -i to display the same results as lintian-info, so you will not normally need to pipe the output of lintian into this
command.)
OPTIONS
-a, --annotate
Read from standard input or any files specified on the command line and search the input for lines formatted like Lintian override
entries. For each one that was found, display verbose information about that tag.
-h, --help
Display usage information and exit.
--profile prof
Use the severities from the vendor profile prof when displaying tags. If the profile name does not contain a slash, the default
profile for than vendor is chosen.
If not specified, lintian-info loads the best profile for the current vendor.
Please Refer to the Lintian User Manual for the full documentation of profiles.
-t, --tags
Rather than treating them as log file names, treat any command-line options as tag names and display the descriptions of each tag.
EXIT STATUS
If -t or --tags was given and one or more of the tags specified were unknown, this command returns the exit code 1. Otherwise, it always
returns with exit code 0.
SEE ALSO
lintian(1)
AUTHORS
Niels Thykier <niels@thykier.net>
Richard Braakman <dark@xs4all.nl>
Christian Schwarz <schwarz@monet.m.isar.de>
perl v5.14.2 2013-02-16 LINTIAN-INFO(1)