Færdiggjort

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

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)

Evner: SQL, Programmering af database, Microsoft SQL Server

Se mere: ascii characters, sql server sproc copy data, sql money add field, remove special characters from string in sql server 2012, sql find ascii character in string, remove special characters from string in sql query, sql server remove non printable characters from a string, sql server find non ascii characters, sql remove non ascii characters, sql server special characters in string, how to remove special characters from a column in sql server, field data entry job, insert ascii characters vb6, sql job schedule export data csv, sql server migration php data, housewife need freelancing programming data entry job, insert non ascii characters, sql paypal ipn payment data aspnet, need captcha code data entry job, breezingforms field data

Om arbejdsgiveren:
( 36 bedømmelser ) Coeur D Alene, United States

Projekt ID: #27579007

Tildelt til:

iglobalvn

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 h Flere

$140 USD in 7 dage
(11 bedømmelser)
5.5

11 freelancere byder i gennemsnit $164 timen for dette job

jayantavkumar

Proposal - I can do retrieve required information either using SSIS ETL tool OR if you have already exported data into sql then using sql query. You can expect any kind of work on SQL Server/SSIS/SSRS. Let me know if y Flere

$250 USD in 3 dage
(31 bedømmelser)
5.0
freelancepraful

I can write SQL queries efficiently and have 12+ experience, please contact me asap. you can check my profile.

$35 USD in 3 dage
(1 bedømmelse)
4.2
SqlDevelopment

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 trou Flere

$350 USD in 4 dage
(21 bedømmelser)
3.9
EkoLike

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 Flere

$100 USD på 1 dag
(2 bedømmelser)
2.8
writingapp

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 dage
(3 bedømmelser)
3.0
gouriskumawat

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. Giv Flere

$100 USD in 2 dage
(0 bedømmelser)
0.0
RusselExpert

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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
tbrifki64

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 dage
(0 bedømmelser)
0.0
jubaetjeasun

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 dage
(0 bedømmelser)
0.0
wahmad1983

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. Flere

$278 USD in 7 dage
(0 bedømmelser)
0.0