J'aimerais créer une macro me permettant de traiter ce fichier et de le mettre au format .csv sous la forme suivanteFri Jul 2 11:09:11 2010
- Page: 1
S:SAVINESSV5_001:ne1696MS 3.0 Remote Inventory
Board User Label :r01sr1/board#01
Board Location :
Board Type : ESC
ALCATEL Company : ASHB
CLEI Code : WMUCA2KBAA
Unit Part Number : 3AL86661ACAA02
Software Part Number: 3AL95155AAAA02
Serial Number : YP1002085E5
Unit Type : ESC
Factory Identifier : YP
Date Identifier : 00 - Date of final test
Date : 10/02/24
Operator Data : --------------------------------
------------------------------------------------------------------------------
Board User Label :r01sr1/board#03
Board Location :
Board Type : OMDX8100_M_L1_XS_NOSPV
ALCATEL Company : ASHB
CLEI Code : WMD5H0KCAA
Unit Part Number : 3AL86615AAAF01
Software Part Number: --------------
Serial Number : YP1008071D9
Unit Type : OMDX8100
Factory Identifier : YP
Date Identifier : 00 - Date of final test
Date : 10/02/28
Operator Data : --------------------------------
------------------------------------------------------------------------------
/r01sr1/board#01;S:SAVINESSV5_001;;ESC;3AL86661AC;AA02;YP1002085E5;Fri Jul 2 11:09:11 2010
/r01sr1/board#03;S:SAVINESSV5_001;;OMDX8100_M_L1_XS_NOSPV;3AL86615AA;AF01;YP1008071D9;Fri Jul 2 11:09:11 2010
Sub lireFichierTexte()
Dim Ligne As String
Dim Tblo(0 To 7)
Application.ScreenUpdating = False
[COLOR="Red"][B]Open "C:\Users\TonNom\Documents\Excel\import fich.txt"[/B][/COLOR] For Input As #1
Do While Not EOF(1)
Line Input #1, Ligne
If i = 0 Then
Tblo(7) = Trim(Ligne)
ElseIf i = 2 Then
Tblo(1) = Trim(Left(Ligne, InStr(1, Ligne, ":ne") - 1))
ElseIf Left(Ligne, 10) = "Board User" Then
Tblo(0) = "/" & Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":")))
ElseIf Left(Ligne, 14) = "Board Location" Then
Tblo(2) = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":")))
ElseIf Left(Ligne, 10) = "Board Type" Then
Tblo(3) = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":")))
ElseIf Left(Ligne, 9) = "Unit Part" Then
Tblo(4) = Left(Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":"))), 10)
Tblo(5) = Trim(Right(Ligne, 4))
ElseIf Left(Ligne, 6) = "Serial" Then
Tblo(6) = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":")))
[A65000].End(xlUp)(2) = Join(Tblo, ";")
End If
i = i + 1
Loop
Close #1
Columns("A").AutoFit
End Sub
Windows("ExtraitTest1.xls").Activate
Windows("ExtraitTest1.xls").Activate
Open ThisWorkbook.Path & "\2000_1.ri" For Input As #1
ActiveWorkbook.SaveAs Filename:="C:\test.csv", FileFormat:=xlCSV, CreateBackup:=False
Fri Jul 2 11:09:11 2010
- Page: 1
S:SAVINESSV5_001:ne1696MS 3.0 Remote Inventory
Board User Label :r01sr1/board#01
Board Location :
Board Type : ESC
ALCATEL Company : ASHB
CLEI Code : WMUCA2KBAA
Unit Part Number : 3AL86661ACAA02
Software Part Number: 3AL95155AAAA02
Serial Number : YP1002085E5
Unit Type : ESC
Factory Identifier : YP
Date Identifier : 00 - Date of final test
Date : 10/02/24
Operator Data : --------------------------------
uploadRemoteInventory started at 2010/07/01 06:17:19 on <MARSL_MANOSQUE_0001>
USER LABEL : MARSL_MANOSQUE_0001/r01sr1/board#01
LOCATION NAME :
ELEMENT IDENTIFICATION
ALCATEL company : AITA
Unit type : ESC
Unit part number : 3AL86661ABAA03
Software part number : 3AL95155AAAA02
CLEI code : WMUCA2JBAA
MANUFACTURING INFORMATION
Manufacturing plant : EZ
Serial number : EZ074533943
Date (00) : 07/12/05
OPERATOR INVENTORY DATA
ls ne répertorient pas tous le même nombre de données
USER LABEL : MARSL_MANOSQUE_0001/r01sr1/board#02
LOCATION NAME :
ELEMENT IDENTIFICATION
ALCATEL company : AITA
Unit type : OMDX8100
Unit part number : 3AL86615ABAE01
Software part number : --------------
CLEI code : WMD5H0LCAA
MANUFACTURING INFORMATION
Manufacturing plant : EZ
Serial number : EZ081932136
Date (00) : 08/05/15
OPERATOR INVENTORY DATA