Hcfyk

In a Latex Table, how can I automatically resize cell heights to account for superscripts?

Quoting Yourself

How to reply this mail from potential PhD professor?

Answer "Justification for travel support" in conference registration form

How can I get a job without pushing my family's income into a higher tax bracket?

Why is C# in the D Major Scale?

Why do money exchangers give different rates to different bills?

How could a planet have most of its water in the atmosphere?

Did we get closer to another plane than we were supposed to, or was the pilot just protecting our delicate sensibilities?

How did Arya get her dagger back from Sansa?

Junior developer struggles: how to communicate with management?

Which industry am I working in? Software development or financial services?

Does this article imply that Turing-Computability is not the same as "effectively computable"?

In a vacuum triode, what prevents the grid from acting as another anode?

How do I tell my manager that his code review comment is wrong?

Manager is threatning to grade me poorly if I don't complete the project

Can Ghost kill White Walkers or Wights?

How can I support myself financially as a 17 year old with a loan?

Can the 歳 counter be used for architecture, furniture etc to tell its age?

How can I close a gap between my fence and my neighbor's that's on his side of the property line?

Would glacier 'trees' be plausible?

If 1. e4 c6 is considered as a sound defense for black, why is 1. c3 so rare?

SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails

Identifying my late father's D&D stuff found in the attic

Extracting names from filename in Bash

bash escaping and find commandUnexpected anwer from the following regex?Removing a string of files with renameExtracting URL links from a FileExtracting specific data in a file using regexExclude directories from inotifywaitHow to specify a filename while extracting audio using youtube-dl?Bash create custom stringRegular expressions VS Filename globbingRegular expression to pull db table names from .sql files

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

4

0

I have a directory filled with thousands of files in the format LastnameFirstnameYYYYMMDD.pdf. The last and first name will always been in title case.

I'd like to extract the last name so I can move these files to a directory structure of first letter of last name/lastname/full filename. Example: DoeJohn20190327 would be moved to D/Doe/DoeJohn20190327

regex

share|improve this question

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Check out 'sed' and 'awk'
  
  – Tintin
  Mar 29 at 4:15
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I'm not sure if the final destination of the file DoeJohn20190327.pdf is like this: D/Doe/DoeJohn20190327/DoeJohn20190327.pdf or D/Doe/DoeJohn20190327/DoeJohn20190327.pdf ?
  
  – Philippe Delteil
  Mar 29 at 15:37
  
  

  
  
  
  

add a comment | 

4

0

I have a directory filled with thousands of files in the format LastnameFirstnameYYYYMMDD.pdf. The last and first name will always been in title case.

I'd like to extract the last name so I can move these files to a directory structure of first letter of last name/lastname/full filename. Example: DoeJohn20190327 would be moved to D/Doe/DoeJohn20190327

regex

share|improve this question

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Check out 'sed' and 'awk'
  
  – Tintin
  Mar 29 at 4:15
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I'm not sure if the final destination of the file DoeJohn20190327.pdf is like this: D/Doe/DoeJohn20190327/DoeJohn20190327.pdf or D/Doe/DoeJohn20190327/DoeJohn20190327.pdf ?
  
  – Philippe Delteil
  Mar 29 at 15:37
  
  

  
  
  
  

add a comment | 

I have a directory filled with thousands of files in the format LastnameFirstnameYYYYMMDD.pdf. The last and first name will always been in title case.

I'd like to extract the last name so I can move these files to a directory structure of first letter of last name/lastname/full filename. Example: DoeJohn20190327 would be moved to D/Doe/DoeJohn20190327

regex

share|improve this question

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

share|improve this question

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

share|improve this question

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

edited Mar 30 at 5:21

Peter Mortensen

1,03221016

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

asked Mar 29 at 4:14

Joseph MoorJoseph Moor

211

2 Answers
2

active

oldest

votes

5

Here you have a solution. I tested it an it creates the folders as you explained.

for filename in *.pdf
do
 echo "Processing file $filename "
 first_letter="$filename:0:1"
 mkdir -p $first_letter #if already exists won't print error
 last_name=$(echo $filename | sed 's/([^[:blank:]])([[:upper:]])/1 2/g' |awk 'print $1')
 mkdir -p $first_letter/$last_name
 mv $filename $first_letter/$last_name
done

share|improve this answer

edited Mar 29 at 15:44

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

add a comment | 

4

If the lastname is always the shortest trailing string staring with an upper case letter (there are no compound lastnames for example) you could use a shell parameter expansion of the form $parameter%pattern in place of a regex solution.

Ex.

