Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Trim the data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Trim the data
# 8  
Old 04-23-2013
sorry i missed it,below is correct one.

src_SPS_d_Call_Center_Reporting_20130417_001.dat
src_SPS_d_Comment_Tran_File_20130417_001.dat
src_SPS_d_Corp_Adv_Tran_File_20130417_001.dat
src_SPS_d_Letter_Tran_File_20130417_001.dat
src_SPS_d_Loan_Level_File_20130417_001.dat
src_SPS_d_Payment_Tran_File_20130417_001.dat

---------- Post updated at 04:57 AM ---------- Previous update was at 04:47 AM ----------

sorry i missed it,below is correct one

src_SPS_d_Call_Center_Reporting_20130417_001.dat
src_SPS_d_Comment_Tran_File_20130417_001.dat
src_SPS_d_Corp_Adv_Tran_File_20130417_001.dat
src_SPS_d_Letter_Tran_File_20130417_001.dat
src_SPS_d_Loan_Level_File_20130417_001.dat
src_SPS_d_Payment_Tran_File_20130417_001.dat
# 9  
Old 04-23-2013
Code:
$ cat input
src_SPS_d_Call_Center_Reporting_20130417_001.dat
src_SPS_d_Comment_Tran_File_20130417_001.dat
src_SPS_d_Corp_Adv_Tran_File_20130417_001.dat
src_SPS_d_Letter_Tran_File_20130417_001.dat
src_SPS_d_Loan_Level_File_20130417_001.dat
src_SPS_d_Payment_Tran_File_20130417_001.dat

Code:
$ sed -e "s/src_SPS_d_//" -e "s/_File_[0-9_]*.dat/.txt/" -e "s/_Reporting_[0-9_]*.dat/.txt/" input
Call_Center.txt
Comment_Tran.txt
Corp_Adv_Tran.txt
Letter_Tran.txt
Loan_Level.txt
Payment_Tran.txt

Or, using a separate script file:
Code:
$ cat script
s/src_SPS_d_//
s/_File_[0-9_]*.dat/.txt/
s/_Reporting_[0-9_]*.dat/.txt/

Code:
$ sed -f script input
Call_Center.txt
Comment_Tran.txt
Corp_Adv_Tran.txt
Letter_Tran.txt
Loan_Level.txt
Payment_Tran.txt
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trim Space

In Shell, I have output of a unix command as test1 test2015 but I want it as test1 test2015 can anyone help me out. Use code tags, thanks. (3 Replies)
Discussion started by: OscarS
3 Replies

2. Shell Programming and Scripting

How to trim the zero's after decimal?

Hello all, I have an XML with below content from which i need to remove the trailing zeros, like 123.00 should be converted to 123 and 123.01200 to 123.012 Below is the sample excerpt data from XML file. My input file size could be approximately 5 GB or less. CURRENT:... (10 Replies)
Discussion started by: Ariean
10 Replies

3. Shell Programming and Scripting

Trim String

Hi, I wish to grep everything before the last "/bin" in the following string /opt/app/bin/app1/jdk150_07/bin/IA64N/java Desired output: "/opt/app/bin/app1/jdk150_07" Kindly help ... (2 Replies)
Discussion started by: mohtashims
2 Replies

4. Shell Programming and Scripting

Help with awk trim

I am trying to trim spaces for the fixed width file starting from location 129 and of length 20. I am expecting only around 40 records that will have length greater than 9. But i am getting around 4000 records. Please help me correct the following. nawk '{if (a=length(gsub(/... (2 Replies)
Discussion started by: pinnacle
2 Replies

5. Shell Programming and Scripting

Trim Filename

Hi All, I have a file named as FAB1_600015_CONRAD.A0_7XYZ12345.000_LT-SWET.01_LTPA25L_20110622-161429_07_WFR12345_20110622-161429_20110712-125228.data.dis I want to generate a directory taking only the 7XYZ12345.000_WFR12345 The length and format of the Filename will be the same... (2 Replies)
Discussion started by: asheshrocky
2 Replies

6. Shell Programming and Scripting

Trim a new line

Okay, I am trying to make a bash script to get a certain domains IP address (my home ip). My home is on a DHCP lease from my ISP, so I cannot always trust the IP address to remain constant. This is what I have so far for it: alias ip-home="ping -c 1 example.com | grep 'PING' | cut -d'(' -f2 |... (5 Replies)
Discussion started by: tnanek
5 Replies

7. Shell Programming and Scripting

trim and compare

1) I want to trim the zeros of the 1st file so they match the second file 2) run an automatic diff and error in lines that dont match File1 0.8035500 1.4138000 1.6381500 1.9256110 3.8075000 13.3270000 13.4155000 94.2700000 937.7000000 File2 0.80355 1.4138 1.63815 3.8075 1.925611... (5 Replies)
Discussion started by: sigh2010
5 Replies

8. Shell Programming and Scripting

trim lines

I want to delete all lines from 1 till a certain line. how to do that without redirection to another file (tail solution)? thanx (6 Replies)
Discussion started by: melanie_pfefer
6 Replies

9. Shell Programming and Scripting

trim letters

Hello, I have a list of words.. ranging from 4 to any characters long.. to not more than 20 though. How can I select only first seven letters of the list of words? example:- wwwwwwwwww eeeee wererreetf sdsarddrereewtewt sdsdsds sdsd ereetetttt ewtwertwrttrttrtrtwtrww I... (10 Replies)
Discussion started by: fed.linuxgossip
10 Replies

10. Shell Programming and Scripting

Trim

Hello, I am passing a filename to a script to draw parameters from it. However, I want to use part of the filename as a parameter. The filename is transfer_ccf_3731_10.sh but I only need the 3731_10 part of it. Is this possible? Any help or suggestions would be appreciated! Regards, J. (4 Replies)
Discussion started by: JWilliams
4 Replies
Login or Register to Ask a Question