Parsing a file that contains 2 types of delimeters


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing a file that contains 2 types of delimeters
# 1  
Old 06-06-2007
Parsing a file that contains 2 types of delimeters

I am trying to write a script and failing miserably. I have a file that looks something like this;

20050924-155819;Backoffice;1037;0;DDT-TCP/IP;;0;Node
20050924-155902;Unknown;1036;0;DDT-TCP/IP;;0;Node
20050924-155922;FrontOffice;1040;5;DDT-

The desired result is one file containing only the date and username (ie; Backoffice) but I can't seem to get around parsing out the numbers afters the date (delimited by -) and the username delimeited by ;

I tried cut and awk and I either get only the date or only the username and now I reallly need help.

Thanks.
# 2  
Old 06-06-2007
Morgado,
See if this works for you:
Code:
cut -d';' -f1,2 input_file | sed 's/-.*;/ /' > output_file

# 3  
Old 06-06-2007
awk works as well
Code:
awk -F'-;'  '{ print $1, $3 }' oldfile > newfile

# 4  
Old 06-06-2007
That's awesome!! It works.

Thanks so much for your help Smilie
# 5  
Old 06-06-2007
Thanks for your reply. Yes that worked too!! I will keep note of these commands for future use. Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort file based on number of delimeters in line

Hi, Need to sort file based on the number of delimeters in the lines. cat testfile /home/oracle/testdb /home /home/oracle/testdb/newdb /home/oracle Here delimeter is "/" expected Output: /home/oracle/testdb/newdb /home/oracle/testdb /home/oracle /home (3 Replies)
Discussion started by: Sumanthsv
3 Replies

2. Shell Programming and Scripting

List file types

Hello everyone - I have a task of listing files from a directory together with their type. I tried using ls -l | file -b or different versions of that but that did not work. I will need this to be in a C shell script that will list the file name, size and type from a directory. I can do... (12 Replies)
Discussion started by: adrianvas12
12 Replies

3. Shell Programming and Scripting

Cp -r except certain file types

the following excludes certain directories successfully cp -r probe/!(dir) /destination I want to exclude certain file types and tried unsuccessfully cp -r probe/!(*.avi) /destination (2 Replies)
Discussion started by: tmf
2 Replies

4. Shell Programming and Scripting

How to delete lines having unmatched delimeters in a file?

Hi, I have a delimited (|) file having millions of rows. Sometime the file comes with less number of delimiters than expected. In this scenario I want to delete the row having unmatched delimiters. Can anyone help me with the command to achieve this? Ex: File1.txt 8039339595113|JIMMY... (2 Replies)
Discussion started by: satyaatcgi
2 Replies

5. Red Hat

Copy certain file types recursively while maintaining file structure on destination?

Hi guys, I have just been bothered by a fairly small issue for some time now. I am trying to search (using find -name) for some .jpg files recursively. This is a Redhat environment with bash. I get this job done though I need to copy ALL of them and put them in a separate folder BUT I also... (1 Reply)
Discussion started by: rockf1bull
1 Replies

6. Shell Programming and Scripting

Reading a FLAT File - No Delimeters

Hi Folks, I have a file without any delimeters and it is a flat file. Example, my raw data looks: x25abcy26defz27ghi..... Now, could you please any one help me to program to split this into variable and create a text file. I want a output as below Name Age Number x 25 abc... (14 Replies)
Discussion started by: Jerald Nathan
14 Replies

7. UNIX for Dummies Questions & Answers

Types of File in a directory

Hello, I have several thousand files with different extensions in a directory. Is there a single command to get what the various extensions are with a single command. Thanks for your help! Best, Guss (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

8. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies

9. Shell Programming and Scripting

Parsing a file that contains 2 types of delimeters

Now that I have a file that looks something like this; 20050926 Unknown 20050926 MUREXFO 20050926 MUREXFO 20050926 MUREXFO 20050926 Unknown 20050926 KADDUSS 20050926 KADDUSS 20050926 KADDUSS 20050926 MUREXFO Is there a way in vi that I can search the file and remove any line... (2 Replies)
Discussion started by: morgadoa
2 Replies

10. Filesystems, Disks and Memory

associated file types

I have a file of type .for extension .In a guui based unix environment like solaris if I double click on that file a specific program designed by me has to run which takes this file as the parameter and exceutes the program. Can anyone help me? (8 Replies)
Discussion started by: nhk_srd
8 Replies
Login or Register to Ask a Question