Text qualifier issue causing data alignment problem
Hello Everyone,
I have a csv file with text qualifier as "" and data similar to below:
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)