
Completed
Posted
Paid on delivery
I have a table ID (varchar) | FieldA (text) where ID is the primary key, and FieldA is a text field. FieldA contains long text blocks. I want to search this field for substrings (there can be several of them in a record) in the format "\qty{...}{...}" or "\qtym{...}{...}", where "..." denotes text strings, e.g. "\qty{3}{\gram}" or "\qty{3}{\text{cars}}" or "\qtym{\(x\)}{\kilo\gram}". (This is LaTeX code for the SIUnitsx package, where qtym is a user-defined macro that handles non-numbers like variables \(x\).) To proof the text, I would like to search and extract all such substrings and form a new table, including the record ID, e.g. 2026-10-08-01 | \qty{3}{\gram} 2026-10-08-11 | \qty{3}{\text{cars}} 2026-05-13-21 | \qtym{\(x\)}{\kilo\gram} or in the separated format 2026-10-08-01 | qty | 3 | \gram 2026-10-08-11 | qty | 3 | \text{cars} 2026-05-13-21 | qtym | \(x\) | \kilo\gram
Project ID: 40786253
93 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I'm Denis, a full-stack developer, and I've built data extraction tools that parse structured patterns from unstructured text and populate new tables with clean results. You need to find all LaTeX quantity macros in your FieldA column—both \qty and \qtym variants with nested parameters—and extract them into a new table for proofing. This manual work can be automated with regex-based extraction to audit all instances at once and catch formatting errors before publication. I would start by building a MariaDB query with regex functions to match both macro patterns and capture nested braces. Then I'll create the output table and write a PHP script to run the extraction, handling edge cases like escaped braces and nested text commands. Finally, I'll test it against your actual data and show you both full-match and separated formats so you can choose what works best. The main challenge is getting regex right for nested braces with escaped characters and commands. I'll build the pattern step by step, testing against real examples, and add validation to flag broken macro syntax so nothing fails silently. For large tables, I'll add indexing and batch processing to keep queries responsive. I can start right away. Let's discuss the details. Thanks, Denis.
$50 USD in 3 days
6.3
6.3
93 freelancers are bidding on average $105 USD for this job

The real challenge here is not just finding `\qty{...}{...}` once, but extracting every occurrence from long text blocks without breaking on nested LaTeX like `\text{cars}` or escaped math such as `\(x\)`. I’d approach this by building a MariaDB-safe extraction method that captures both `\qty` and `\qtym`, then outputs either the full match or split fields into a clean result table tied back to each record ID. I’ve handled regex-based parsing, SQL text cleanup, and structured extraction work where the important part was accuracy across edge cases rather than just writing a quick pattern. For this kind of job, testing against several sample rows matters as much as the regex itself. - Which MariaDB version are you on? Regex features differ a bit by version. - Do you want the final deliverable as a single SQL script, or should I also include a stored procedure/view for repeat use? - If a record contains multiple matches, should each one become its own row in the new table?
$120 USD in 2 days
9.4
9.4

The key complication is nested braces: a simple regex may stop at \text{cars} instead of capturing the complete \qty{3}{\text{cars}} expression. I’d use a brace-aware parser to find every \qty and \qtym occurrence, preserve the original LaTeX, and extract the macro name and both arguments without altering their contents. The results can be written to a separate table with the source ID, occurrence number, full match, and parsed fields. The occurrence number matters because one record may contain several matches, including duplicates. I’d also flag incomplete or unbalanced expressions for review rather than silently dropping them, and test against your examples plus nested-brace cases. Which database engine are you using, and would you prefer a persistent results table or a query/export you can rerun?
$50 USD in 1 day
8.3
8.3

Your main issue is that these LaTeX fragments can appear multiple times inside one text field, so a simple one-match regex won’t be enough. I’d set this up so both `\qty{...}{...}` and `\qtym{...}{...}` are extracted consistently and inserted into a separate table with the source ID, either as the full substring or broken into macro/value/unit columns. I’ve worked on SQL cleanup and pattern-extraction tasks where text looked simple at first but had edge cases once nested braces or escaped characters appeared. That kind of detail is what decides whether the result is actually useful for proofreading. - What MariaDB version is running on your server? - Do you already have sample rows with multiple matches that I should test against? - Would you like both outputs prepared: full substring and separated columns?
$110 USD in 3 days
7.7
7.7

