extracting delimiter from a file.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extracting delimiter from a file.
# 1  
Old 11-29-2010
Question extracting delimiter from a file.

hi, pls someone tell me how to extract delimiters from any file and pass it to a unix script.since, im a beginner in unix i find it little bit difficult.how to use awk to do this?
# 2  
Old 11-29-2010
Error do u want to extract all the delimiters or any specific one?

let me know...........
# 3  
Old 11-29-2010
hmmm....

A "delimiter" is not to be found out by any means. It is, what you *define* as delimiter.

consider the following file:

Code:
field1 ,| field2 | field3 ,|
field1 ,| field2 | field3 ,|
field1 ,| field2 | field3 ,|

You could define "|" as a delimiter. Then you would have 3 fields, separated by "|", which read "field1 ,", "field2 ," and "field3 ,". You could also define "," as a field separator, which would leave you with 3 fields per line, "field1 ", "| field2 | field3 " and "|".

There is no "correct" solution to it, you could define every other character as a delimiter too.

I hope this helps.

bakunin
# 4  
Old 11-29-2010
suppose, i have a file in which im unaware of the delimiter of it.so ,is it possible to extract a text between the delimiter ,without knowing what delimiter it is..give an example for clear understanding.
# 5  
Old 11-29-2010
Quote:
Originally Posted by sureshmit
suppose, i have a file in which im unaware of the delimiter of it.so ,is it possible to extract a text between the delimiter ,without knowing what delimiter it is..give an example for clear understanding.
If I tell you that I have kept money for you in my house and if you don't know where my house is. Do you think you can get the money?

The same thing goes for the delimeter...Smilie
# 6  
Old 11-29-2010
Just do a cat on the file and look to see what character separates the fields. It will most likely be a comma, space, pipe, tab, or slash.

Code:
$ cat myfile
field1|field2|field3
$ cat myfile2
field1,field2,field3

In myfile | is the delimeter. In myfile2 , is the delimeter.

Last edited by ilikecows; 11-29-2010 at 08:31 AM.. Reason: Typo
# 7  
Old 11-30-2010
Quote:
Originally Posted by ilikecows
In myfile | is the delimeter. In myfile2 , is the delimeter.
Sorry, but this is nonsense, as i have shown above. A "delimiter" is whatever you define to be a delimiter and it is completely arbitrary.

bakunin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. UNIX for Dummies Questions & Answers

Getting the folder name and file name after delimiter

Hi, I have a input /dev/cm/test1.txt /qa/tm/hmkr/cc/test2.txt and I need an out like below foldername, filename /dev/cm/,test1.txt /qa/tm/hmkr/cc/,test2.txt I tried with awk $NF, but I'm getting the filenames and not folder names. Please let me know how to achive the above... (5 Replies)
Discussion started by: somu_june
5 Replies

3. Shell Programming and Scripting

Extracting Delimiter 'TAG' Data From log files

Hi I am trying to extract data from within a log file and output format to a new file for further manipulation can someone provide script to do this? For example I have a file as below and just want to extract all delimited variances of tag 32=* up to the delimiter "|" and output to a new file... (2 Replies)
Discussion started by: Buddyluv
2 Replies

4. 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

5. UNIX for Advanced & Expert Users

File Delimiter

Hi All, I woul like to know with out opening a file in unix ,how we can find out what is the delemeter in that file... Thanks.. edit by bakunin: changed thread title to "delimiter" so it can be found. (4 Replies)
Discussion started by: raju4u
4 Replies

6. 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

7. Shell Programming and Scripting

Delimiter in output file

Hello, I am trying to find the record count in a specific folder, Here is the part of the code =========================== STARTDATE=`date +"%y%m%d%H%M"` for i in `ls *.DAT` do wc -l $i >> /XYZ/SrcFiles/"Record_counts"$STARTDATE.csv ... (2 Replies)
Discussion started by: Shanks
2 Replies

8. UNIX for Dummies Questions & Answers

How to change delimiter in my file ?

Hi I have a file in which delimiter is ';' However if the delimiter is within "" it is a part of the string and not delimiter. How to get the fields ? I want to replace the delimiter ';' to '|'. The file contains data like this : 11111; “2222 2222”; “3333; 3333”; “4444 ""44444” The file... (2 Replies)
Discussion started by: dashing201
2 Replies

9. Shell Programming and Scripting

need help extracting values from string separated by a delimiter

hi guys, basically what i'm trying to do is fetching a set of columns from an oracle database like so... my_row=`sqlplus -s user/pwd << EOF set head off select user_id, username from all_users where rownum = 1; EOF` echo $my_row the code above returns... 1 ADSHOCKER so then i... (3 Replies)
Discussion started by: adshocker
3 Replies

10. 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
Login or Register to Ask a Question