22 Votes

Rotate and Mirror CSV Files

Question by Guest | 2023-03-17 at 00:03

I have some data in the form of CSV files whose fields I would like to rotate and mirror. What I intend to do is best explained with an example.

Let's say I have the following original file:

A1,B1,C1,D1
A2,B2,C2,D2
A3,B3,C3,D3

Rotated, the file would look like this:

A3,A2,A1
B3,B2,B1
C3,C2,C1
D3,D2,D1

Mirrored horizontally, the file would look like this:

D1,C1,B1,A1
D2,C2,B2,A2
D3,C3,B3,A3

When rotating, the data should be flipped so that the previous columns become rows. And by mirroring I mean to swap the first column with the last column, the second column with the penultimate column and so on (a vertical mirroring would do the same with the rows). These should only be examples, in reality my data sets are of course much larger and therefore difficult to handle by hand.

So far, I haven't found a program that allows me to do such an editing. Can someone help me?

ReplyPositiveNegative
Avatar Stefan Trost
2Best Answer2 Votes

You can easily perform this task with the program TextConverter. All you have to do is to activate the TextConverter's CSV Action "Rotate and Mirror" and select your desired rotation and/or mirroring from the options of this action.

Here's how you can do it:

  • First, activate the action "Actions > CSV > Rotate and Mirror" on the right side of the program's main window. In the options of this action you can configure by how many degrees the CSV data should be rotated and whether the data should also be mirrored.
  • The rotation can be determined by selecting one of the options "Do not rotate", "Rotate by 90°", "Rotate by 180°" or "Rotate by 270°".
  • With the two options "Mirror horizontally" as well as "Mirror vertically" you can alternatively or additionally mirror the CSV data at the same time.

With the TextConverter you can edit unsaved texts as well as single files or multiple files at the same time.

Files can simply be dragged onto the program while you can edit unsaved texts by just writing or copying a text into the field "Original" and then fetching the result from the field "Preview".
2023-03-17 at 01:37

ReplyPositive Negative
Reply

Related Topics

Convert many CSV Files to XLSX or ODS Spreadsheets

Tutorial | 0 Comments

MySQL: CSV Export as File stored on the Server

Tutorial | 0 Comments

MySQL: CSV Export as automatic Download

Tutorial | 0 Comments

Website Performance: Deliver JavaScript and CSS files compressed to reduce loading times

Tutorial | 0 Comments

Rewrite Text Files with a fixed Line Length

Tutorial | 0 Comments

How to Replace multiple Texts at the same Time

Tutorial | 0 Comments

Remove duplicate Rows from CSV Files

Question | 1 Answer

Important Note

Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.

Participate

Ask your own question or write your own article on askingbox.com. That’s how it’s done.