Find Jobs
Hire Freelancers

SQL - Need to strip field data out of string with Ascii characters

$30-250 USD

Completed
Posted over 3 years ago

$30-250 USD

Paid on delivery
Hello! I have about 5000 files that contain ASCII characters AND a specific number for our documents. I need to strip this document number out of each file. If you look at the attached files, I need to capture the 2019-########## number out of each file. I THINK each number will be 4 digits + '-' + 10 digits, but I'm not entirely sure. Ultimately I need this in an SQL database. I have imported the data to SQL and with various methods can pull the information out, but each time I find a way to do it there is another file with a different ASCII pattern that I hadn't account for. I will be receiving these files on a go forward basis so I am looking for a method to strip this data out. Preferably by bulk inserting the files and stripping out the data with SQL scripts, stored procedures, etc. I am using SQL 2008 (but could install 2019 if necessary)
Project ID: 27579007

About the project

10 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi sir, i have read your requirement carefully. I can strip field data out of string with Ascii characters for your SQL database perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. Especially, this is my experienced and successful work before. Also i have fluent English skill, so you can communicate with me very easily via voice call and thus, you can save your time. No problem for working with me now. So if we work and do our best for one purpose, we can get great success each other. Please call me and discuss about your project seriously. I'm always here and ready to talk with you right now. I'll wait for your call. Thanks.
$140 USD in 7 days
4.8 (15 reviews)
5.6
5.6
10 freelancers are bidding on average $155 USD for this job
User Avatar
I can investigate your scope of files and implement a most relevant algorithm to extract a document numbers. I am Senior MS SQL/BI Developer with more than 10 years of experience. And I have advanced expertise in troubleshooting and researching. That is why I think I have more than enough skills to solve your task.
$350 USD in 4 days
5.0 (52 reviews)
5.3
5.3
User Avatar
Hi. I have written many database projects including SQL. I am ready to write your project. Will complete within 3 days
$90 USD in 3 days
5.0 (13 reviews)
5.0
5.0
User Avatar
Greetings. Thanks for your post. I have deep knowledge and full experience with sql and data process so I can deliver the saticfactory product per as your needs. I am very confident with my skills and I would like to help your business by doing my best. Please contact me for further discussion. Thanks & Regards.
$140 USD in 7 days
5.0 (1 review)
4.4
4.4
User Avatar
I can write SQL queries efficiently and have 12+ experience, please contact me asap. you can check my profile.
$35 USD in 3 days
5.0 (9 reviews)
4.4
4.4
User Avatar
hello. how are you ? i was late for your project but i have just checked your project description in detail and i am very interested in your project i am working as developer for 10 years over just mean, i am very good at SQL and managing. so i can help you and can provide high quality project. please send me your offer. let's talk more detail
$100 USD in 1 day
5.0 (4 reviews)
3.8
3.8
User Avatar
Hello, I have read your problems about SQL database. I have experience resolve this kind of encryption decryption related problems in MySQL database. I will try my best to resolve this.
$70 USD in 3 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Dear friend, I have experienced in MySql and data mining, i can help you in achieving complete requirement. I would like to propose python here to bulk processing and data mining. python is open source and free. Give me a chance to do that. looking forward to hearing from you soon. Thanks
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to assist you. Kindly advise me for further detailed objectives and instructions. Thank you very much. I will be waiting for your message
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Team, Hope you are doing good. I am having around 11 years of IT experience which Includes mainly in the area of Database development,Design,Maintenance,Management along with worked on many data Warehouse projects. Mainly worked on Oracle, oracle forms , oracle reports,MYSQL,SQL,PLSQL,SQL SERVER, HANA DB servers as well as MS ACCESS,TIDAL scheduler,VBA,VB and crystal reports. lets meetup and start working on . Thanks, Wasim
$278 USD in 7 days
0.0 (0 reviews)
2.4
2.4

About the client

Flag of UNITED STATES
Coeur D Alene, United States
5.0
58
Payment method verified
Member since Jun 5, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.