Load and format a CSV file

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Load and format a CSV file

fioranosnake
Silly Frenchman

Posts: 37

Threads: 14

Joined: Aug 2019

Reputation: 0

Oct-29-2019, 03:48 PM

Hi,

If I open my txt file in notepad it looks as follows :

1231241231
1235135135
5457345345
4577865568
8654563848

and so on.

If I format the text file to look like :

1231241231,1235135135,5457345345,4577865568,8654563848

Then the solutions you have suggested work perfectly..

Do I need to carry out some formatting beforehand when the txt file is read?

Thanks again

Find

Messages In This Thread

Load and format a CSV file - by fioranosnake - Oct-28-2019, 05:35 PM

RE: Load and format a CSV file - by perfringo - Oct-28-2019, 06:57 PM

RE: Load and format a CSV file - by snippsat - Oct-28-2019, 07:02 PM

RE: Load and format a CSV file - by Gribouillis - Oct-28-2019, 07:23 PM

RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 09:53 AM

RE: Load and format a CSV file - by snippsat - Oct-29-2019, 10:01 AM

RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 03:48 PM

RE: Load and format a CSV file - by snippsat - Oct-29-2019, 06:33 PM

RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 09:29 PM

RE: Load and format a CSV file - by snippsat - Oct-29-2019, 10:09 PM

RE: Load and format a CSV file - by fioranosnake - Oct-30-2019, 10:45 AM

RE: Load and format a CSV file - by perfringo - Oct-30-2019, 12:32 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to load all pages of the pdf file to the program	alicenguyen	9	2,369	Jul-04-2022, 03:14 AM Last Post: alicenguyen
	Reshape txt file into particular format using python	shantanu97	0	1,459	Dec-10-2021, 11:44 AM Last Post: shantanu97
	How can we transcode encoding file uml url format	Anldra12	9	3,473	Jul-25-2021, 09:30 AM Last Post: Anldra12
	How to design a save file format?	philipbergwerf	5	4,195	Apr-26-2021, 07:39 PM Last Post: Gribouillis
	CPC File Format (Cartesian Perceptual Compression) - Can Python Convert / Handle Them	PSKrieger	2	2,513	Nov-11-2020, 02:57 PM Last Post: PSKrieger
	Need help implmenting if/else or case statements for option to choose file format.	samlee916	1	2,041	Jul-22-2020, 06:06 PM Last Post: Larz60+
	copy/pasting in excel WHILE keep file format	zarize	0	1,994	Jun-23-2020, 03:51 PM Last Post: zarize
	Preserve xml file format	tanffn	3	3,957	Jan-03-2020, 09:35 AM Last Post: Larz60+
	Phyton code to load a comma separated csv file in to a dict and then in to a dB	mrsenorchuck	2	2,690	Nov-29-2019, 10:59 AM Last Post: mrsenorchuck
	Please suggest python code to format DNA sequence FASTA file	rajamdade	4	3,211	Oct-24-2019, 04:36 AM Last Post: rajamdade

Users browsing this thread: 2 Guest(s)

View a Printable Version

Load and format a CSV file

User Panel Messages

Announcements