Return the list of file name prefix with first 6 character Post: 302897921

Sponsored Content

Top Forums Shell Programming and Scripting Return the list of file name prefix with first 6 character Post 302897921 by Don Cragun on Thursday 17th of April 2014 01:43:49 AM

04-17-2014

Registered User

I think RudiC meant colrm 7 instead of colrm 6, but even with that, it doesn't get rid of duplicates in the resulting array.

The following script shows what happens when setting the array using colrm 6, colrm 7 | sort -nru, and for systems where colrm is not available, sed | sort -nru:

Code:

#!/bin/ksh
function pvar {
	i=0
	while [ $i -lt ${#var[@]} ]
	do	printf "var[%d]=%s\n" $i "${var[i]}"
		((i++))
	done
}
printf "Using colrm 6:\n"
var=( $(ls *.txt | colrm 6) )
pvar

printf "\nUsing colrm 7 & sort -nru:\n"
var=( $(ls *.txt | colrm 7 | sort -nru) )
pvar

printf "\nUsing sed & sort -nru:\n"
var=( $(ls *.txt | sed 's/\(......\).*/\1/' | sort -nru) )
pvar

and, on a system with both colrm and sed when run in a directory containing the four text files shown in the 1st message in this thread, produces the output:

Code:

Using colrm 6:
var[0]=20131
var[1]=20131
var[2]=20140
var[3]=20140

Using colrm 7 & sort -nru:
var[0]=201401
var[1]=201312
var[2]=201311

Using sed & sort -nru:
var[0]=201401
var[1]=201312
var[2]=201311

Array variables aren't defined by the standards, but this script should with with any ksh or bash. It was tested with both ksh and bash on OS X Version 10.9.2.

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Test return character.

Hi, in my korn shell I have this code: typeset -uL1 rc read rc?"Insert Y=Yes (default) or N=No >>" If I press enter without value I wish to set rc=Y. This is my default. This test: if ] then .... Do not work. I hope in your help. Thanks in advance. Regards, Giovanni

2. Shell Programming and Scripting

Substituting carriage return followed by newline character - HELP

-------------------------------------------------------------------------------- Hi All I have a field being returned from the DB that when opened in Vi shows a ^M before the rest of the field is displayed on the next line. I need it so that the only newline character is the end of the...

3. Shell Programming and Scripting

sed and character return problem

Hi, I have a problem with sed. It doesn't recognize the "\n" character. It substitudes an "n", instead of introducing a new line. This doesn't happend with print $ print "test \n \n" (it deos introduce two lines after hello) (AIX) $ sed s/bc/\n/g test.1 >test.2 $ cat test.1 bcdefg...

4. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you...

5. UNIX for Dummies Questions & Answers

how to search and list file with wildcard character

hi, I want to search all files in the current working direcotry and to print in comma (,) seperated output. But I have two patterns to search for. Files will be in ABC20100508.DAT format. Search should happen on the format (ABC????????.DAT) along with date(20100508). I can do a ls...

6. Shell Programming and Scripting

Return part of string after X numbers of a character

My input strings look something like this: /dev/vs/dsk/group/vol I want to print just "group" out of the line... which is always found between the 4th and 5th "/" in the string. I figure I have to use awk, sed, or some combination to do this, but I've searched the forums and can't find...

7. UNIX for Dummies Questions & Answers

Grep to return lines not containing a character

Hello , this is my first topic cause I need your little help:( I got .txt file, and I want to find lines without letter 'a', so im writing: grep "" list.txt (list.txt is the file of course) and i have no idea why it's not working because it shows lines with a.

8. Shell Programming and Scripting

AWK adding prefix/suffix to list of strings

75 103 131 133 138 183 197 221 232 234 248 256 286 342 368 389 463 499 524 538

9. Shell Programming and Scripting

Common prefix of a list of strings

Is there a simple way to find the longest common prefix of a space-separated list of strings, optionally by field? For example, given input: "aaa_b_cc aaa_b_cc_ddd aaa_b_cc aaa_b_cd"with no field separator, output: aaa_b_cwith _ field separator, output: aaa_bI have an awk solution which...

10. Shell Programming and Scripting

Extract Uniq prefix from a start and end prefix

Dear All, assume i have a file with content: <Start>6000</Start> <Stop>7599</Stop> the output is: 6000 7000 7100 7200 7300 7400 7599 how should we use any awk, sed, perl can do this task, means to extract the uniq prefixes from the start and stop prefix. Thanks Jimmy

LEARN ABOUT SUSE

column

COLUMN(1)						    BSD General Commands Manual 						 COLUMN(1)

NAME

     column -- columnate lists

SYNOPSIS

     column [-tx] [-c columns] [-s sep] [file ...]

DESCRIPTION

     The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file operands, or, by
     default, from the standard input.	Empty lines are ignored.

     The options are as follows:

     -c      Output is formatted for a display columns wide.

     -s      Specify a set of characters to be used to delimit columns for the -t option.

     -t      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default, or with
	     the characters supplied using the -s option.  Useful for pretty-printing displays.

     -x      Fill columns before filling rows.

     Column exits 0 on success, >0 if an error occurred.

ENVIRONMENT

     COLUMNS  The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

	   (printf "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME
" 
	   ; ls -l | sed 1d) | column -t

SEE ALSO

     colrm(1), ls(1), paste(1), sort(1)

HISTORY

     The column command appeared in 4.3BSD-Reno.

AVAILABILITY

     The column command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.

BSD
								   June 6, 1993 							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Test return character.

Discussion started by: gio123bg

2. Shell Programming and Scripting

Substituting carriage return followed by newline character - HELP

Discussion started by: djkane

3. Shell Programming and Scripting

sed and character return problem

Discussion started by: Santiago

4. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Discussion started by: phoeberunner