|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Parsing comma delimited text file
Post 302108103 by anbu23 on Friday 23rd of February 2007 02:02:29 AM
02-23-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as:
"Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks.
Is this... (2 Replies)
Discussion started by: dbrundrett
2 Replies
2. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
3. Shell Programming and Scripting
I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST):
1, 2,43,34, bosx,PEST
1,... (1 Reply)
Discussion started by: dolo21taf
1 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have two files that I need to match patterns with and the second file has comma delimited rows of data that match but I'm having trouble getting a script to work that gives me the match output to these sets :
file 1:
PADG_05255
PADG_06803
PADG_07148
PADG_02849
PADG_02886... (8 Replies)
Discussion started by: greptastic
8 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have output of sql saved in comma separated file.
Now i need to read line by line this file
and assign word to a unix variable for further processing
Eg:
Test file
world, 1, 3, 4
earth,2,3,4,5
moon,1,2,3,4
Output should be
word1= world
word2=1
echo " first word... (7 Replies)
Discussion started by: gwrm
7 Replies
6. Shell Programming and Scripting
I have a log file that contains several reports with following format.
<Start of delimiter> Report1 header
Report1 header continue
Report1 header continue
Record1 header
Record1 header continue
Record1 header continue
field1 field2 field3 field4
------... (1 Reply)
Discussion started by: yoda9691
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,
Is there a one-liner that I can use to change a line of text into a comma delimited string?
For example, convert
user1
user2
user3
user4to
user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually.
Please... (5 Replies)
Discussion started by: newbie_01
5 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am not sure if I've posted this question before.
Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o
Can anyone advise how is this possible?
Example as below:
Converting records/lines to... (2 Replies)
Discussion started by: newbie_01
2 Replies
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
Hi,
Apologies in advance to the moderator if I am posting this the wrong way.
I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question.
The question I have is in relation to the following post:
How to... (6 Replies)
Discussion started by: newbie_01
6 Replies
LEARN ABOUT DEBIAN
shtool-mkshadow
SHTOOL-MKSHADOW.TMP(1) GNU Portable Shell Tool SHTOOL-MKSHADOW.TMP(1) NAME
shtool-mkshadow - GNU shtool create shadow tree using symlinks SYNOPSIS
shtool mkshadow [-v|--verbose] [-t|--trace] [-a|--all] src-dir dst-dir DESCRIPTION
This command creates a shadow tree of src-dir under dst-dir by recreating the directory hierarchy of src-dir under dst-dir and by creating the files of src-dir by linking them into the corresponding directories under dst-dir via symbolic links. When src-dir can be reached via relative paths from dst-dir, relative symbolic links are used, too. This high-level functionality is originally designed for developers to create copies of source trees. OPTIONS
The following command line options are available. -v, --verbose Display some processing information. -t, --trace Enable the output of the essential shell commands which are executed. -a, --all Really shadow all files and directories in src-dir. Default is to skip CVS related files and directories, backup files, object files, etc. EXAMPLE
# shell script shtool mkshadow -v -a . /tmp/shadow HISTORY
The GNU shtool mkshadow command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 1998 for Apache. It was later revised and taken over into GNU shtool. SEE ALSO
shtool(1), ln(1). 18-Jul-2008 shtool 2.0.8 SHTOOL-MKSHADOW.TMP(1)