Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help required with a file rename shell script
Top Forums Shell Programming and Scripting Help required with a file rename shell script Post 303036417 by tayyabq8 on Tuesday 25th of June 2019 10:35:26 AM
Old 06-25-2019
Hi RudiC,

Sorry for the confusion and providing the wrong file format and image file names, here is the sample from csv file:

Code:
tayyab@c549:~$ cat test.csv
Full Registration,VIN,Stock ID,Mileage,InternalTrim,Description,Warranty,FranchiseApproved,RegistrationDate,Featured,NewVehicleType,Used stock images
2653BA,WDD1173461N6437866,2795,19434,Leather trim,A Class,Y,Y,19/09/2018,N,CAR,
8874MS,WDD1173461N6494217,2745,15452,Leather trim,A Class,Y,Y,19/09/2018,N,CAR,

And here is the list of images:

Code:
tayyab@c549:~$ ls -ltr 00*
-rw-rw-rw- 1 tayyab tayyab 0 Jun 25 17:59 002795_001.jpg
-rw-rw-rw- 1 tayyab tayyab 0 Jun 25 17:59 002795_002.jpg
-rw-rw-rw- 1 tayyab tayyab 0 Jun 25 18:00 002795_003.jpg
-rw-rw-rw- 1 tayyab tayyab 0 Jun 25 18:27 002745_001.jpg
-rw-rw-rw- 1 tayyab tayyab 0 Jun 25 18:27 002745_002.jpg

Once I ran the shell script, i want test.csv file to be like:
Code:
tayyab@c549:~$ cat test.csv
Full Registration,VIN,Stock ID,Mileage,InternalTrim,Description,Warranty,FranchiseApproved,RegistrationDate,Featured,NewVehicleType,Used stock images
2653BA,WDD1173461N6437866,2795,19434,Leather trim,A Class,Y,Y,19/09/2018,N,CAR,WDD1173461N6437866_1, WDD1173461N6437866_2,WDD1173461N6437866_3
8874MS,WDD1173461N6494217,2745,15452,Leather trim,A Class,Y,Y,19/09/2018,N,CAR,WDD1173461N6494217_1,WDD1173461N6494217_2

And also file names to be renamed to as follows:

Code:
WDD1173461N6437866_1 
WDD1173461N6437866_2
WDD1173461N6437866_3
WDD1173461N6494217_1
WDD1173461N6494217_2

there have to be two steps

