Similar Posts

Streaming services?

ByDjdbskx

So, I want DAZN Super Sport for 19.99 for 12 months. But my mom says, "Then you have to decide whether to get Spotify Premium (which I use every day), Netflix, or Disney+. The question is, which would be better? In terms of movies and series. The question: The question to you: What would you…

Subscribe
Notify of
2 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
julihan41
julihan41
1 year ago
  1. Open file manager
  2. Right click on file -> Rename (or press F2 mostly)
  3. Rename to DATEINAME.csv.
  4. Finished

When read in, it is then important to specify what the separating element is (here it looks like spaces?). Alternatively, you can replace what in comma, tab or otherwise if it should be necessary via “Search & Replace”.

In LibreOffice Calc the import looks like this:

PS: CSV is also only a text file that follows a specific formatting.

1
Erzesel
Erzesel
1 year ago

the fastest goes with a line Powerschell:

that only replaces the spaces by commas :

#tausche in allen Zeilen:
# ein/mehr leerzeichen durch Komma
gc 'test.gsi'|%{$_ -replace '\s+' , ','}>test.csv

I do not know what importance the individual number groups have.

theoretically, you can exchange any character(groups) with the -replace operator against other characters(groups) and thus, for example, exchange the points with field separators (comma/semikolon).

#tausche in allen Zeilen:
# ein/mehr leerzeichen durch Komma
#ein/mehr Punkt durch Komma
gc 'test.txt'|%{$_ -replace '\s+',',' -replace  '\.+',','}>test.csv

Attention! Powershells replaceoperatorr uses RegEx as search patches for strings to be exchanged.

0