Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
^"(.*)\n([\w ]+), (TX) (\d*)\n\(([\d\.]+), ([\d\-\.]+)\)"
/
gm
Input 1
Address "10111 N LAMAR BLVD AUSTIN, TX 78753 (30.370945933000485, -97.6925542359997)" "2620 LAKE AUSTIN BLVD AUSTIN, TX 78703 (30.28190796500047, -97.77587573499966)" "14016 N FM 620 RD AUSTIN, TX 78717 (30.490713033000475, -97.76505815999968)" "3636 N FM 620 RD AUSTIN, TX 78734 (30.377873241000486, -97.9523496219997)" "15829 N IH 35 SVRD NB AUSTIN, TX 78660 (30.44853172000046, -97.61972641599965)" "917 N LAMAR BLVD AUSTIN, TX 78703 (30.274846781000463, -97.75233231299967)" "2408 SAN GABRIEL ST AUSTIN, TX 78705 (30.288663793000467, -97.7478026929997)" "9909 MANCHACA RD AUSTIN, TX 78748 (30.17345059100046, -97.82385098799966)" "9919 SERVICE AVE AUSTIN, TX 78743 (30.205028616000448, -97.6625588019997)" "907 MONTOPOLIS DR AUSTIN, TX 78741 (30.235233637000476, -97.69688566499968)" "10601 N LAMAR BLVD AUSTIN, TX 78753 (30.37476574700048, -97.6903937089997)" "8648 RESEARCH BLVD SB AUSTIN, TX 78757 (30.354852741000457, -97.71712931799965)" "801 E WILLIAM CANNON DR Unit 205 AUSTIN, TX 78745 (3
Substitution
$1\t$2$1\t$2\t$3\t$4\t$5\t$6
Address "10111 N LAMAR BLVD AUSTIN, TX 78753 (30.370945933000485, -97.6925542359997)" "2620 LAKE AUSTIN BLVD AUSTIN, TX 78703 (30.28190796500047, -97.77587573499966)" "14016 N FM 620 RD AUSTIN, TX 78717 (30.490713033000475, -97.76505815999968)" "3636 N FM 620 RD AUSTIN, TX 78734 (30.377873241000486, -97.9523496219997)" "15829 N IH 35 SVRD NB AUSTIN, TX 78660 (30.44853172000046, -97.61972641599965)" "917 N LAMAR BLVD AUSTIN, TX 78703 (30.274846781000463, -97.75233231299967)" "2408 SAN GABRIEL ST AUSTIN, TX 78705 (30.288663793000467, -97.7478026929997)" "9909 MANCHACA RD AUSTIN, TX 78748 (30.17345059100046, -97.82385098799966)" "9919 SERVICE AVE AUSTIN, TX 78743 (30.205028616000448, -97.6625588019997)" "907 MONTOPOLIS DR AUSTIN, TX 78741 (30.235233637000476, -97.69688566499968)" "10601 N LAMAR BLVD AUSTIN, TX 78753 (30.37476574700048, -97.6903937089997)" "8648 RESEARCH BLVD SB AUSTIN, TX 78757 (30.354852741000457, -97.71712931799965)" "801 E WILLIAM CANNON DR Unit 205 AUSTIN, TX 78745 (3