Edit an existing exported csv file via PHP / Laravel and re-save

Question

I am using Laravel-Excel to export a CSV file with a header and footer row. The header and footer rows only have 2-3 columns, however body rows have multiple additional columns - resulting in additional trailing commas at the end of the header and footer.

Since the Laravel-Excel package cannot remove these additional commas, I need to, once the file has been exported, open it somehow via the code, remove the trailing commas from the header and footer rows and then re-save the file and let my users download the end result.

So what I am looking for is:

Actual:

Header,20211021,065529,,,,,,,,,,,,,,,,,,,,,,
Footer,49,,,,,,,,,,,,,,,,,,,,,,,

Required:

Header,20211021,065529
Footer,49

So the process would be as follows:

Generate the export file using Laravel-Excel
Save the generated file to the server
Open the generated file, determine the last line
Remove the trailing commas from line 1 (header)
Remove the trailing commas from the last line (footer)
Overwrite/save the existing csv file

Any help on how I would go about this would be hugely helpful!

simialbi · Accepted Answer · 2021-10-26 08:10:44Z

1

I think the easiest way to reach this is using simple php. Via rtrim its very easy to accomplish this:

$contents = file('file.csv');
foreach ($contents as &$line) {
    $line = rtrim($line, ",\r\n");
}
file_put_contents('file.csv', implode("\n", $contents));

answered Oct 26, 2021 at 8:10

simialbi

5073 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

stankobrin Over a year ago

This is perfect! Is there a way though that I can only trim the first and last lines of the file?

simialbi Over a year ago

Instead of foreach do it with $contents[0] and $contents[count($contents) - 1]

Collectives™ on Stack Overflow

Edit an existing exported csv file via PHP / Laravel and re-save

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related