I have data that is mostly organized in a way that I can convert and import into a spreadsheet. But certain lines have carriage returns and text that my current batch file won't use.
Good Data:
Pipers Cove × 2 $25.00 Pipers Cove Petite × 2 $25.00 Pipers Cove Plus × 2 $25.00 Nordic Club × 2 $25.00 Whiteout × 1 $12.50
Bad Data:
Pipers Cove Kids × 2 Size: Large - ages 10 to 12 $20.00 Pipers Cove Kids × 2 Size: Medium - ages 6 to 8 $20.00 Pipers Cove Kids × 2 Size: Small - ages 2 to 4 $20.00
I need to remove the 2 lines starting with Size
, Small
, Medium
, or Large
and have the dollar amount follow the quantity number so my batch file can convert it to a CSV file and so on.