TEXT2TABLE(1)

πŸ“¦ version 2.125, in nixos 26.05, nixpkgs unstable

πŸ’… 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