12-11-2008
pattern matching with comma delimited text
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
PADG_05295
PADG_01010
PADG_01141
PADG_02836
PADG_04289
PADG_08126
PADG_05265
PADG_00557
PADG_05676
PADG_03527
PADG_00102
PADG_07457
PADG_03012
PADG_05018
PADG_04985
PADG_07697
file 2:
PADG_04295
PADG_04294
PADG_04293
PADG_01010,PADG_04292
PADG_04291
PADG_04289
PADG_04288
PADG_04287,PADG_02886,PADG_07699
PADG_04286
PADG_04285
PADG_04284
PADG_04283
PADG_04281
PADG_03285
PADG_04280
PADG_04279
PADG_04278
Desired output:
PADG_01010,PADG_04292
PADG_04287,PADG_02886,PADG_07699
PADG_04289
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days.
The format is like this:
dirA,5
dirB,7
How do I write script to iteratively parse this text file & delete... (5 Replies)
Discussion started by: chengwei
5 Replies
2. Shell Programming and Scripting
I have a file which contains blocks of text - each block is a multi-lines text delimited by blank lines eg.
<blank line>
several lines of text
...
pattern found on this line
several more lines of text
...
<blank line>
How do you delete the block of text (including the blank lines) when... (17 Replies)
Discussion started by: gleu
17 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. Shell Programming and Scripting
Hi guys,
I need help:
I started receiving automatic emails containing download information. The problem is that these emails are coming in a rich format (I have no control of this) so the important information is buried under a bunch of mumbo-jumbo. To complicated things even further I need to... (10 Replies)
Discussion started by: caprica13
10 Replies
5. Shell Programming and Scripting
Can someone please assist me, I'm trying to get vi to remove all the occurences of the text in a file i.e. "DEVICE=/dev/mt??". The "??" represents a number variable. Is there a globel search and delete command that I can use?
Thank You in Advance. (3 Replies)
Discussion started by: roadrunner
3 Replies
6. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 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
matcheditor
MatchEditor(3I) InterViews Reference Manual MatchEditor(3I)
NAME
MatchEditor - StringEditor with pattern matching
SYNOPSIS
#include <InterViews/matcheditor.h>
DESCRIPTION
MatchEditor is a StringEditor subclass that checks the validity of its contents against a specified pattern. It is suitable for entering
strings that must conform to a particular format such as a number or a file name. The matching pattern is specified according to the rules
of scanf(3). For example, a pattern of "%3d" will match a 3-digit integer, a pattern of "%[ab]" will match a string containing only a's
and b's, and a pattern of "(%f, %f)" will match the string "(12.0, 5E23)".
PUBLIC OPERATIONS
MatchEditor(ButtonState*, const char* sample, const char* done)
Create a new MatchEditor object. The ButtonState, sample string, and termination string are passed to the StringEditor constructor.
void Match(const char* pattern, boolean keystroke = true)
Specify the pattern to match against. When MatchEditor performs matching, it will highlight any trailing part of the edit string
that does not conform to pattern. The user can then correct the string. If keystroke is true, matching will occur on every key-
stroke; otherwise matching will only occur on the completion of the edit. The initial pattern matches any string, and the initial
value of keystroke is true.
RESTRICTIONS
MatchEditor uses sscanf internally to check the pattern match. Different versions of sscanf have different scanning capabilities; check
with your local version to see what patterns you can use.
SEE ALSO
StringEditor(3I)
InterViews 7 Dec 1989 MatchEditor(3I)