Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Processing data that contains space and quote delimiters
Top Forums Shell Programming and Scripting Processing data that contains space and quote delimiters Post 302432764 by pseudocoder on Saturday 26th of June 2010 07:11:11 PM
Old 06-26-2010
First convert your data into a comma delimited file (csv):
Code:
$ cat sample.dat
A B C D E F
"A A" B C D E F
A "B B" C D E F
A B "Hi there" D E F
A B C "Lots of words" E F
A B C D "E E E E E E E E" F
A B C D E "F F"
$ perl -ne 'my @x=split(/ /); for (0..$#x) {
     if ($x[$_] !~ /"/ && $a != 1) {print $x[$_] . ","; }
  elsif ($x[$_] =~ /^"/) { $x[$_] =~ s/"//g; print $x[$_] . " "; $a=1; }
  elsif ($x[$_] !~ /"$/ && $a == 1) { print $x[$_] . " "; }
   else { $x[$_] =~ s/"//g; print $x[$_] . ","; $a=0 } } ' sample.dat > sample.tmp
$ 
$ sed 's/^,//' sample.tmp | sed '$d' > sample.csv
$ rm sample.tmp
$
$ cat sample.csv
A,B,C,D,E,F
A A,B,C,D,E,F
A,B B,C,D,E,F
A,B,Hi there,D,E,F
A,B,C,Lots of words,E,F
A,B,C,D,E E E E E E E E,F
A,B,C,D,E,F F
$

Now you could use
Code:
param4=$(echo $line | awk -F, '{print $4}')

to assign the value of the fourth column to the param4 variable.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Capturing Data between first quote and next quote

I have input file like RDBMS FALIURE UTY8703 'USER_WORK.TEST' .HIghest return code '12' I want to parse data which comed between first quote till next quote USER_WORK.TEST can you please suggest how to do that (4 Replies)
Discussion started by: scorp_rahul23
4 Replies

2. Shell Programming and Scripting

Regex in grep to match all lines ending with a double quote (") OR a single quote (')

Hi, I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file: Name = "abc" The regex I'm using to match the same is: egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies

3. UNIX for Dummies Questions & Answers

Remove two delimiters, space and double quotes

I would like to know how to replace a space delimiter with a ^_ (\037) delimiter and a double quote delimiter while maintaining the spaces inside the double quotes. The double quote delimiter is only used on text fields. I'd prefer a one-liner, but could handle a function or script that accepts... (4 Replies)
Discussion started by: SteveDWin
4 Replies

4. Shell Programming and Scripting

Insert data between comma delimiters-large file

Having a huge file in the following format. 2,3,1,,,4 1,2,3,,,,,5, 8,7,3,4,,,, Output needed is: 2,3,1,0.0,0.0,4 1,2,3,0.0,0.0,0.0,0.0,5, 8,7,3,4,0.0,0.0,0.0, I have tried reading the file each line, using AWK to parse to find out ",," and then insert 0.0 . It works but very slow. Need... (8 Replies)
Discussion started by: wincrazy
8 Replies

5. Shell Programming and Scripting

Replacing trailing space with single quote

Platform : RHEL 5.8 I want to end each line of this file with a single quote. $ cat hello.txt blueskies minnie mickey gravity snoopyAt VI editor's command mode, I have used the following command to replace the last character with a single quote. ~ ~ ~ :%s/$/'/gNow, the lines in the... (10 Replies)
Discussion started by: John K
10 Replies

6. UNIX for Dummies Questions & Answers

Replace Delimiters with Space

Hi All, How to Replace the delimiter for a particular field. I have used awk to replace the field values based on the position, but I tried to remove/replace delimiters with space on particular positions. I tried tr command with combination of awk not sure if this is the correct way, but I am... (3 Replies)
Discussion started by: mora
3 Replies

7. Shell Programming and Scripting

Skip the delimiter with in double quotes and count the number of delimiters during data extract

Hi All, I'm stuck-up in finding a way to skip the delimiter which come within double quotes using awk or any other better option. can someone please help me out. Below are the details: Delimited: | Sample data: 742433154|"SYN|THESIS MED CHEM PTY.... (2 Replies)
Discussion started by: BrahmaNaiduA
2 Replies

8. Shell Programming and Scripting

Replacing all but the first and last double quote in a line with a single quote with awk

From: 1,2,3,4,5,This is a test 6,7,8,9,0,"This, is a test" 1,9,2,8,3,"This is a ""test""" 4,7,3,1,8,"""" To: 1,2,3,4,5,This is a test 6,7,8,9,0,"This; is a test" 1,9,2,8,3,"This is a ''test''" 4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies

9. Shell Programming and Scripting

Eval command with space, quote and bracket characters

Hi, I am Pradnya Gandhe trying to use in shell script. I want to use a bit complicated command using eval command in a shell script. <path to>\wsadmin.sh -lang jython -conntype NONE -c "AdminApp.install('war file path', '] -MapWebModToVH ] -MapRolesToUsers ] ]')" Works correctly as expected... (2 Replies)
Discussion started by: Pradnya Gandhe
2 Replies

10. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies

LEARN ABOUT SUSE

load_sample

load_sample(3alleg4)						  Allegro manual					      load_sample(3alleg4)

NAME

       load_sample - Loads a sample from a file. Allegro game programming library.

SYNOPSIS

       #include <allegro.h>

       SAMPLE *load_sample(const char *filename);

DESCRIPTION

       Loads  a  sample from a file, supporting both mono and stereo WAV and mono VOC files, in 8 or 16-bit formats, as well as formats handled by
       functions registered using register_sample_file_type(). Example:

	  SAMPLE *sample = load_sample(user_input);
	  if (!sample)
	     abort_on_error("Couldn't load sample!");

RETURN VALUE

       Returns a pointer to the SAMPLE or NULL on error. Remember to free this sample later to avoid memory leaks.

SEE ALSO

       destroy_sample(3alleg4),    load_voc(3alleg4),	  load_wav(3alleg4),	 play_sample(3alleg4),	   save_sample(3alleg4),     register_sam-
       ple_file_type(3alleg4), exsample(3alleg4)

Allegro 							   version 4.4.2					      load_sample(3alleg4)
All times are GMT -4. The time now is 12:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy