Text qualifier issue causing data alignment problem
Hello Everyone,
I have a csv file with text qualifier as "" and data similar to below:
Code:
"1","abc","address1","US"
"2","def","address1 "characters in double-quote" address2","IND"
"3","ghi","address1","UK"
In above example, for record 2, we have an issue as in column3 contains double quotes within double quotes. Its causing issue in reading file and data is getting wrongly alligned for that particular record.
Is there a way to use awk or sed so that we can find the record with above issue and reject them to create a new file having only good records.
Moderator's Comments:
edit by bakunin: please use CODE-tags for data too. Thanks.
With older Linux servers, the command:
ls -al
would output text that would have the filenames all lined up in the same column (the owner and group names were truncated to produce a uniform right column).
In newer distros (i.e. RHEL 3), the command will push the right column out when owners... (0 Replies)
Hi, I try to marshal a unsigned int and a char * into a buffer, and then unmarshal them later to get them out. I need to put the char * in the front and unsigned int at the end of the buffer. However, my system always give me "BUS ERROR". I am using Sun Sparcs Sloris 2.10.
My code to marshal the... (1 Reply)
Hi there,
I'm trying to find files that are greater then 30 days old, zip them and move to a different directory. I'm encountering an issue passing a variable (FilesToFind) to name within the find command. Here's the code I'm running:
#! /usr/bin/sh
FileDir=/home/ariba... (2 Replies)
The client's app gets a 'suspend error' which they say is due to a null pointer exception. Application people say nothing's wrong with the app. Network people say the network's fine. I'm supposed to see what's wrong with the system to be causing this error. I checked the NIC card settings, which... (1 Reply)
Hi Gurus,
This is my raw data. How would I able to format this output into a better alignment?
/dev/vg00/lvol5 /home 0.12 GB 0.02 GB 0.10 GB 19%
/dev/vg00/misc /misc 28.43 GB 4.92 GB 23.51 GB 17%
/dev/vg00/lvol6 /opt 8.25 GB 5.43 GB 2.82 GB 65%
/dev/vgsap/ora10264 ... (10 Replies)
HI all,
I tried to edit my files using HP-UX but my output tends to not align when I add another character in the files
to edit my files i used the command is as follow
chmod +w filename
vi filename
Help, :eek: (1 Reply)
can someone please explain to me what i'm doing wrong with this code:
WELT=$(awk '(($1 ~ "^${caag}$") || ($2 ~ "^${caag}$"))' /tmp/Compare.TEXT)
when run from the command line, it works. but it seems to be having a problem doing the comparison when variables are involved.
i tested from... (1 Reply)
Hi
I have a JAVA based application in development and production environment. These two environments are exactly identical in terms of OS, hardware and application components.
Initially the OS was Solaris 5.6 and the application was working fine in both environments. But later when the OS... (12 Replies)
Hi Guru,
I need some advice on how to add blank spaces to the code, rather than me just adding <space-bar spaces> which does not work.
Current output of the code
File System Backed Up - ALL_LOCAL_DRIVES
Daily - Incremental Backup Schedule - 1 Month Retention
• 7pm - PRD... (2 Replies)
Discussion started by: Junes
2 Replies
LEARN ABOUT DEBIAN
netmask
NETMASK(1) Debian Linux NETMASK(1)NAME
netmask - a netmask generation and conversion program
SYNOPSIS
netmask [ options ] spec [ spec ... ]
DESCRIPTION
This program accepts and produces a variety of common network address and netmask formats. Not only can it convert address and netmask
notations, but it will optimize the masks to generate the smallest list of rules. This is very handy if you've ever configured a firewall
or router and some nasty network administrator before you decided that base 10 numbers were good places to start and end groups of
machines.
OPTIONS -h, --help
Print a summary of the options
-v, --version
Print the version number
-d, --debug
Print status/progress information
-s, --standard
Output address/netmask pairs
-c, --cidr
Output CIDR format address lists
-i, --cisco
Output Cisco style address lists
-r, --range
Output ip address ranges
-x, --hex
Output address/netmask pairs in hex
-o, --octal
Output address/netmask pairs in octal
-b, --binary
Output address/netmask pairs in binary
-n, --nodns
Disable DNS lookups for addresses
DEFINITIONS
A spec is an address specification, it can look like:
address
One address.
address1:address2
All addresses from address1 to address2.
address1:+address2
All addresses from address1 to address1+address2.
address/mask
A group starting at address spanning mask.
An address is an internet network address, it can look like:
ftp.gnu.org
An internet hostname.
209.81.8.252
A standard dotted quad internet address notation.
100 A decimal number (100 in this case).
0100 An octal number preceded by "0" (64 in this case).
0x100 A hexadecimal number preceded by "0x" (256 in this case).
A mask is a network mask, it can look like:
255.255.224.0
A dotted quad netmask (netmask will complain if it is not a valid netmask).
0.0.31.255
A Cisco style inverse netmask (with the same checks).
8 The number of bits set to one from the left (CIDR notation).
010 The number of bits set to one from the left in octal.
0x10 The number of bits set to one from the left in hexadecimal.
AUTHOR
netmask was written by Robert Stone. Some algorithm design and optimization was provided by Tom Lear. This manual page was written by
Robert Stone.
BUGS
Let me know if you find any. This man page is a bit more simplistic than I'd like, but I've forgotten most of the groff I once knew.
SEE ALSO ipchains(1), ipfwadm(8), netstat(8), route(8), routed(8), gated(8), tcpd(8)Debian Project 15 May 1999 NETMASK(1)
04-19-2013
