What's the HID?
The "All-power data converter" is for the face.Line TextThe bulk remodeling of the workstation. You paste the list, fields, configurations or temporary export results into the input area and select a mode to output the new format. It's not Excel, it's not a complete ETL platform, but a microscalter in the browser: it's a quick sort of thing for a few lines to go to the million lines, and it's a little bit more like a little bit of a little bit of a little bit of a lot of a lot of work.Locally processed, instant preview, copyable for removal。
The page provides six modes:Prefix/suffix、Package Merge、Custom Template、Value Formatting、Text Case、Find Replace(optional positives). Before conversion, splits and filters empty lines, and the statistical area shows the number of input and output lines. Part of the status will be written localStorage.transformer_state(Inputs content and current pattern) to restore the draft after updating.
What do the six models do?
Prefix / Postfix
Prefixes and suffixes are placed separately for each line. Typical uses: add an extension to the file name (e.g. .png) Add business prefixes to SKU (e. g. ITEM_) A common directory of path clips. Unprecedented or empty suffix prices are not included.
2. Consolidation of packages
First, insert left and right characters for each line, then use the line separator for all linesMerge into one line。 Default is often used to generate 'a', 'b', 'c' Such lists, fast spell SQL IN (...) Draft, JSON string arrays or CSV single line fields. Note: This mode output lines are usually 1 different from the number of lines entered.
Custom Templates
Use the same template string for each line to support variables:
{value}: Current original line{i}: Serial number from 1{i0}: Serial number from 0
Fit to batch generation INSERT Statements, HTML <li>、option, configure rows or test data. Templates are replaced with strings in browsers, do not execute SQL/JS, and the results are generated by you to paste to the target environment.
4. Value formatting
Attempt to extract numbers from each line (allowing clean-up of non-digital symbols) and reformulate them to: KiloCell, 2 decimals, percentages, RMB (¥) or US dollars ($). For lines that cannot be parsed, choose "Standing the line as it is" or "Strengthen the line as zero". Percentage mode will press num * 100 And then... %, please confirm whether the original data are decimal or already percentages and avoid double-dooming.
5. Text case
Support all uppercase, all lowercase, first letter capital, little camels camelCaseSnake snake_case,Synthesis kebab-case。 Fits to the ID style harmonization, header regularization or code segment renaming draft. The Chinese content has changed only slightly in the case of case rules, and the English and digital identifiers have more obvious benefits.
6. Finding replacements
Default to replace the whole of the normal string; Use after ticking "Regular Expression" RegExp Replace global. The line would remain as it was when it was illegal to avoid a whole batch failure. Suits to remove domain names, replace separator, batch change code cases, etc. Complex multistep cleaning suggests multiple conversions or pre-processing with deweight/empty tools.
Recommended Workstream
- Export a column of pure text from Excel/Log/backstage to paste to the input area (available " pasting from clipboard " ).
- First, choose the closest to the target; The prefix or search replace is used to verify minimum changes when uncertainty is not established.
- Dots "start the batch conversion" check the number of output lines and the number of lines in the sample.
- (a) Copying the results; If a second step is required, the output will be glued back to the input area for continued conversion.
- Quick-cleaning of input and output after the use of sensitive data and cleaning of site local storage, as appropriate.
Apply scene
- Operations/Operational support: activity list prefixed, channel code spelled, status field batch rewritten
- Develop connection: quickly generate INSERT drafts, list of entries, test account lines
- Data collation: KiloCell of places, currency symbols, consistent style of case
- Content production: HTML list entry, Markdown semi-automatic generation
Borders and Attention
- PressOkay.Processing, without the full CSV multicolumn structure; Comma-based complex tables should be opened first.
- The consolidation of packages will change the line structure; Prefix or template is required for " individual rows remain independent " .
- Numerical formatting relies on simple digital resolution, and special writings such as scientific algorithms/accounting brackets may not be in line with expectations.
- Regular capacity is limited by browser engines and no replacement previews are high; Write complex models first, please verify with small samples.
- This tool does not audit rights and service content; Please manually review the target environment before generating SQL/configuration.
Privacy and local drafts
The conversion logic is performed on the browser and the page does not upload the full text to the server for conversion. To be refreshed, the tool may write input and mode localStorage。 When handling a public computer or confidential list, please change and clear the list manually and avoid remaining drafts in shared configuration files.
How to work with other tools at this station
The "Diggle" tool is needed to remove the repeat line first. The only way to change the case is to use the "Case conversion" Empty and invisible characters can be used as "space cleanup". If the output is JSON, you can then turn over to JSON Formatting to check the structure. Data converters are better at applying the same rule to each line, and complex multi-field mapping still recommends table software or script flow lines.
FAQ
Why did I enter 10 lines, the output was only 1 row?
Mostly using "packages merge": it will make a row of job. Replace with prefixes, templates or search if you need to output by line.
What's the serial number in the template?
{i} Starting with one,{i0} Starting with 0, it allows for the revolving habits of different languages.
Why is the percentage so large?
The percentage pattern is understood as " decimal ratio x 100 " . If the original 85 is 85%, convert or not use the percent mode.
Can you undo the conversion?
There is no special for the detachment. The input area content may be retained until it is not covered; It is suggested that you copy the backup and try different modes several times.