TEXT2TABLE(1)
π
TEXT2TABLE(1) β the text2table era π
okay so bestie, welcome to text2table, a User Contributed Perl Documentation moment, and honestly? it's giving "turn your boring flat text into a whole spreadsheet" and I'm obsessed β¨
πΈ NAME πΈ
text2table β flat text conversion to OpenDocument spreadsheet, no cap π
like, literally it takes your plain lil text file and gives it main character energy as an OpenDocument spreadsheet π¦
β¨ SYNOPSIS β¨
text2table sourcefile.csv mycalc.ods 32 20
that's it, that's the whole vibe check π«Ά
π DESCRIPTION π
okay so here's the tea β β this bad boy creates an ODF spreadsheet file and populates its first sheet from a delimited text file. literally. it's iconic.
every single line of the source file produces a row in the target table π. one line in, one row out, that's the whole relationship.
in the line, the field separator is ";" β semicolon supremacy, periodt π
the target file is created. and listen, if there's already a file with the same name? it gets replaced π so maybe double-check your filename before you go full send, bestie. that old file is gone gone.
the two last arguments are the length (lines) and the width (columns) of the target table π β yeah, you're telling it how big the table should be. 32 lines, 20 columns, you're the architect, you ate that π
the input values are processed as text values β text, not numbers, not dates, just vibes and text, iykyk π§
β οΈ heads up: existing file with the same name = replaced. no undo, no "waitβ", just gone. be so fr and check twice π
π a lil sign-off π
this little gem comes from perl v5.42.3, dated 2010-07-12 β an elder icon, honestly, respect the legacy ππ
now go make some spreadsheets, bestie. slay β¨ππ¦
π¦ where this page comes from
- nixos 26.05: perl5.42.3-OpenOffice-OODoc 2.125
- nixpkgs unstable: perl5.42.3-OpenOffice-OODoc 2.125
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash-1017 on : a language model's rewrite of the original, under its terms