i) Look for stock ID within the stock feed csv file and rename all the images (replace stock ID with VIN code)
ii) Once the files are renamed then append those JPG images (with VIN# and _1, _2) to the last column of the feed file.


Your code didn't work out for me if you or someone else can provide me with a solution to the above challenge that'll be great. Thanks.

Regards,
Tayyab
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Urgent help required in deleting a line without opening a file usinga shell script

Hi, I need a help in deleting a line matching a particular pattern in a file using shell script without opening the file. The file is a .c/.cpp file. Is it possible? Thanks (6 Replies)
Discussion started by: naan
6 Replies

2. Shell Programming and Scripting

shell script required

hi , i need a shell script that will remove the first and second lines of the text file and will list the word count of the characters present in it. the text file will be consisting of multiple textfiles.the first text file starts from 01-34.like wise the next file also starts from 01-34... (4 Replies)
Discussion started by: sethunath
4 Replies

3. Linux

shell script required

Hi, iam presenting the input text file format.Of this i need the character count of the number of characters present in each file.The attached file is a combination of 3 text file.each text file starts at record 1 - 34, then the next tetx file starts. What i need is the character count of each... (1 Reply)
Discussion started by: sethunath
1 Replies

4. Shell Programming and Scripting

Shell script help required

Hi, Can someone help me with this small piece of code. DIRNAME=$(dirname $0) BASENAME=$(basename $0) DATA="${DIRNAME}/${BASENAME}.data" && . $DATA whats is meant by && . $DATA here... Regards, Abhishek (2 Replies)
Discussion started by: max29583
2 Replies

5. UNIX for Dummies Questions & Answers

Shell script to rename or change file extension case.

I searched the forum, but there was different type of rename. Hello. I have files in folder. Like: xxxxxxxx1.html or xxxxxxxx2.txt or xxxxxxxx3.tar.gz and how to rename or change file extension case to xxxxxxxx1.htm or xxxxxxx2.TXT or (5 Replies)
Discussion started by: Sheldon
5 Replies

6. UNIX for Advanced & Expert Users

Rename a file to a file_current datetime in a shell script

Hi all, Could anyone suggest me on Renaming a file to a file_current datetime in a shell script. (3 Replies)
Discussion started by: Nithin
3 Replies

7. Shell Programming and Scripting

write shell script to rename file

hi, I need some help in writing shell script in a bourne shell.I am trying to rename the file.. eg. find /root/data -type f -name "text*) | while read FILES do newfile=${FILES/type_2.0_20101208_34.xml / tmp.xml} mv "$FILES" "$newfile" done above written script is working...If the... (7 Replies)
Discussion started by: shubhig15
7 Replies

8. Shell Programming and Scripting

Shell script is required

Dear All I have a filelisting as below: abcd_20110715_0007 abcd_20110715_0010 abcd_20110716_0001 abcd_20110716_0004 abcd_20110715_0008 abcd_20110715_0011 abcd_20110716_0002 abcd_20110716_0005 abcd_20110715_0009 abcd_20110715_0012 abcd_20110716_0003 abcd_20110716_0006 ... (3 Replies)
Discussion started by: at1700
3 Replies

9. Shell Programming and Scripting

help required with shell script

Hi, My input file as follws $ cat 1.txt ------- a aa aaa 11 b bb bbb 22 I am able to extract first and last column of a given line as follows. $ nawk '{print $1}' FS= RS= 1.txt | awk '{ $NF = ""; print }' a $ nawk '{print $1}' FS= RS= 1.txt | awk '{ print $NF}' 11 however, the... (4 Replies)
Discussion started by: bala123
4 Replies

10. UNIX for Dummies Questions & Answers

Shell script required

Hi, I need shell script for getting the date in format from below text output IP IS 10.238.52.65 pun-ras-bng-mhs-01#show conf port 2/4 Building configuration... Current configuration: ! card ge3-4-port 2 ! port ethernet 2/4 no shutdown encapsulation dot1q (7 Replies)
Discussion started by: surender reddy
7 Replies

LEARN ABOUT DEBIAN

mcpmv

MRENAME(1)						      General Commands Manual							MRENAME(1)

NAME

       mrename - program to rename files

SYNOPSIS

       mrename 'pattern' prefix [option]

DESCRIPTION

       This  manual  page  documents  briefly the mrename command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       mrename is a tool for easy and automatic renaming of many files.  The 'pattern' is the pattern to search files to rename (quoted  to  avoid
       that  bash  resolve  it),  and prefix is the prefix that will be added to the name of each file. The two alternative options for copying or
       moving files in the new name are explained below.  All parameters are needed, and you have to stay and launch the script in the same direc-
       tory of the files to be renamed. The program should be able to write in this directory.

OPTIONS

       There are only the following three options.

       -c     The option -c will copy each file with the new filename.

       -m     The option -m will move each file in the new filename.

       -h     Display help.

EXAMPLE

       If  you	have  a  directory  with two jpeg images prof.jpg and forp.jpg and you want to add them a prefix like item0, item1 etc..  (that is
       item0prof.jpg, item1forp.jpg etc..) do this:

	  cd /path/to/the/images
	  mrename '*.jpg' item -c

       to copy each matching file into another with the new name

	  mrename '*.jpg' item -m

       to rename each file without keeping a copy with the previous name

Word-Wide-Web:
       http://alfalinux.sourceforge.net/mrename.php3

AUTHOR
:
       Giancarlo -rofus- Erra
       e-mail: rofus@mindless.com

       This manual page was written by Dr. Guenter Bechly <gbechly@debian.org>, for the Debian GNU/Linux system (but may be used by others). It is
       distributed under the GPL just like mrename itself.

								 October  22, 2000							MRENAME(1)
All times are GMT -4. The time now is 11:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy