Script to generate sequence of numbers


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script to generate sequence of numbers
# 1  
Old 09-03-2014
Script to generate sequence of numbers

I need awk script to generate part number sequencing based on data in multiple columns like below

Code:
Input File
---------
Col A|Col B|Col C|
1|a|x|
2|b|y|
 |c|z|
 | |m| 
 | |n|

And out put should be like

Code:
1ax
1ay
1az
1am
1an
1bx
1by
1bz
1bm
1bn
1cx
1cy
1cz
1cm
1cn
2ax
2ay
2az
2am
2an
2bx
2by
2bz
2bm
2bn
2cx
2cy
2cz
2cm
2cn

Thanks

Moderator's Comments:
Mod Comment Please use code tags
# 2  
Old 09-03-2014
Ok. Please post the script you have tried.
# 3  
Old 09-03-2014
Code:
awk -F '|' 'NR == 1{next} $1 !~ /^[ \t]*$/{a[++m]=$1} $2 !~ /^[ \t]*$/{b[++n]=$2} $3 !~ /^[ \t]*$/{c[++p]=$3}
END {for(i=1; i<=m; i++) {for(j=1; j<=n; j++) {for(k=1; k<=p; k++) print a[i] b[j] c[k]}}}' file

# 4  
Old 09-03-2014
Posted by SriniShoo:

Quote:
Code:
awk -F '|' 'NR == 1{next} $1 !~ /^[ \t]*$/{a[++m]=$1} $2 !~ /^[ \t]*$/{b[++n]=$2} $3 !~ /^[ \t]*$/{c[++p]=$3}END {for(i=1; i<=m; i++) {for(j=1; j<=n; j++) {for(k=1; k<=p; k++) print a[i] b[j] c[k]}}}' file
Hello SriniShoo,

Please don't take it wrong, but we should respect other forum member's response as Jim has replied and asked user to come up with what user has tried, so we should wait for user's reponse as our forum's aim is to help people in learning. So it's a request please try to avoid this and try to follow the forum rules as this is the BEST forum I have seen yet. This forum is really a big, nice platform to learn.


Thanks,
R. Singh
# 5  
Old 09-03-2014
Please do not post till the thread owner has replied, thanks
# 6  
Old 09-03-2014
I haven't tried any script..but the echo command did generate the similar output, but I need a script to run it on different set of column & row combinations.
# 7  
Old 09-03-2014
awk script to find duplicate values
awk script for contains search
awk script to replace nth character with comma


So far You have only posted thread asking for awk script without ever thanking those who helped nor even tried to understand the code you were given, and you just come when new post arrive and leave just after..., we are not here to do the work for you, so show us now an awk script since it is what you want, that tries to do what you desire and the output showing what isnt working and maybe then you will be given assistance. Any full solution posted here from now on will just be deleted...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. BSD

Mcookie, pkg -l to generate random sequence

I am setting this thread to this bsd forum, though it may fit into bash. But as using bsd and the terminal, I would like to generate a random sequence of alphanumerical digits, such as I use to do so on linux by typing just mcookiethis one gives me a pretty random password, but it does not on bsd... (0 Replies)
Discussion started by: 1in10
0 Replies

2. Shell Programming and Scripting

Auto generate Line Numbers

How do I generate line numbers in Vi? I have this: ,'04-90020-039N','61423','2GDV00039-0002', SYSDATE); ,'04-90020-040D','61423','2GDV00046-0001', SYSDATE); ,'04-90020-041N','61423','2GDV00038-0002', SYSDATE); ,'04-90020-043D','61423','2GDV00047-0001', SYSDATE);... (3 Replies)
Discussion started by: djehresmann
3 Replies

3. Shell Programming and Scripting

Generate random numbers in script

i want to generate a random number through a script, and even if anyone reads the script, they wont be able to figure out what the random number is. only the person who setup the script would know it. something like this could work: random the full thread is here: ... (13 Replies)
Discussion started by: SkySmart
13 Replies

4. Shell Programming and Scripting

generate a sequence

how can i generate following sequence for a given input 1,2,3,4,5 1->2 2->3 3->4 4->5 1->2,3 1,2->3 2->3,4 2,3->4 3->4,5 3,4->5 1->2,3,4 1,2->3,4 1,2,3->4 (4 Replies)
Discussion started by: vaibhavkorde
4 Replies

5. Shell Programming and Scripting

Need to find the gap in the sequence of numbers

Hi Guys, I have a file with numbers in sequence. The sequence have been broken somewhere.. I need to find out at which number the sequence has been broken... For an example, consider this sequence, it needs to give me output as 4 (as 5 is missing) and 6(as 7 is missing) Thanks for... (3 Replies)
Discussion started by: mac4rfree
3 Replies

6. Shell Programming and Scripting

How to generate a series of numbers

Hi All, I have a requirement where in I have an input as follows:- input=1-4,6,8-10,12-15 I need to explode this range into an output file as follows:- 1 2 3 4 6 8 9 10 12 13 14 15 My input may vary like 1,5-9,11-13,15-17....... (3 Replies)
Discussion started by: rony_daniel
3 Replies

7. UNIX for Dummies Questions & Answers

Generate a Sequence like in Oracle

#!/usr/bin/ksh ValUniqueNo=0 export ValUniqueNo FnGenerateUniqueNo() { (( ValUniqueNo = $ValUniqueNo + 1 )) echo $ValUniqueNo export ValUniqueNo=$ValUniqueNo } echo k1=`FnGenerateUniqueNo` echo k2=`FnGenerateUniqueNo` kindly consider the above script. it is required that when... (1 Reply)
Discussion started by: keshav_rk
1 Replies

8. UNIX for Dummies Questions & Answers

creating sequence numbers in unix

Hi, Is there a way to create sequence numbers in unix i have a set of batches(which contain records) and i want to assign a number to every batch. how can i do that? (1 Reply)
Discussion started by: dnat
1 Replies

9. UNIX for Dummies Questions & Answers

how can i isolate the random sequence of numbers using awk?

as you can see there is a delimiter after c8 "::". Awk sees the rest as fields because it doesn't recognize spaces and tabs as delimiters. So i am basically looking to isolate 20030003ba13f6cc. Can anyone help? c8::20030003ba13f6cc disk connected configured unknown (2 Replies)
Discussion started by: rcon1
2 Replies

10. Shell Programming and Scripting

generate level numbers

Hi... I have a sequence of jobs and its predecessors.. Input Job_Name Predecessor A NULL B1 A B2 A B3 B1 C B3 C B2 So based on these i have to generate the level Number What i mean is Let A be level 1 for B1 to happen it should have done A so B1 level is A+1 = 1+1 = 2 (12 Replies)
Discussion started by: pbsrinivas
12 Replies
Login or Register to Ask a Question

Featured Tech Videos