English
Forum

Hello - CSV-Files - first Anfänge with XProfan

 
- Page 1 -


Hi,
I have yet never with Profan worked. through my trouble (see under) has me one known said, look you time profane on and try it self.

I have a csv-File. she has The Spaltenköpfe a-z.
here's in the first row The english Bezeichnung drin and the 2 row The German.
ex the 3 row are The Datensätze. you're different big, in manchen Feldern are too no Datensätze present.
It can a different number of Lines itself yield. there are Texts, numbers and date into unterschiedlichen boxes present.
i want now gladly these File loading and each row gladly in the Mainwindow spend.
have me already times the command Load, print, cls, window angeschaut. wars too small Printouts there. ber How make I with the Load and surrender in this accrue The variables ?
can me there of/ one help ?

Greeting
Detlef....
 
09/03/11  
 



 
- Page 1 -


no trouble, but Why meldest you not on?  [...] 


i want now gladly these File loading and each row gladly in the Mainwindow spend.


Perhaps simply so:
declare s$
cls
assign #1,"meinedatei.csv"
reset #1

whilenot eof(#1)

    input #1,s$
    print s$
    sleep 500

wend

close #1
waitInput
end

*ungetestet
 
09/03/11  
 



Hello iF,

with the the register have I on later moved.
wished first see, whether I with the whole thing clear come.
unless let I it again.
If I naturally weiterversuche I will me too register.

already time thanks for your hint/code, will be it now test times.

Detlef
 
09/03/11  
 



Jau, should one Perhaps moreover allude the it too moreover many different Lösungsansätze gives -

almost How always.

Related to the Login was only one hint because You then indeed plenty More functions have and with Answer benachrichtig become.

If you one genaueres example benötigst then always out so.
 
09/03/11  
 



Hello iF,

your example is a beginning, it shows me but everything on.

I had gladly the the first both Reihen not abgerufen go I need The english and german Überschriften not.
The others values had I gladly in variables, wovon I me a or others then Call and Show let would like.

I faith with the the File Upload works here only if one announced is.

example..... scheduler

A B C D E F
1 english überschriften
2 German überschriften
3 Mustermann Max 01.04.1960 Musterstadt Yes
4 Musterfrau Maxi 01.04.1965 Musterdorf No
5

I hope You can what so begin............

Detlef
 
09/04/11  
 




H.Brill
well, then lead still simply a
Zählervariable with. To 65535 or so
reicht yes a plainer Integer.
declare s$, counter%
cls
counter% = 0
assign #1,"meinedatei.csv"
reset #1

whilenot eof(#1)

    input #1,s$
    Inc counter%

    If counter% > 2

        print s$
        sleep 500

    Endif

wend

close #1
waitInput
end
 
Benutze XPROFAN X3 + FREEPROFAN
Wir sind die XProfaner.
Sie werden von uns assimiliert.
Widerstand ist zwecklos!
Wir werden alle ihre Funktionen und Algorithmen den unseren hinzufügen.

Was die Borg können, können wir schon lange.
09/04/11  
 



or it läd to while two zeilen by input
...
declare ueber1$
declare ueber2$
reset #1
input ueber1$
input ueber2$

whilenot ...


I faith as Guest can here too hochkaden but one must before a longer Text association having.

genaueres knows there but only if.
 
09/04/11  
 




Thomas
Freier
i'd for csv-Files, straight with XProfan 8, Franks List view.dll [...]  bring into action. The Examples can already time crux (Bildverarbeitung, variables Deklarierung with var ggf. Change in Declare) there some Examples first ex XProfan10 walk.
 
Gruß Thomas
Windows XP SP2, XProfan X2
09/04/11  
 



Untitled (04.09.11)
Hello iF,

your example is a beginning, it shows me but everything on.

I had gladly the the first both Reihen not abgerufen go I need The english and german Überschriften not.


Ah, would I then well (How my Vorposter) so solve:
declare s$,lin1$,lin2$
cls
assign #1,"meinedatei.csv"
reset #1
input #1,lin1$
input #1,lin2$

whilenot eof(#1)

    input #1,s$
    print s$
    sleep 500

wend

close #1
waitInput
end

Untitled (04.09.11)
The others values had I gladly in variables, wovon I me a or others then Call and Show let would like.


there empfielt itself well one undertow. aray or. a aray-Variable:
declare s$,lin1$,lin2$,lines$[96000],c&
cls
assign #1,"meinedatei.csv"
reset #1
input #1,lin1$
input #1,lin2$

whilenot eof(#1)

    input #1,s$
    lines$[c&]=s$
    inc c&

wend

close #1
print "Zeile 1:",lines$[0]
print "Zeile 10:",lines$[9]
print "Zeile 100:",lines$[99]
waitInput
end

Untitled (04.09.11)
I faith with the the File Upload works here only if one announced is.


here on XProfan.com have You fundamentally infinite plenty Speicherplatz and can so plenty Upload How You want -

only as Guest must one before something Time passing let and derweil something into Posting-Editor type there one otherwise as offered verkannt and is the community on a "Zu-Schnell"-warning-Page umlenkt.

If you announced are must You you at Beiträgeverfassen however no Time take and can immediate Upload/ write etc...
 
09/04/11  
 



the was already into right direction.

now sees The spending so from:
row 10: "10";"Max Mustermann";"Mustermann";"Max";;;;;"01.04.1940";"Musterstadt"
Beautiful would it if I this had as spending:
ID = 10
name = Max Musterman
date of birth = 01.04.1940
Place of residence = Musterstadt
the name ought to itself from "Max" + "Mustermann" zusammensetzen.

it should no Address go, separate only one read of designed data, The I need.

Detlef....
 
09/04/11  
 



You can Yes instead of:
print "Zeile 100:",lines$[99]
simply time
print "Zeile 100:",substr$(lines$[99],2,"\q,\q")
write -

look you means time SubStr$ on.
 
09/04/11  
 



 
- Page 2 -


Hello, I gebs on in my old would it of course yet Gehirntraining, but its still well To high for me.
I thanks you any for eure endeavours.
I take rather still whom middle-aged me known lane.

Please this issue as Done transfiguring, there it me always on The Login-Site lenkt.

thanks Detlef
 
09/06/11  
 




Jörg
Sellmeyer
I suppose, The quotation marks are the CSV-File. without would it something übersichtlicher but so goes it:
Declare row$,ID$,name$,date$,place$
Zeile$ = ""10";"Max Mustermann";"Mustermann";"Max";;;;;"01.04.1940";"Musterstadt""
Zeile$ = Translate$(row$,"\q","")
ID$ = SubStr$(row$,1,";")
Name$ = SubStr$(row$,4,";") + " " + SubStr$(row$,3,";")
Datum$ = SubStr$(row$,9,";")
Ort$ = SubStr$(row$,10,";")
Print ID$
Print name$
Print date$
Print place$
WaitInput
 
Windows XP SP2 XProfan X4
... und hier mal was ganz anderes als Profan ...
09/06/11  
 




Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

17.380 Views

Untitledvor 0 min.
Torben Nissen06/27/24
RudiB.01/31/22
Manfred Barei03/11/20
kustg05/10/19
More...

Themeninformationen



Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie