Sign in to follow this  
Followers 0
quicksilver

Dateinamen einlesen. Teil extrahieren und eine csv datei erstellen.

7 posts in this topic

#1 ·  Posted (edited)

Hallo Ich habe folgendes vor. Ich habe ein Ordner in dem sich ca 22.000 txt Files befinden bei denen ich an einer bestimmten Stelle vom Dateinamen eine Information auslesen muss und mit dieser Information muss ich eine csv erstellen. Das sollte so aussehen:

Die Textfiles:

GIS_RG_200512002115_561330_15-3086_20060717.TXT
GIS_RG_200512002116_561342_15-0298_20060726.TXT
GIS_RG_200512002117_561343_15-0702_20060801.TXT
GIS_RG_200512002120_051223_16-0308_20060102.TXT
GIS_RG_200512002121_051218_16-0527_20060102.TXT
GIS_RG_200512002122_051238_16-0549_20060102.TXT

davon brauche ich nun 2 Positionen:

GIS_RG_200512002122_051238_16-0549_20060102.TXT

GIS_RG_200512002120_051223_16-0308_20060102.TXT

GIS_RG_200512002121_051218_15-0527_20060102.TXT

..

Die beiden werte sollen nun ausgelesen und damit eine CSV Datei in folgendem Format erstellt werden

RG-NR;Ausgabegruppe
051238;16
051223;16
051218;15
..
..

So sollte das ablaufen. Kann mir da jemand helfen?

Wäre echt Super.

Danke

Edited by quicksilver

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

HI,

; TXT files

#Include <File.au3>
#Include <Array.au3>
$FileList=_FileListToArray(@ScriptDir, '*.txt', 1)
If (Not IsArray($FileList)) and (@Error=1) Then
    MsgBox (0,"","No Files\Folders Found.")
    Exit
EndIf

Global $rg[UBound($FileList)]
Global $nr[UBound($FileList)]

For $i=0 To UBound($FileList)-1
    $rg[$i] = StringMid($FileList[$i], 21, 6)
    $nr[$i] = StringMid($FileList[$i], 28, 2)
Next

_ArrayDisplay($rg,"$FileList")
_ArrayDisplay($nr,"$FileList")

So long,

Mega :P

Edited by th.meger

Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

Hey ! Vielen Dank funktioniert bis jetzt 100% so wie gewünscht :P

Super Arbeit !!

Danke !

Share this post


Link to post
Share on other sites

Hi,

no problem! Glad that I could help you out!

So long,

Mega :P


Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

Not that it is a great big deal, but I have no clue what you are writing - please if we need to write in another language can we at least get a translation?


All by me:

"Sometimes you have to go back to where you started, to get to where you want to go." 

"Everybody catches up with everyone, eventually" 

"As you teach others, you are really teaching yourself."

From my dad

"Do not worry about yesterday, as the only thing that you can control is tomorrow."

 

WindowsError.gif

WIKI | Tabs; | Arrays; | Strings | Wiki Arrays | How to ask a Question | Forum Search | FAQ | Tutorials | Original FAQ | ONLINE HELP | UDF's Wiki | AutoIt PDF

AutoIt Snippets | Multple Guis | Interrupting a running function | Another Send

StringRegExp | StringRegExp Help | RegEXTester | REG TUTOR | Reg TUTOT 2

AutoItSetOption | Macros | AutoIt Snippets | Wrapper | Autoit  Docs

SCITE | SciteJump | BB | MyTopics | Programming | UDFs | AutoIt 123 | UDFs Form | UDF

Learning to script | Tutorials | Documentation | IE.AU3 | Games? | FreeSoftware | Path_Online | Core Language

Programming Tips

Excel Changes

ControlHover.UDF

GDI_Plus

Draw_On_Screen

GDI Basics

GDI_More_Basics

GDI Rotate

GDI Graph

GDI  CheckExistingItems

GDI Trajectory

Replace $ghGDIPDll with $__g_hGDIPDll

DLL 101?

Array via Object

GDI Swimlane

GDI Plus French 101 Site

GDI Examples UEZ

GDI Basic Clock

GDI Detection

Ternary operator

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

Igberten oogen bluken ver bloken der smooten vlooben.

Lar.

Hi,

@Larry: What? :P Are you ill? :nuke:

To cut a long story short: It is all about getting data from a folder with 22000 files. Task was to get a part of the file names and save them as mentioned above in a csv file.

So long,

Mega

Edited by th.meger

Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0