I’m attempting to repeat/paste the output of my terminal from VS Code into three columns (datetime, latitude, longitude) in a .numbers desk. Mainly, I am operating a script that offers me datetime, lat, lon in my Terminal.
Whereas Excel has had not bother placing the output in three separate cells, Numbers does not appear to be recognizing tab nor comma-separated values as column separators. I do know I might resolve this by making a .csv file as an alternative, after which importing it into Numbers, however that is unpractical for my context.
Am I lacking one thing? Is that this simply not one thing that is possible with Numbers?
I’ve tried manually copy-pasting the output from the Terminal, and automating the ‘copy’ by way of pbcopy, however none have labored. I find yourself with every little thing in a single cell.
Here is a snippet of the code.
current_time = datetime.now(UTC)
datetime_with_ms = current_time.strftime('%Y-%m-%d %H:%M:%S.%f')[:-3]
lat = msg.latitude
lon = msg.longitude
#To manually copy-paste
print(f"{datetime_with_ms}t{lat}t{lon}")
#automated copy into clipboard
output_line = f"{datetime_with_ms}t{lat}t{lon}"
subprocess.run("pbcopy", textual content=True, enter=output_line)
