CODEWITHSUNDEEP
phpregex
Nate
Nate

Reputation: 259

How to fix line formats when reading a file

How would I fix lines like the last one to make them look like the first two with regex?

"XY30-0601" "LMF II Trump"  7
"ZR3-0003601"   "Durable canvas"    3

"GQ450-020061"  "DMZ Power
Epic
Durable canvas
Handle for easy transport
Sturdy buttons to keep the case rolled up
Reinforced case stitching
"   17

I'm expecting

"XY30-0601" "LMF II Trump"  7
"ZR3-0003601"   "Durable canvas"    3
"GQ450-020061"  "DMZ Power Epic Durable canvas Handle for easy transport Sturdy buttons to keep the case rolled up Reinforced case stitching"   17

Upvotes: 1

Views: 42

Answers (2)

Avinash Raj
Avinash Raj

Reputation: 174826

Just try the below regex and replace the matched newline characters with a space.

\n(?:(?!")|(?=" +\d+))

DEMO

Code:

<?php
$string = <<<EOT
"XY30-0601" "LMF II Trump"  7
"ZR3-0003601"   "Durable canvas"    3

"GQ450-020061"  "DMZ Power
Epic
Durable canvas
Handle for easy transport
Sturdy buttons to keep the case rolled up
Reinforced case stitching
"   17
EOT;
$pattern = '~\n(?:(?!")|(?=" +\d+))~';
$replacement = " ";
echo preg_replace($pattern, $replacement, $string);
?>

Output:

"XY30-0601" "LMF II Trump"  7
"ZR3-0003601"   "Durable canvas"    3
"GQ450-020061"  "DMZ Power Epic Durable canvas Handle for easy transport Sturdy buttons to keep the case rolled up Reinforced case stitching "   17

Upvotes: 3

vks
vks

Reputation: 67988

(?=[^"]*")\n

You can use this.replace by a space.It uses a postive lookahead to find \n before "

See demo.

http://regex101.com/r/hQ1rP0/14

Upvotes: 0

Related Questions