Options
Show Hints

Data

Each line in the DATA is parsed using the REGEX pattern

Only DATA less than 1,000,000 characters will be reloaded for reuse

There is a character limit of 50,000,000 characters

Upload File
...or paste Raw Text

Regex

Regular Expression

Regular expression to define the DATA structure

Include any flags and the delimiters

Use (round brackets) for creating CAPTURE GROUPS


CAPTURE GROUPS

Capture groups are AUTOMATICALLY added based on the REGEX

Defines SQL Columns for the SQL QUERY

Capture Group AS Definition
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
$14
$15
$16
$17
$18
$19
$20
$21
$22
$23
$24
$25
$26
$27
$28
$29
$30
$31
$32
$33
$34
$35
$36
$37
$38
$39
$40
$41
$42
$43
$44
$45
$46
$47
$48
$49
$50
$51
$52
$53
$54
$55
$56
$57
$58
$59
$60
$61
$62
$63
$64
$65
$66
$67
$68
$69
$70
$71
$72
$73
$74
$75
$76
$77
$78
$79
$80
$81
$82
$83
$84
$85
$86
$87
$88
$89
$90
$91
$92
$93
$94
$95
$96
$97
$98
$99
$100

SQL

TABLE NAME

Custom table name for use in SQL QUERY


SQL QUERY

SELECT query to retrieve the result set


DESCRIPTION

Title for the result set