I am after a script to Check folder for a new CSV file Modify Phrasing of Content, Check for Duplicates in Products, Recreate CSV and Upload to FTP, Move original file into /Processed Folder.
CSV file sample attached.
Simple Defined section /file where i can Define details for SFTP File Upload Location & Folder location to monitor.
Rephrase "Service" , "Details"& "Amount" Columns.
Modify Details to AU_DID_ if not a 13 or 1800 number, prep-end the total Amount in Cents at end, Modify Details field, IF 61(2,3,7,8)? to 0(2,3,7,8)?. Do not modify Amount Column.
- "AU WH DID VOP, 61732666533" & "AU$ 0.4000" to "AU_DID_40, 0732666533 & AU$ 0.4000"
- "WH 61738626211,61738626211" & "AU$ 0.4000" to "AU_DID_40, 0738626211 & AU$ 0.4000"
- WH 61731984894, WH 61731984894, AU$ 0.4000 to "AU_DID_40, 0731984894 & AU$ 0.4000"
- AU WH DID VOP WH, DID Lease 61731801470,AU$ 2.5000 to "AU_DID_250, 0731801470 & AU$ 2.5000"
- WH 611300787934,611300787934, AU$ 7.5000 to "AU_1300_750, 1300787934 & AU$ 7.5000"
- if 1800 number exists the use "AU_1800_???"
- if 13 number (Not 1300) then AU_13_??
- If Not start with 61 for AU then "INT_Code_DID_Amount" eg. "INT_64_DID_550"
Only Keep Lines with ACC: 8340929 if "61?????????" numbers Not assigned to any other accounts.
Hi I can help you to do your interesting work. And here is my skill: ◆Web Development: Websites Back and Frontend◆ .NET Framework 2.0/3.0/3.5/4.0/4.5 ASP.NET Webform/MVC/WPF/WCF IIS 6.0/7.0/8.0, Windows2008/ Plus
9 freelance font une offre moyenne de $225 pour ce travail
Greetings sir, I have read your project details and i will develop a software that will monitor your configured folder for new csv file, modify it as per your logic and upload to ftp folder. Sir, i can deliver th Plus
Hello, I've read your task description attentively, can't say, that it is 100% clear, but we can clarify details later. Whatever, I can do that work for you. Thanks, Alex
Hi, I am Ruyun. After reading description carefully, I've convinced this project is very suitable for me. Through over 8 years, I've been developing so many kinds of big and small projects with CSS, Bootstrap, HTML Plus
Dear Hiring Manager, You may get tired of getting auto bids but I am not like other freelancers. I have read your full project description. I can write a PHP script that parses your CSV file and modifies it acco Plus
Dear Sir, I am interested in doing this work of creating a script to check for new CSV files in folder and modify them according to your requirement. I will create php script that will will run live on server. I am av Plus
Hey there, I'm a System Engineer with coding skills. I had developed tons of automation scripts. I can help. Regards.
Hello sir. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My Plus