Help parse comma separated list


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help parse comma separated list
# 8  
Old 10-26-2010
@rbatte1
Unfortunately none of your scripts actually produce the correct result.
On my tests $var2 is always blank.
# 9  
Old 10-26-2010
If you want time, skip the tail and the r of the ls!
Code:
ls -lt | (
 read x                 # if you have a header to discard, but read below
 while read x
 do
 . . .
 done
 )

No need for -1 on ls, that is automatic on stdout=pipe. No total to discard if you provide a file name list Daily*.

The problem with 'ls Daily_*' and sort is that they sort alpha-numeric binary, so for many files, Daily11 will be after Daily1, Daily2 will be between Daily199 and Daily20. That is why I used sed to spin off the number as a separate sort field, and used sort -n.

The order of find will probably be in directory order! A directory is just a pile of entry name strings and inode numbers in whatever order occurs due to creation, deletion, and further creation.
# 10  
Old 10-26-2010
Quote:
Originally Posted by NoMadBanker
"ls -1 /HOME/Daily_????????.txt | tail -2 | head -1" seems to work like a charm..

Thanks
NMB
Code:
ls -t | head -1

# 11  
Old 10-26-2010
@ctsgnb
Sorry for hijacking your thread for debate.


Quote:
Daily11 will be after Daily1, Daily2 will be between Daily199 and Daily20. That is why I used sed to spin off the number as a separate sort field, and used sort -n.
That may be true for a completely different filenames format.
The suffix here appears to be yyyymmdd which will come out in the chronological order with "ls" (which is why it is such a good choice of suffix).
(It doesn't work with American style yyyyddmm).
I can understand why he O/P has used a full pattern match too. We have very similar scripts for working in a central logs directory.
# 12  
Old 10-26-2010
Sorry, cross-thread head leak! Smilie

Still, no need for -1 when there is a pipe.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Remove duplicates from comma separated list

Hi, I have following input file: niki niki niki1 niki niki2 niki,niki2 niki3 niki,niki3,niki niki4 niki4,blabla niki5 jkjkl niki6 niki60,niki6 I would like to delete lines with identical matches completely and remove the selfmatches in the other lines. ... (2 Replies)
Discussion started by: niki0211
2 Replies

2. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

3. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

4. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

5. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

6. Shell Programming and Scripting

Output of command in comma separated list

Hi; I have an output of a particular command say $command fstl:r-x ajay:r-x how can i get this in comma separated list, eg: fstl:r-x,ajay:r-x Thnks; (4 Replies)
Discussion started by: ajaypadvi
4 Replies

7. Shell Programming and Scripting

Perl script to parse output and print it comma separated

I need to arrange output of SQL query into a comma separated format and I'm struggling with processing the output... The output is something like this: <Attribute1 name><x amount of white spaces><Atribute value> <Attribute2 name><x amount of white spaces><Atribute value> <Attribute3... (2 Replies)
Discussion started by: Juha
2 Replies

8. Shell Programming and Scripting

Parse apart strings of comma separated data with varying number of fields

I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Discussion started by: 2reperry
7 Replies

9. Shell Programming and Scripting

Unix shell script to parse the contents of comma-separated file

Dear All, I have a comma-separated file. 1. The first line of the file(header) should have 4 commas(5 fields). 2. The last line of the file should have 1 comma(2 fields). Pls help me in checking this condition in a shell script. And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies
Login or Register to Ask a Question