Nested braces like \text{cars} break a plain regex, and REGEXP_SUBSTR returns only the first hit per row; both handled, every occurrence captured. You get a query / stored procedure you run yourself that fills both layouts (full match, and macro | value | unit) keyed by ID. A run on a sample of your rows within a day, then the final version with an occurrence count check by day 3. 1. Which MariaDB version are you on? 2. Can arguments nest deeper than one level, e.g. \text{\textbf{x}}? Share a few sample rows and we can start right away.
$90 USD in 3 days
7.6
7.6

The decision that shapes this build is where the matching runs: entirely in MariaDB with REGEXP_SUBSTR, or in a PHP script that reads each record and scans for the macros. I recommend the PHP scanner. The arguments nest braces, as in \qty{3}{\text{cars}}, and a flat regex will either cut them short or run into the next command. A small balanced-brace parser handles that reliably and keeps \( ... \) math in qtym intact. My plan: connect with PDO and stream the table in batches so long text blocks do not exhaust memory. For every \qty{ and \qtym{ occurrence I read arguments until the braces balance, then store the record ID, position, macro name, both arguments and the original string. Both formats you listed will be in the output, so you can filter by macro or unit. Inserts use prepared statements. For proofing, nothing gets dropped silently. Unbalanced braces or empty arguments go into a separate flagged list, and I report match counts per record so you can check totals against a manual search. I have completed 144 projects, with 99.5% on time and 99.8% on budget. The first milestone covers the parser, the output table schema, and a run on a sample batch of your records, with the matches and flagged cases sent to you for review before I process the full table.
$180 USD in 2 days
7.2
7.2

This needs a careful extraction setup because the strings are LaTeX-style macros inside long text, and some of them include nested content like `\text{...}` or math expressions. My plan would be to create a reliable query/script that scans `FieldA`, pulls all `\qty` and `\qtym` matches per record, and writes them into a new table in the structure you prefer. I’ve done database text parsing and cleanup work where the key was making the output dependable enough to audit content later, not just returning partial matches. For a proofreading workflow, that reliability is the part worth getting right. - Should the new table store only extracted matches, or also rows with no match for reference? - Do you want `qty`/`qtym` stored as a separate column from the extracted arguments? - Will this be a one-time extraction or something you want to rerun on updated records?
$105 USD in 3 days
7.1
7.1

Hello, I’ve reviewed your MariaDB text-extraction requirement and understand you need to locate multiple LaTeX-style patterns like \qty{...}{...} and \qtym{...}{...} inside long text fields, then store each match with its source ID for proofing. Let’s chat and discuss it further To handle your project, I will start with crafting a robust MariaDB REGEXP-based extraction approach, then refine it with SQL using REGEXP_INSTR, REGEXP_SUBSTR, and recursive CTEs if needed to capture multiple matches per row. If the pattern complexity requires it, I can also validate with Python for preprocessing and testing, ensuring the parser correctly handles nested commands like \(x\) and \text{cars} without breaking on escaped backslashes. I will deliver a clean extraction query or script that returns each matched substring with the originating ID. I will also provide a separated output format with the command name and both arguments, ready for proofing or export. Before signing-off my bid, I would like to ask a question, i.e.,"Do you want the solution to keep the full LaTeX substring exactly as stored, or split out every match into normalized columns for downstream review?" If you want, should I tailor this for pure MariaDB SQL only, or include a Python helper for safer regex handling? Best Regards, Aneesa.
$100 USD in 1 day
6.8
6.8

Hi there, I hope this message finds you well. I am writing to express my interest in your project regarding the extraction of specific substrings from a text field in a MariaDB table. With extensive experience in PHP, SQL, and particularly MariaDB, I am confident in my ability to deliver a solution that meets your requirements. I understand that you need to extract substrings formatted as "\qty{...}{...}" or "\qtym{...}{...}" from the FieldA column of your database. This involves utilizing regular expressions to identify these patterns and then storing the results in a new table, along with the corresponding record ID. My expertise in database development and data processing will enable me to efficiently craft the necessary queries and scripts to automate this task. In terms of approach, I propose writing a SQL query that leverages MariaDB's support for regular expressions to locate the desired substrings. I will then develop a PHP script to process each record, extract the relevant data, and insert it into the new table in your preferred format, whether as a single string or separated into components. My goal is to provide a robust solution that is both efficient and easy to maintain, ensuring that your data extraction process is seamless and accurate. I look forward to the opportunity to discuss your project further and demonstrate how I can add value to your team. Best Regards, Efanntyo
$30 USD in 5 days
6.7
6.7

Hi There, Ready right now I'm ready to MariaDB Regex Substring Extraction . I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$70 USD in 1 day
6.8
6.8

Hi, we can help you extract the required LaTeX expressions from your MariaDB text field and save them in a separate table along with their original record IDs. We’ll make sure multiple matches in the same record are captured and the extracted text remains unchanged. We’ll test the solution with your examples and provide the code and simple instructions for future use. Which MariaDB version are you using? Can the expressions contain nested braces? Would you prefer an SQL-only solution, or is a small Python or PHP script acceptable?
$140 USD in 7 days
6.6
6.6

Hi, I can build a solution to scan your text field and extract every `\qty{...}{...}` and `\qtym{...}{...}` occurrence, including multiple matches in the same record. I’ll preserve the original record ID and can output either the complete LaTeX expression or separate columns for the macro, value and unit. Since the arguments may contain nested braces, I’ll use a parser that handles them correctly rather than relying on a simple regex. The result can be stored in a new database table for easy proofreading and further processing.
$90 USD in 1 day
6.6
6.6

Hi, I can develop a reliable SQL/Python solution to extract all `\qty` and `\qtym` expressions from your text field, including nested LaTeX braces and multiple matches per record. I'll deliver a clean output table containing the record ID, macro type, values, and units, along with reusable, well-documented code. Ready to start immediately!
$70 USD in 1 day
5.9
5.9

MariaDB and SQL are central to my work, and I can help you extract every `\qty{...}{...}` and `\qtym{...}{...}` occurrence from `FieldA`, including multiple matches within the same record. My 8 years of IT experience and skills in MariaDB, MySQL, PHP, and SQL enable me to handle both requested output formats: preserving each complete LaTeX substring with its `ID`, or separating the macro name, first argument, and second argument into distinct columns. I can also account for nested LaTeX content such as `\text{cars}`, `\(x\)`, and unit commands like `\kilo\gram`, while keeping repeated matches associated with the correct source record. I am ready to provide a reliable MariaDB solution for searching, extracting, and structuring these values for proofreading.
$100 USD in 1 day
5.7
5.7

Hi there, I see you're looking to extract specific LaTeX formatted substrings from a text field in your MariaDB table. You want to identify and pull out substrings like "\qty{...}{...}" and "\qtym{...}{...}", and create a new table with either the full format or separated components. With 4+ years of experience in PHP and SQL, I can help you develop a solution that employs regular expressions to accurately find and extract the data you need. My approach would involve writing a SQL query that utilizes regex functions in MariaDB to locate these patterns effectively. Then, I’d structure the output to match your desired format. One question I have is whether you want the extraction to run as a one-time process or if you foresee needing to do this regularly for new entries in your database. Best regards, Arslan Shahid
$30 USD in 3 days
5.8
5.8

MariaDB/MySQL and SQL are the right tools for extracting and validating repeated LaTeX-style `\qty{...}{...}` and `\qtym{...}{...}` patterns from your `FieldA` text while preserving each record’s `ID`. I can develop a practical query or PHP-assisted solution that returns either the complete matched substring or separate macro, value, and unit columns. My 15+ years in the technical world, combined with MySQL, SQL, and PHP expertise, supports both the database logic and any processing needed when multiple matches occur in a single text block. I will keep the output tied to your requested table structure and account for examples such as nested braces in `\text{cars}` and LaTeX content like `\(x\)`. Choose me to build a reliable extraction solution for your MariaDB data and proofing workflow.
$30 USD in 7 days
5.6
5.6

Hello, I can help you extract these LaTeX `\qty{...}{...}` and `\qtym{...}{...}` patterns from MariaDB cleanly and reliably. I’ve worked on similar PHP/MySQL data-processing tasks where text fields contained many embedded patterns and needed to be parsed into structured rows for review and proofing. In one recent project, I built a regex-based extractor for long scientific text stored in MySQL, then saved each match into a separate table with the source record ID for easy auditing. For your case, I’d approach it by using a MariaDB-compatible regex strategy to capture both the function name and the two arguments, even when the content includes escaped LaTeX like `\(x\)` or `\text{cars}`. I can also format the output either as the full matched substring or in separated columns like `qty | 3 | \gram`, depending on what is most useful for your proofreading flow. If needed, I can also suggest a safer way to handle nested braces or edge cases in the input. Would you prefer the extraction to be done directly in SQL, or via PHP for better flexibility? Best regards, Istkhar
$80 USD in 2 days
5.3
5.3

Which database are you using — MySQL, PostgreSQL, SQL Server, or something else? I'll give you the simplest working query for it. Kindly send me a message I'm available to finish this ASAP Looking forward to hearing from you Thank you
$60 USD in 1 day
5.2
5.2

Hi, I’ve built MySQL/MariaDB text-parsing queries and extraction pipelines from large unstructured fields. I’ll implement robust MariaDB regex matching for both \qty...... and \qtym......, then populate a new table with the source record ID and the extracted segments in your chosen separated or combined format. I’ll ensure it handles multiple matches per FieldA consistently. I deliver reliable SQL-based extraction that’s easy to validate against sample records. Best, Razmik
$100 USD in 2 days
4.8
4.8

The task at hand involves extracting specific LaTeX formatted substrings from a long text field in a database table to create a new table that captures these substrings along with their related IDs. This serves the business goal of organizing complex data formats for improved usability and reporting. The extraction process can be approached using PHP and SQL, utilizing regular expressions to identify the desired patterns within the text. This method allows for efficient data processing and accurate extraction of multiple instances of substrings per record. The plan would be: 1. Analyze the FieldA content to identify substring patterns. 2. Implement a PHP script using regex to extract these patterns while ensuring the original IDs are maintained. 3. Structure the output to match the required database format. What specific database structure do you envision for storing the extracted data? If this approach aligns with your needs, I can start drafting a sample script to illustrate the extraction process.
$100 USD in 5 days
4.5
4.5

I'll turn the LaTeX quantities in FieldA into a separate table you can proofread, keeping each match linked to its original ID and leaving the source text untouched. I'll first check your MariaDB version and a sample of the stored text. The important part is preserving nested braces, such as in \text{cars}, rather than stopping at the first closing brace. I'll build a repeatable extraction query that handles those nested groups and multiple matches per record, with either the complete macro or its separated arguments in the output. I'm at 5.0 across 28 reviews here with every job completed. I'll also include brief notes explaining how to rerun the extraction. Would you prefer the complete LaTeX substring or the separated macro and argument columns?
$40 USD in 1 day
4.3
4.3

Sweden
Payment method verified
Member since Apr 20, 2014
$30-250 USD
£20-250 GBP
$10-30 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹1250-2500 INR / hour
$10-30 AUD
₹12500-37500 INR
₹12500-37500 INR
min $50 USD / hour
₹75000-150000 INR
₹1500-12500 INR
₹750-1250 INR / hour
$5000-10000 USD
$8-15 USD / hour
€30-250 EUR
$15-25 USD / hour
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD
₹1500-12500 INR