for f in [[:upper:]]*[[:upper:]]*; do 
 d="$f:0:1/$f%[[:upper:]]*/"
 echo mkdir -p "$d"
 echo mv "$f" "$d"
done
mkdir -p D/Doe/
mv DoeJohn20190327 D/Doe/

Remove the echos when you are satisfied that it is doing the right thing.

See for example Parameter Expansion

share|improve this answer

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1129576%2fextracting-names-from-filename-in-bash%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

5

Here you have a solution. I tested it an it creates the folders as you explained.

for filename in *.pdf
do
 echo "Processing file $filename "
 first_letter="$filename:0:1"
 mkdir -p $first_letter #if already exists won't print error
 last_name=$(echo $filename | sed 's/([^[:blank:]])([[:upper:]])/1 2/g' |awk 'print $1')
 mkdir -p $first_letter/$last_name
 mv $filename $first_letter/$last_name
done

share|improve this answer

edited Mar 29 at 15:44

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

add a comment | 

5

Here you have a solution. I tested it an it creates the folders as you explained.

for filename in *.pdf
do
 echo "Processing file $filename "
 first_letter="$filename:0:1"
 mkdir -p $first_letter #if already exists won't print error
 last_name=$(echo $filename | sed 's/([^[:blank:]])([[:upper:]])/1 2/g' |awk 'print $1')
 mkdir -p $first_letter/$last_name
 mv $filename $first_letter/$last_name
done

share|improve this answer

edited Mar 29 at 15:44

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

add a comment | 

Here you have a solution. I tested it an it creates the folders as you explained.

for filename in *.pdf
do
 echo "Processing file $filename "
 first_letter="$filename:0:1"
 mkdir -p $first_letter #if already exists won't print error
 last_name=$(echo $filename | sed 's/([^[:blank:]])([[:upper:]])/1 2/g' |awk 'print $1')
 mkdir -p $first_letter/$last_name
 mv $filename $first_letter/$last_name
done

share|improve this answer

edited Mar 29 at 15:44

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

for filename in *.pdf
do
 echo "Processing file $filename "
 first_letter="$filename:0:1"
 mkdir -p $first_letter #if already exists won't print error
 last_name=$(echo $filename | sed 's/([^[:blank:]])([[:upper:]])/1 2/g' |awk 'print $1')
 mkdir -p $first_letter/$last_name
 mv $filename $first_letter/$last_name
done

share|improve this answer

edited Mar 29 at 15:44

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

answered Mar 29 at 4:57

Philippe DelteilPhilippe Delteil

1,0131722

4

If the lastname is always the shortest trailing string staring with an upper case letter (there are no compound lastnames for example) you could use a shell parameter expansion of the form $parameter%pattern in place of a regex solution.

Ex.

for f in [[:upper:]]*[[:upper:]]*; do 
 d="$f:0:1/$f%[[:upper:]]*/"
 echo mkdir -p "$d"
 echo mv "$f" "$d"
done
mkdir -p D/Doe/
mv DoeJohn20190327 D/Doe/

Remove the echos when you are satisfied that it is doing the right thing.

See for example Parameter Expansion

share|improve this answer

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

add a comment | 

4

If the lastname is always the shortest trailing string staring with an upper case letter (there are no compound lastnames for example) you could use a shell parameter expansion of the form $parameter%pattern in place of a regex solution.

Ex.

for f in [[:upper:]]*[[:upper:]]*; do 
 d="$f:0:1/$f%[[:upper:]]*/"
 echo mkdir -p "$d"
 echo mv "$f" "$d"
done
mkdir -p D/Doe/
mv DoeJohn20190327 D/Doe/

Remove the echos when you are satisfied that it is doing the right thing.

See for example Parameter Expansion

share|improve this answer

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

add a comment | 

If the lastname is always the shortest trailing string staring with an upper case letter (there are no compound lastnames for example) you could use a shell parameter expansion of the form $parameter%pattern in place of a regex solution.

Ex.

for f in [[:upper:]]*[[:upper:]]*; do 
 d="$f:0:1/$f%[[:upper:]]*/"
 echo mkdir -p "$d"
 echo mv "$f" "$d"
done
mkdir -p D/Doe/
mv DoeJohn20190327 D/Doe/

Remove the echos when you are satisfied that it is doing the right thing.

See for example Parameter Expansion

share|improve this answer

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

for f in [[:upper:]]*[[:upper:]]*; do 
 d="$f:0:1/$f%[[:upper:]]*/"
 echo mkdir -p "$d"
 echo mv "$f" "$d"
done
mkdir -p D/Doe/
mv DoeJohn20190327 D/Doe/

share|improve this answer

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189

answered Mar 29 at 7:03

steeldriversteeldriver

71.7k11117189