I have an FTP server with thousands of Invoices. All Invoices are in a folder called /volume1/MBSInvoices/
Monthly invoices are added to that folder every month.
Here is a sample filename of the Invoices:
the Account ID is the 6th segment of the name (10030052)
I would like to create a bash script that does the following:
Check the 6th segment in the file name. If a folder with that name doesn't exist, create one. Otherwise don't create one.
Move those Invoices to their correspondent folders based on the 6th segement on the invoice name
Example:
The script will check the file name, specifically the 6th segment.
If the a folder named 10030052 doesn't exist, create a new one.
Then move the file invoice_1_20170101_10010052_10020052_10030052_JOHNDOE.pdf to folder 10030052
If the folder named 10030052 already exists,
move the file invoice_1_20170101_10010052_10020052_10030052_JOHNDOE.pdf to folder 10030052
The script needs to do this for over 600 files. The script will be run once a month as new monthly invoices become avaiable.
Thanks
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 01-31-2017 at 12:28 PM..
Reason: Added CODE tags.
Default shell is /usr/bin/zsh
Script will be running #!/bin/bash
Need to pull information from database while using other scripts already made (not by me).
Ok, so i need a script pulling certain information about a customer's router interfaces.
I am using a ROUTER-DNS-NAME as variable $1
I... (3 Replies)
How to I put my find command string into a script. It is currently to long to be entered manually at command line.
for FNAME in `find /unixsxxx/interface/x.x/xxxxxx -type f \( -name '*.KSH' -o -name '*.sh' -o -name '*.sql' -o -name '*.ksh' \) -exec grep -il xxx.xxx.xxx.xxx {} \;`; do C=`grep -c... (5 Replies)
My script prints lines in which the entire line may be colored, and portions may also be colored. e.g.
Consider this to be one line:
$red some text in red $yellow abcd $end_yellow red text 1234 $blue some text $end_blue more red text $end_red
So using sed, I may based on condition 1,... (5 Replies)
hey... i had a big problem with my professor
i have 3 simple archives
in.txt -> had all timestamps of users logon (100lines)
ex. 111111
222222
333333
out.txt -> had all timestamps of users logof (100lines)
ex. 111113
222225
333332
commands.txt... (9 Replies)
I don't know if this is a big issue or not, but I'm having difficulties. I apoligize for the upcoming essay :o.
I'm writing a script, similar to a paint program that edits images, but in the form of ANSI block characters. The program so far is working. I managed to save the image into a file,... (14 Replies)
picked this up from another thread.
echo 1st_file.csv; nawk -F, 'NR==FNR{a++;next} a{b++}
END{for(i in b){if(b-1&&a!=b){print i";\t\t"b}else{print "NEW:"i";\t\t"b} } }' OFS=, 1st_file.csv *.csv | sort -r
i need to use the above but with a slight modification..
1.compare against 3 month... (25 Replies)
Ok, this one isn't for everybody, it's pretty tough and I've spent a good deal of time on it without figuring it out yet.
Can anybody get this script to work:
#!/bin/bash
cq_fname="%let outputfile="/user/cq_"$1".csv";"
sed "29s/.*/\"$cq_fname\"/" file1.sas >... (3 Replies)
Hi ,
I need one help to do some complex calculation in shell script.
here is what i need to do:-
a=2
b=2
c=2
d=2
result=a+(b/(20*c))+(c/(10*d))
is there any thing special there so that i can group intermdiate results.
Please help me if you have any idea. (4 Replies)
Hello,
I hope someone can hep with this. I use a skript to send multiline Data to a Monitoring system. Bu I'm not able to use linebreaks or escape sequences.
The skript is simple like that:
#!/bin/bash
var="Erste Zeile \n zweite Zeile \n Dritter Teil"
zabbix_sender -c... (17 Replies)
I'm new to utilities like socat and netcat and I'm not clear if they will do what I need.
I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes.
I'm using Cygwin bash on Windows 10.
My... (3 Replies)