Extract data based on position

Shell Programming and Scripting
1

The file has record length 200. And i have 100 search strings which are ten digits of character from 1 to 10 characters all of them are unique, they need to searched in a file. Please help me to pull the records based on position (say from 1-10).
test data

 
1FAHP2DW0BG115206RASHEED                        ABDALAZYZ                                                                  SAU2011PH    TWQE      9B040 RIYADH              A12010-11-072010-11-08K0K22                                                                                                            0555211674          
1FAHP2DW0BG120728MILHEM                         AL JOBIL                           033623707                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-012010-11-07K0K22                                                                                                            0567489990          
1FAHP2DW1BG115148SAWAD                          ALAWAMI                            026211449                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-062010-11-07K0K22                                                                                                            0555518986          
1FAHP2DW1BG115165ABRAHIM                        SAQR                               014264836                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-092010-11-10K0K22                                                                                                            0505255296          
1FAHP2DW2BG110041MOHAMMAD                       AL SALAMA                          038605655                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-072010-11-08K0K22                                                                                                            0500707095          
1FAHP2DW2BG115174MOHAMMED FAHED                 ABDULLAZIZ                                                                 SAU2011PH    TWQE      9B040 RIYADH              A12010-11-092010-11-10K0K22                                                                                                            0530001551          
1FAHP2DW3BG118889TORKEE                         ABAD ALKAREEM                      0565550099                              SAU2011PH    TWQE      9B040 RIYADH              A12010-11-042010-11-07K0K22                                                                                                            0555550099          
1FAHP2DW3BG126622MOSAB                          ALGTHAMI                           027290078                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-062010-11-07K0K22                                                                                                            0505704557          
1FAHP2DW4BG110090ASEM                           EZAT                               026602012                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-022010-11-07K0K22                                                                                                            0565656323          
1FAHP2DW4BG115192AL MULHIM                      AUTO SERVICE                                                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-082010-11-09K0K22                                                                                                            0590221522          
1FAHP2DW4BG126631MOHAMMED                       HMEED                              026791887                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-082010-11-09K0K22                                                                                                            0554625854          
1FAHP2DW5BG110017AL MULHIM                      AUTO SERVICE                                                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-092010-11-10K0K22                                                                                                            0590221522          
1FAHP2DW5BG115220ABDULALAH                      ABDULAH                                                                    SAU2011PH    TWQE      9B040 RIYADH              A12010-11-042010-11-07K0K22                                                                                                            0506722882          
1FAHP2DW5BG120725MAHER                          MOHAMAD                            025482574                               SAU2011PH    TWQE      9B040 RIYADH              A12010-11-092010-11-10K0K22                                                                                                            0567511759          
1FAHP2DW6BG110057ZHER                           SOLIMAM                                                                    SAU2011PH    TWQE      9B040 RIYADH              A12010-11-092010-11-10K0K22                                                                                                            0556286929          
1FAHP2DW6BG115176NASER                          ABDALLAH                                                                   SAU2011PH    TWQE      9B040 RIYADH              A12010-11-082010-11-09K0K22                                                                                                            0502832959
2 
awk ' FNR == NR { a[$0]=1; next } a[substr($0,1,10)] } ' search_string_file input_file
3

Thanks for your reply. While executing above command i get following error message. I just tried by adjusting curly braces but again i get error.

awk: FNR == NR { a[$0]=1; next } a[substr($0,1,10)] }
awk: ^ syntax error

4

Looks like a typo in the command, this fixes syntax error:

awk ' FNR == NR { a[$0]=1; next } a[substr($0,1,10)] ' search_string_file input_file

Note: It wasn't clear from your description where the search should be looking, the above code checks the first 10 chars of input_file for a match with the search strings. If a search string isn't exactly 10 chars long it wont match anything.

If all you want is a match anywhere on the line you could use grep

grep -f search_string_file input_file
5

@Chubler :

If the matching is similar, then consider the following example
(we can then proceed by analogy adapting the matching to our needs)

[ctsgnb@shell ~]$ cat mys
toto
bla
124
125
[ctsgnb@shell ~]$ cat myfile
134512345 toto whateva
124523043 hhhh nothing
123512344 anyword bla
125412450 hshs juju
124452344 titi bla
123451345 hhhhhhh tatat
[ctsgnb@shell ~]$ sed 's/.*/^&/' mys
^toto
^bla
^124
^125
[ctsgnb@shell ~]$ sed 's/.*/^&/' mys | grep -f - myfile
124523043 hhhh nothing
125412450 hshs juju
124452344 titi bla
[ctsgnb@shell ~]$

another one :

[ctsgnb@shell ~]$ cat myfile
134512345 toto whateva
124523043 hhhh nothing
124599943 bla nothing
123512344 anyword bla
125412450 hshs juju
124452344 titi bla
123451345 hhhhhhh toto
125412450 bla juju
125412450 toto juju
[ctsgnb@shell ~]$ cat mys
toto
bla
124
125
[ctsgnb@shell ~]$ sed 's/.*/^.\\{10\\}&/' mys | grep -f - myfile
134512345 toto whateva
124599943 bla nothing
125412450 bla juju
125412450 toto juju
[ctsgnb@shell ~]$

so

sed 's/.*/^&/' patternfile | grep -f - mydatafile
6

Perfect... All three works as expected.. Thank you all!

7

hi ,
while doing FTP from mainframe to unix if the file we are sending is already existing in the server ,it is getting replaced.when i used sunique command,its not replacing but stil creates a copy of the file with .1 to .99 extension.is there any way to abort the file transfer if the file is already existing in the unix server 'without creating another copy'?
can u plz help me on this.
thanks in advance