U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » Community » Newbie corner » Read txt, analyze and convert to csv

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Read txt, analyze and convert to csv [message #53281 is a reply to message #53183]

Wed, 25 March 2020 20:26

idkfa46 is currently offline

idkfa46
Messages: 155
Registered: December 2011

Experienced Member

Going ahead with the development of my tool I discovered this strange situation:

here is and example my csv output:

"20200103";"0113E0            ";"SEMICUSCINETTO                ";"00000001594";"H ";Common part
"20200103";"0113E1            ";"SEMICUSCINETTO                ";"00000001582";"H ";Common part
"20200103";"0113E2            ";"SEMICUSCINETTO                ";"00000002264";"H ";Common part
"20200103";"0113E3            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part
"20200103";"0113E4            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part

The problem is that opening it with microsoft Excel the are part numbers like "0113E2 " are automatically converted in a scientific format and becaome 1,13E+02...

Maybe the solution to force it like a Text should be to include a ' at the beginning of the number...

What do you think?

Best,
Matteo

Report message to a moderator

Send a private message to this user

[Message index]

		Read txt, analyze and convert to csv By: idkfa46 on Sun, 15 March 2020 16:52
		Re: Read txt, analyze and convert to csv By: omari on Tue, 17 March 2020 09:45
		Re: Read txt, analyze and convert to csv By: idkfa46 on Wed, 18 March 2020 13:27
		Re: Read txt, analyze and convert to csv By: omari on Wed, 18 March 2020 17:31
		Re: Read txt, analyze and convert to csv By: idkfa46 on Fri, 20 March 2020 09:40
		Re: Read txt, analyze and convert to csv By: idkfa46 on Mon, 23 March 2020 13:21
		Re: Read txt, analyze and convert to csv By: omari on Tue, 24 March 2020 15:20
		Re: Read txt, analyze and convert to csv By: idkfa46 on Tue, 24 March 2020 15:52
		Re: Read txt, analyze and convert to csv By: idkfa46 on Wed, 25 March 2020 20:26
		Re: Read txt, analyze and convert to csv By: idkfa46 on Thu, 26 March 2020 10:50
		Re: Read txt, analyze and convert to csv By: idkfa46 on Tue, 31 March 2020 09:57
		Re: Read txt, analyze and convert to csv By: omari on Tue, 31 March 2020 15:17
		Re: Read txt, analyze and convert to csv By: idkfa46 on Tue, 31 March 2020 16:35

Previous Topic:	[SOLVED] Cloning Array of complexe type
Next Topic:	OptionTree inside a DropTree

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Fri Jun 20 18:05:05 CEST 2025

Total time taken to generate the page: 0.04190 seconds