How To Neglect Delimiter


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How To Neglect Delimiter
# 1  
Old 10-17-2008
Question How To Neglect Delimiter

Hi all
Iam having a text file of records seperated by "SPACE"
and another text File of Records seperated by "TAB"
i'm writing a Generic code for Extracting Duplicate Records
Iam using "cut" Command to extract data.

How Can I Neglect Delimiter And write a generic code for all cases


Any one help me by providing a solution

By
G.Aavudai Nayagam
# 2  
Old 10-17-2008
Maybe have a look into awk - it's very handy for use with fields since it's default field separator is any kind of blank/space/tab etc. But whatever tool you are using, you will always have to tell it by what fields are separated.

Last edited by zaxxon; 10-17-2008 at 09:08 AM..
# 3  
Old 10-17-2008
Quote:
Originally Posted by zaxxon
Maybe have a look into awk - it's very handy for use with fields since it's default field separator is any kind of blank/space/tab etc. But whatever tool you are using, you will always have to tell it by what fields are separated.

Ok
Thanks For ur reply

Is there any way to convert a delimiter (space/tab/pipe)
to another while retriving data.

for Ex: If its space delimited can i convert it to pipe before writing into another file.

By
G.Aavudai Nayagam
# 4  
Old 10-17-2008
As I already said, you should have a look into the 1001 awk manuals, tutorial etc. on the net. There is the OFS, output field separator. No offense, but I think a look into the basic mechanics of awk will be a good thing.

Last edited by zaxxon; 10-17-2008 at 09:24 AM..
# 5  
Old 10-17-2008
Bug

Thanks for ur Reply
i'll search with that.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep and neglect a specific string

Hi, I have a file with "n" number of lines. I need to get rid of a specific line having a specific string from the file. I tried some possibilities but not successful. For ex: in a file named "test" hope should be removed along with the line. ... (8 Replies)
Discussion started by: ricky-row
8 Replies

2. Shell Programming and Scripting

Perl Code to change file delimiter (passed as argument) to bar delimiter

Hi, Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters. Any help would... (2 Replies)
Discussion started by: JPB1977
2 Replies

3. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies

4. Shell Programming and Scripting

how to get everything before the last delimiter?

hi all, i have a string with a number of "/"s as delimiter. and i want everything BEFORE the last delimiter i know to use basename to get everything after the last delimiter. thx a lot! (2 Replies)
Discussion started by: sunnydanniel
2 Replies

5. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43°13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies

6. Shell Programming and Scripting

Help regarding the delimiter

Hi, I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using... (3 Replies)
Discussion started by: smileyreddy
3 Replies

7. Shell Programming and Scripting

Substring based on delimiter, finding last delimiter

Hi, I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies

8. UNIX for Dummies Questions & Answers

How to neglect the rest of tests if crushing in the middle in Expect/Tcl

hi, everyone: I am a newbie in Expect/Tcl. I wrote a Expect script to run some diagnostic tests in 2 OS. Basically, It is like: OS1: test1, test2..........test 10 (script 1) OS2: test11,................test 20 (script 2) ideally, it should check all tests in OS1 first,... (0 Replies)
Discussion started by: allenxiao7
0 Replies

9. UNIX for Dummies Questions & Answers

Delimiter

I am having the following file. I need to insert a delimiter in this file. I used sed but its not working. AAABBB 9 JJJ AAABBC 9 TTTTT AAABBA 8 JJJ AAABBC 7 TTTTT AAABBC 6 TTTTT Now i want the output file as: AAA|BBB| |9| |JJJ| AAA|BBC| |9| | |TTTTT| (3 Replies)
Discussion started by: sivakumar.rj
3 Replies

10. Shell Programming and Scripting

from - to delimiter

hey guys can you please help me out, i'm having problem in cutting strings. I need a delimiter to cut string. sample a.txt "ID", "1234" , "iam bighippo", "help!" "ID", "1235" , "again0", "xxxxxxx1" "ID", "1236" , "again1", "xxxxxxx2" "ID", "1237" , "again2", "xxxxxxx3" how do... (6 Replies)
Discussion started by: bighippo
6 Replies
Login or Register to Ask a Question