Regex : prendre en compte les "_OK" ou "_KO" en fin de chaine

**JavaGuava** · 05/07/2022, 18h17

Bonjour,

Je souhaite scinder ligne par ligne les enregistrements de mon ArrayList L3.

Le résultat devra être comme cela :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
L1_C1_"blabla bla"_OK, L1_C2_"totot"_OK, L1_C3_"SALES_JOURNAL"_OK, L1_C4_""_OK, ... L1_C5_"END"_OK, 
L2_C1_"0"_KO, L2_C2_"3260"_KO, L2_C3_"CHK_CASHING_CHECK_IN_PROGRESS_20210329_3260_EUR_S"_KO, ... L2_C43_"END"_OK,
L3_C6_"ZX_TRANSACTION"_OK, L3_C7_""_OK, L3_C8_"SALES_JOURNAL"_OK, L3_C9_""_OK, ... L3_C43_"END"_OK,
L4_...... L2_C43_"END"_OK,
L5_...
L6_...

Voici le contenu de mon ArrayList L3 :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
L3 = [L1_C1_"0"_KO, L1_C2_"3260"_KO, L1_C3_"CHK_CASHING_CHECK_CREDITED_20210329_3260_EUR_S"_KO, L1_C4_""_OK, L1_C5_"ZX"_OK, L1_C6_"ZX_TRANSACTION"_OK, L1_C7_""_OK, L1_C8_"SALES_JOURNAL"_OK, L1_C9_""_OK, L1_C10_"FR1_LE"_OK, L1_C11_"FR"_OK, L1_C12_"2021/03/31"_OK, L1_C13_""_OK, L1_C14_""_OK, L1_C15_""_OK, L1_C16_"2021/03/29"_OK, L1_C17_"EUR"_OK, L1_C18_"2021/03/29"_OK, L1_C19_""_OK, L1_C20_"EU0_LOCAL"_OK, L1_C21_"0.00000"_OK, L1_C22_"81149916172"_KO, L1_C23_""_OK, L1_C24_""_OK, L1_C25_""_OK, L1_C26_""_OK, L1_C27_""_OK, L1_C28_""_OK, L1_C29_""_OK, L1_C30_""_OK, L1_C31_""_OK, L1_C32_""_OK, L1_C33_""_OK, L1_C34_""_OK, L1_C35_""_OK, L1_C36_""_OK, L1_C37_""_OK, L1_C38_""_OK, L1_C39_""_OK, L1_C40_""_OK, L1_C41_""_OK, L1_C42_""_OK, L1_C43_"END"_OK, L2_C1_"0"_KO, L2_C2_"3260"_KO, L2_C3_"CHK_CASHING_CHECK_IN_PROGRESS_20210329_3260_EUR_S"_KO, L2_C4_""_OK, L2_C5_"ZX"_OK, L2_C6_"ZX_TRANSACTION"_OK, L2_C7_""_OK, L2_C8_"SALES_JOURNAL"_OK, L2_C9_""_OK, L2_C10_"FR1_LE"_OK, L2_C11_"FR"_OK, L2_C12_"2021/03/31"_OK, L2_C13_""_OK, L2_C14_""_OK, L2_C15_""_OK, L2_C16_"2021/03/29"_OK, L2_C17_"EUR"_OK, L2_C18_"2021/03/29"_OK, L2_C19_""_OK, L2_C20_"EU0_LOCAL"_OK, L2_C21_"0.00000"_OK, L2_C22_"81149916172"_KO, L2_C23_""_OK, L2_C24_""_OK, L2_C25_""_OK, L2_C26_""_OK, L2_C27_""_OK, L2_C28_""_OK, L2_C29_""_OK, L2_C30_""_OK, L2_C31_""_OK, L2_C32_""_OK, L2_C33_""_OK, L2_C34_""_OK, L2_C35_""_OK, L2_C36_""_OK, L2_C37_""_OK, L2_C38_""_OK, L2_C39_""_OK, L2_C40_""_OK, L2_C41_""_OK, L2_C42_""_OK, L2_C43_"END"_OK, L3_C1_"0"_KO, L3_C2_"3260"_KO, L3_C3_"FRAUD_REGUL_LOSS_20210329_3260_EUR_S"_KO, L3_C4_""_OK, L3_C5_"ZX"_OK, L3_C6_"ZX_TRANSACTION"_OK, L3_C7_""_OK, L3_C8_"SALES_JOURNAL"_OK, L3_C9_""_OK, L3_C10_"FR1_LE"_OK, L3_C11_"FR"_OK, L3_C12_"2021/03/31"_OK, L3_C13_""_OK, L3_C14_""_OK, L3_C15_""_OK, L3_C16_"2021/03/29"_OK, L3_C17_"EUR"_OK, L3_C18_"2021/03/29"_OK, L3_C19_""_OK, L3_C20_"EU0_LOCAL"_OK, L3_C21_"0.00000"_OK, L3_C22_"81149916172"_KO, L3_C23_""_OK, L3_C24_""_OK, L3_C25_""_OK, L3_C26_""_OK, L3_C27_""_OK, L3_C28_""_OK, L3_C29_""_OK, L3_C30_""_OK, L3_C31_""_OK, L3_C32_""_OK, L3_C33_""_OK, L3_C34_""_OK, L3_C35_""_OK, L3_C36_""_OK, L3_C37_""_OK, L3_C38_""_OK, L3_C39_""_OK, L3_C40_""_OK, L3_C41_""_OK, L3_C42_""_OK, L3_C43_"END"_OK, L4_C1_"0"_KO, L4_C2_"3260"_KO, L4_C3_"SEIZURE_SEIZURE_20210329_3260_EUR_S"_KO, L4_C4_""_OK, L4_C5_"ZX"_OK, L4_C6_"ZX_TRANSACTION"_OK, L4_C7_""_OK, L4_C8_"SALES_JOURNAL"_OK, L4_C9_""_OK, L4_C10_"FR1_LE"_OK, L4_C11_"FR"_OK, L4_C12_"2021/03/31"_OK, L4_C13_""_OK, L4_C14_""_OK, L4_C15_""_OK, L4_C16_"2021/03/29"_OK, L4_C17_"EUR"_OK, L4_C18_"2021/03/29"_OK, L4_C19_""_OK, L4_C20_"EU0_LOCAL"_OK, L4_C21_"0.00000"_OK, L4_C22_"81149916172"_KO, L4_C23_""_OK, L4_C24_""_OK, L4_C25_""_OK, L4_C26_""_OK, L4_C27_""_OK, L4_C28_""_OK, L4_C29_""_OK, L4_C30_""_OK, L4_C31_""_OK, L4_C32_""_OK, L4_C33_""_OK, L4_C34_""_OK, L4_C35_""_OK, L4_C36_""_OK, L4_C37_""_OK, L4_C38_""_OK, L4_C39_""_OK, L4_C40_""_OK, L4_C41_""_OK, L4_C42_""_OK, L4_C43_"END"_OK, L5_C1_"1"_KO, L5_C2_"3260"_KO, L5_C3_"CHK_CASHING_CHECK_CREDITED_20210329_3260_EUR_S"_KO, L5_C4_"01"_OK, L5_C5_""_OK, L5_C6_""_OK, L5_C7_""_OK, L5_C8_"LINE"_OK, L5_C9_"INVOICE"_OK, L5_C10_"000013759000000005"_KO, L5_C11_""_OK, L5_C12_"S"_OK, L5_C13_""_OK, L5_C14_"200.00000"_OK, L5_C15_"2021/03/29"_OK, L5_C16_"00100.261107100.00000.00000.00000.00000.00000.00000"_KO, L5_C17_"00100.251110000.00000.00000.00000.00000.00000.00000"_OK, L5_C18_"N"_OK, L5_C19__OK, L5_C20_""_OK, L5_C21_""_OK, L5_C22_""_OK, L5_C23_""_OK, L5_C24_""_OK, L5_C25_""_OK, L5_C26_""_OK, L5_C27_""_OK, L5_C28_""_OK, L5_C29_""_OK, L5_C30_"FRSXME00"_OK, L5_C31_""_OK, L5_C32_""_OK, L5_C33_""_OK, L5_C34_""_OK, L5_C35_""_OK, L5_C36_""_OK, L5_C37_""_OK, L5_C38_""_OK, L5_C39_""_OK, L5_C40_""_OK, L5_C41_""_OK, L5_C42_""_OK, L5_C43_""_OK, L5_C44_""_OK, L5_C45_""_OK, L5_C46_""_OK, L5_C47_""_OK, L5_C48_""_OK, L5_C49_""_OK, L5_C50_""_OK, L5_C51_""_OK, L5_C52_""_OK, L5_C53_""_OK, L5_C54_""_OK, L5_C55_""_OK, L5_C56_""_OK, L5_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L5_C58_""_OK, L5_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L5_C60_""_OK, L5_C61_""_OK, L5_C62_"000013760000000001"_KO, L5_C63_""_OK, L5_C64_""_OK, L5_C65_""_OK, L5_C66_""_OK, L5_C67_""_OK, L5_C68_""_OK, L5_C69_""_OK, L5_C70_""_OK, L5_C71_""_OK, L5_C72_""_OK, L5_C73_""_OK, L5_C74_""_OK, L5_C75_""_OK, L5_C76_""_OK, L5_C77_""_OK, L5_C78_""_OK, L5_C79_""_OK, L5_C80_""_OK, L5_C81_""_OK, L5_C82_""_OK, L5_C83_""_OK, L5_C84_""_OK, L5_C85_""_OK, L5_C86_""_OK, L5_C87_""_OK, L5_C88_""_OK, L5_C89_""_OK, L5_C90_""_OK, L5_C91_""_OK, L5_C92_""_OK, L5_C93_""_OK, L5_C94_""_OK, L5_C95_""_OK, L5_C96_""_OK, L5_C97_""_OK, L5_C98_""_OK, L5_C99_""_OK, L5_C100_""_OK, L5_C101_""_OK, L5_C102_""_OK, L5_C103_""_OK, L5_C104_""_OK, L5_C105_""_OK, L5_C106_""_OK, L5_C107_""_OK, L5_C108_""_OK, L5_C109_""_OK, L5_C110_""_OK, L5_C111_""_OK, L5_C112_""_OK, L5_C113_""_OK, L5_C114_""_OK, L5_C115_""_OK, L5_C116_""_OK, L5_C117_"13759000000005"_KO, L5_C118_""_OK, L5_C119_""_OK, L5_C120_"END"_OK, L6_C1_"1"_KO, L6_C2_"3260"_KO, L6_C3_"CHK_CASHING_CHECK_CREDITED_20210329_3260_EUR_S"_KO, L6_C4_"02"_OK, L6_C5_""_OK, L6_C6_""_OK, L6_C7_""_OK, L6_C8_"LINE"_OK, L6_C9_"INVOICE"_OK, L6_C10_"000013759000000006"_KO, L6_C11_""_OK, L6_C12_"S"_OK, L6_C13_""_OK, L6_C14_"200.00000"_OK, L6_C15_"2021/03/29"_OK, L6_C16_"00100.261107100.00000.00000.00000.00000.00000.00000"_KO, L6_C17_"00100.262104100.00000.00000.00000.00000.00000.00000"_OK, L6_C18_"N"_OK, L6_C19__OK, L6_C20_""_OK, L6_C21_""_OK, L6_C22_""_OK, L6_C23_""_OK, L6_C24_""_OK, L6_C25_""_OK, L6_C26_""_OK, L6_C27_""_OK, L6_C28_""_OK, L6_C29_""_OK, L6_C30_"FRSXME00"_OK, L6_C31_""_OK, L6_C32_""_OK, L6_C33_""_OK, L6_C34_""_OK, L6_C35_""_OK, L6_C36_""_OK, L6_C37_""_OK, L6_C38_""_OK, L6_C39_""_OK, L6_C40_""_OK, L6_C41_""_OK, L6_C42_""_OK, L6_C43_""_OK, L6_C44_""_OK, L6_C45_""_OK, L6_C46_""_OK, L6_C47_""_OK, L6_C48_""_OK, L6_C49_""_OK, L6_C50_""_OK, L6_C51_""_OK, L6_C52_""_OK, L6_C53_""_OK, L6_C54_""_OK, L6_C55_""_OK, L6_C56_""_OK, L6_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L6_C58_""_OK, L6_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L6_C60_""_OK, L6_C61_""_OK, L6_C62_"000013760000000001"_KO, L6_C63_""_OK, L6_C64_""_OK, L6_C65_""_OK, L6_C66_""_OK, L6_C67_""_OK, L6_C68_""_OK, L6_C69_""_OK, L6_C70_""_OK, L6_C71_""_OK, L6_C72_""_OK, L6_C73_""_OK, L6_C74_""_OK, L6_C75_""_OK, L6_C76_""_OK, L6_C77_""_OK, L6_C78_""_OK, L6_C79_""_OK, L6_C80_""_OK, L6_C81_""_OK, L6_C82_""_OK, L6_C83_""_OK, L6_C84_""_OK, L6_C85_""_OK, L6_C86_""_OK, L6_C87_""_OK, L6_C88_""_OK, L6_C89_""_OK, L6_C90_""_OK, L6_C91_""_OK, L6_C92_""_OK, L6_C93_""_OK, L6_C94_""_OK, L6_C95_""_OK, L6_C96_""_OK, L6_C97_""_OK, L6_C98_""_OK, L6_C99_""_OK, L6_C100_""_OK, L6_C101_""_OK, L6_C102_""_OK, L6_C103_""_OK, L6_C104_""_OK, L6_C105_""_OK, L6_C106_""_OK, L6_C107_""_OK, L6_C108_""_OK, L6_C109_""_OK, L6_C110_""_OK, L6_C111_""_OK, L6_C112_""_OK, L6_C113_""_OK, L6_C114_""_OK, L6_C115_""_OK, L6_C116_""_OK, L6_C117_"13759000000006"_KO, L6_C118_""_OK, L6_C119_""_OK, L6_C120_"END"_OK, L7_C1_"1"_KO, L7_C2_"3260"_KO, L7_C3_"CHK_CASHING_CHECK_IN_PROGRESS_20210329_3260_EUR_S"_KO, L7_C4_"03"_OK, L7_C5_""_OK, L7_C6_""_OK, L7_C7_""_OK, L7_C8_"LINE"_OK, L7_C9_"INVOICE"_OK, L7_C10_"000013759000000007"_KO, L7_C11_""_OK, L7_C12_"S"_OK, L7_C13_""_OK, L7_C14_"800.00000"_OK, L7_C15_"2021/03/29"_OK, L7_C16_"00100.121050000.00000.00000.00000.00000.00000.00000"_OK, L7_C17_"00100.381230000.00000.00000.00000.00000.00000.00000"_OK, L7_C18_"N"_OK, L7_C19__OK, L7_C20_""_OK, L7_C21_""_OK, L7_C22_""_OK, L7_C23_""_OK, L7_C24_""_OK, L7_C25_""_OK, L7_C26_""_OK, L7_C27_""_OK, L7_C28_""_OK, L7_C29_""_OK, L7_C30_"FRSXME00"_OK, L7_C31_""_OK, L7_C32_""_OK, L7_C33_""_OK, L7_C34_""_OK, L7_C35_""_OK, L7_C36_""_OK, L7_C37_""_OK, L7_C38_""_OK, L7_C39_""_OK, L7_C40_""_OK, L7_C41_""_OK, L7_C42_""_OK, L7_C43_""_OK, L7_C44_""_OK, L7_C45_""_OK, L7_C46_""_OK, L7_C47_""_OK, L7_C48_""_OK, L7_C49_""_OK, L7_C50_""_OK, L7_C51_""_OK, L7_C52_""_OK, L7_C53_""_OK, L7_C54_""_OK, L7_C55_""_OK, L7_C56_""_OK, L7_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L7_C58_""_OK, L7_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L7_C60_""_OK, L7_C61_""_OK, L7_C62_"000013760000000001"_KO, L7_C63_""_OK, L7_C64_""_OK, L7_C65_""_OK, L7_C66_""_OK, L7_C67_""_OK, L7_C68_""_OK, L7_C69_""_OK, L7_C70_""_OK, L7_C71_""_OK, L7_C72_""_OK, L7_C73_""_OK, L7_C74_""_OK, L7_C75_""_OK, L7_C76_""_OK, L7_C77_""_OK, L7_C78_""_OK, L7_C79_""_OK, L7_C80_""_OK, L7_C81_""_OK, L7_C82_""_OK, L7_C83_""_OK, L7_C84_""_OK, L7_C85_""_OK, L7_C86_""_OK, L7_C87_""_OK, L7_C88_""_OK, L7_C89_""_OK, L7_C90_""_OK, L7_C91_""_OK, L7_C92_""_OK, L7_C93_""_OK, L7_C94_""_OK, L7_C95_""_OK, L7_C96_""_OK, L7_C97_""_OK, L7_C98_""_OK, L7_C99_""_OK, L7_C100_""_OK, L7_C101_""_OK, L7_C102_""_OK, L7_C103_""_OK, L7_C104_""_OK, L7_C105_""_OK, L7_C106_""_OK, L7_C107_""_OK, L7_C108_""_OK, L7_C109_""_OK, L7_C110_""_OK, L7_C111_""_OK, L7_C112_""_OK, L7_C113_""_OK, L7_C114_""_OK, L7_C115_""_OK, L7_C116_""_OK, L7_C117_"13759000000007"_KO, L7_C118_""_OK, L7_C119_""_OK, L7_C120_"END"_OK, L8_C1_"1"_KO, L8_C2_"3260"_KO, L8_C3_"CHK_CASHING_CHECK_IN_PROGRESS_20210329_3260_EUR_S"_KO, L8_C4_"04"_OK, L8_C5_""_OK, L8_C6_""_OK, L8_C7_""_OK, L8_C8_"LINE"_OK, L8_C9_"INVOICE"_OK, L8_C10_"000013759000000008"_KO, L8_C11_""_OK, L8_C12_"S"_OK, L8_C13_""_OK, L8_C14_"800.00000"_OK, L8_C15_"2021/03/29"_OK, L8_C16_"00100.381230000.00000.00000.00000.00000.00000.00000"_OK, L8_C17_"00100.261107100.00000.00000.00000.00000.00000.00000"_KO, L8_C18_"N"_OK, L8_C19__OK, L8_C20_""_OK, L8_C21_""_OK, L8_C22_""_OK, L8_C23_""_OK, L8_C24_""_OK, L8_C25_""_OK, L8_C26_""_OK, L8_C27_""_OK, L8_C28_""_OK, L8_C29_""_OK, L8_C30_"FRSXME00"_OK, L8_C31_""_OK, L8_C32_""_OK, L8_C33_""_OK, L8_C34_""_OK, L8_C35_""_OK, L8_C36_""_OK, L8_C37_""_OK, L8_C38_""_OK, L8_C39_""_OK, L8_C40_""_OK, L8_C41_""_OK, L8_C42_""_OK, L8_C43_""_OK, L8_C44_""_OK, L8_C45_""_OK, L8_C46_""_OK, L8_C47_""_OK, L8_C48_""_OK, L8_C49_""_OK, L8_C50_""_OK, L8_C51_""_OK, L8_C52_""_OK, L8_C53_""_OK, L8_C54_""_OK, L8_C55_""_OK, L8_C56_""_OK, L8_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L8_C58_""_OK, L8_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L8_C60_""_OK, L8_C61_""_OK, L8_C62_"000013760000000001"_KO, L8_C63_""_OK, L8_C64_""_OK, L8_C65_""_OK, L8_C66_""_OK, L8_C67_""_OK, L8_C68_""_OK, L8_C69_""_OK, L8_C70_""_OK, L8_C71_""_OK, L8_C72_""_OK, L8_C73_""_OK, L8_C74_""_OK, L8_C75_""_OK, L8_C76_""_OK, L8_C77_""_OK, L8_C78_""_OK, L8_C79_""_OK, L8_C80_""_OK, L8_C81_""_OK, L8_C82_""_OK, L8_C83_""_OK, L8_C84_""_OK, L8_C85_""_OK, L8_C86_""_OK, L8_C87_""_OK, L8_C88_""_OK, L8_C89_""_OK, L8_C90_""_OK, L8_C91_""_OK, L8_C92_""_OK, L8_C93_""_OK, L8_C94_""_OK, L8_C95_""_OK, L8_C96_""_OK, L8_C97_""_OK, L8_C98_""_OK, L8_C99_""_OK, L8_C100_""_OK, L8_C101_""_OK, L8_C102_""_OK, L8_C103_""_OK, L8_C104_""_OK, L8_C105_""_OK, L8_C106_""_OK, L8_C107_""_OK, L8_C108_""_OK, L8_C109_""_OK, L8_C110_""_OK, L8_C111_""_OK, L8_C112_""_OK, L8_C113_""_OK, L8_C114_""_OK, L8_C115_""_OK, L8_C116_""_OK, L8_C117_"13759000000008"_KO, L8_C118_""_OK, L8_C119_""_OK, L8_C120_"END"_OK, L9_C1_"1"_KO, L9_C2_"3260"_KO, L9_C3_"FRAUD_REGUL_LOSS_20210329_3260_EUR_S"_KO, L9_C4_"05"_OK, L9_C5_""_OK, L9_C6_""_OK, L9_C7_""_OK, L9_C8_"LINE"_OK, L9_C9_"INVOICE"_OK, L9_C10_"000013759000000009"_KO, L9_C11_""_OK, L9_C12_"S"_OK, L9_C13_""_OK, L9_C14_"1.00000"_OK, L9_C15_"2021/03/29"_OK, L9_C16_"00100.675410000.01102.00000.00000.00000.00000.00000"_OK, L9_C17_"00100.261101100.00000.00000.00000.00000.00000.00000"_OK, L9_C18_"N"_OK, L9_C19__OK, L9_C20_""_OK, L9_C21_""_OK, L9_C22_""_OK, L9_C23_""_OK, L9_C24_""_OK, L9_C25_""_OK, L9_C26_""_OK, L9_C27_""_OK, L9_C28_""_OK, L9_C29_""_OK, L9_C30_"FRSXME00"_OK, L9_C31_""_OK, L9_C32_""_OK, L9_C33_""_OK, L9_C34_""_OK, L9_C35_""_OK, L9_C36_""_OK, L9_C37_""_OK, L9_C38_""_OK, L9_C39_""_OK, L9_C40_""_OK, L9_C41_""_OK, L9_C42_""_OK, L9_C43_""_OK, L9_C44_""_OK, L9_C45_""_OK, L9_C46_""_OK, L9_C47_""_OK, L9_C48_""_OK, L9_C49_""_OK, L9_C50_""_OK, L9_C51_""_OK, L9_C52_""_OK, L9_C53_""_OK, L9_C54_""_OK, L9_C55_""_OK, L9_C56_""_OK, L9_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L9_C58_""_OK, L9_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L9_C60_""_OK, L9_C61_""_OK, L9_C62_"000013760000000001"_KO, L9_C63_""_OK, L9_C64_""_OK, L9_C65_""_OK, L9_C66_""_OK, L9_C67_""_OK, L9_C68_""_OK, L9_C69_""_OK, L9_C70_""_OK, L9_C71_""_OK, L9_C72_""_OK, L9_C73_""_OK, L9_C74_""_OK, L9_C75_""_OK, L9_C76_""_OK, L9_C77_""_OK, L9_C78_""_OK, L9_C79_""_OK, L9_C80_""_OK, L9_C81_""_OK, L9_C82_""_OK, L9_C83_""_OK, L9_C84_""_OK, L9_C85_""_OK, L9_C86_""_OK, L9_C87_""_OK, L9_C88_""_OK, L9_C89_""_OK, L9_C90_""_OK, L9_C91_""_OK, L9_C92_""_OK, L9_C93_""_OK, L9_C94_""_OK, L9_C95_""_OK, L9_C96_""_OK, L9_C97_""_OK, L9_C98_""_OK, L9_C99_""_OK, L9_C100_""_OK, L9_C101_""_OK, L9_C102_""_OK, L9_C103_""_OK, L9_C104_""_OK, L9_C105_""_OK, L9_C106_""_OK, L9_C107_""_OK, L9_C108_""_OK, L9_C109_""_OK, L9_C110_""_OK, L9_C111_""_OK, L9_C112_""_OK, L9_C113_""_OK, L9_C114_""_OK, L9_C115_""_OK, L9_C116_""_OK, L9_C117_"13759000000009"_KO, L9_C118_""_OK, L9_C119_""_OK, L9_C120_"END"_OK, L10_C1_"1"_KO, L10_C2_"3260"_KO, L10_C3_"SEIZURE_SEIZURE_20210329_3260_EUR_S"_KO, L10_C4_"06"_OK, L10_C5_""_OK, L10_C6_""_OK, L10_C7_""_OK, L10_C8_"LINE"_OK, L10_C9_"INVOICE"_OK, L10_C10_"000013759000000010"_KO, L10_C11_""_OK, L10_C12_"S"_OK, L10_C13_""_OK, L10_C14_"12.00000"_OK, L10_C15_"2021/03/29"_OK, L10_C16_"00100.251110000.00000.00000.00000.00000.00000.00000"_OK, L10_C17_"00100.262102100.00000.00000.00000.00000.00000.00000"_OK, L10_C18_"N"_OK, L10_C19__OK, L10_C20_""_OK, L10_C21_""_OK, L10_C22_""_OK, L10_C23_""_OK, L10_C24_""_OK, L10_C25_""_OK, L10_C26_""_OK, L10_C27_""_OK, L10_C28_""_OK, L10_C29_""_OK, L10_C30_"FRSXME00"_OK, L10_C31_""_OK, L10_C32_""_OK, L10_C33_""_OK, L10_C34_""_OK, L10_C35_""_OK, L10_C36_""_OK, L10_C37_""_OK, L10_C38_""_OK, L10_C39_""_OK, L10_C40_""_OK, L10_C41_""_OK, L10_C42_""_OK, L10_C43_""_OK, L10_C44_""_OK, L10_C45_""_OK, L10_C46_""_OK, L10_C47_""_OK, L10_C48_""_OK, L10_C49_""_OK, L10_C50_""_OK, L10_C51_""_OK, L10_C52_""_OK, L10_C53_""_OK, L10_C54_""_OK, L10_C55_""_OK, L10_C56_""_OK, L10_C57_"ECO_SUBACCOUNT_MANAGE_16598_3097146656_20210329151227"_OK, L10_C58_""_OK, L10_C59_"3260.FR.ISIE.AUTRES.ZXIH.SALES.zip"_KO, L10_C60_""_OK, L10_C61_""_OK, L10_C62_"000013760000000001"_KO, L10_C63_""_OK, L10_C64_""_OK, L10_C65_""_OK, L10_C66_""_OK, L10_C67_""_OK, L10_C68_""_OK, L10_C69_""_OK, L10_C70_""_OK, L10_C71_""_OK, L10_C72_""_OK, L10_C73_""_OK, L10_C74_""_OK, L10_C75_""_OK, L10_C76_""_OK, L10_C77_""_OK, L10_C78_""_OK, L10_C79_""_OK, L10_C80_""_OK, L10_C81_""_OK, L10_C82_""_OK, L10_C83_""_OK, L10_C84_""_OK, L10_C85_""_OK, L10_C86_""_OK, L10_C87_""_OK, L10_C88_""_OK, L10_C89_""_OK, L10_C90_""_OK, L10_C91_""_OK, L10_C92_""_OK, L10_C93_""_OK, L10_C94_""_OK, L10_C95_""_OK, L10_C96_""_OK, L10_C97_""_OK, L10_C98_""_OK, L10_C99_""_OK, L10_C100_""_OK, L10_C101_""_OK, L10_C102_""_OK, L10_C103_""_OK, L10_C104_""_OK, L10_C105_""_OK, L10_C106_""_OK, L10_C107_""_OK, L10_C108_""_OK, L10_C109_""_OK, L10_C110_""_OK, L10_C111_""_OK, L10_C112_""_OK, L10_C113_""_OK, L10_C114_""_OK, L10_C115_""_OK, L10_C116_""_OK, L10_C117_"13759000000010"_KO, L10_C118_""_OK, L10_C119_""_OK, L10_C120_"END"_OK]

Mon pattern est le suivant mais il ne marche pas comme je le souhaite :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
String spattern = "(L(([1-9]?[0-9])|100)_C\\d_\\d.*?L\\2_C\\d{2}_\".*?\"(?:,?\$?))(?!L\\2_)";

Code complet pour test :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
 
String sdonnees = String.join(",",al1);//ancienne 
		String sdonneesL3 = String.join(",",L3);
		println("sdonneesal1: "+sdonnees) // va jusqu'à 10 ici
		println("sdonneesL3: "+sdonneesL3)
		//spattern REGEX qui permet de scinder ligne par ligne et de pouvoir retrouver le fichier original
		//String spattern = "(L(([1-9]?[0-9])|100)_C\\d_\\d.*?L\\2_C\\d{2}_\".*?\"(?:,?\$?))(?!L\\2_)";//original
		String spattern = "(L(([1-9]?[0-9])|100)_C\\d_\\d.*?L\\2_C\\d{2}_\".*?\"(?:,?\$?))(?!L\\2_)";
		Pattern p = Pattern.compile(spattern);
		Matcher match = p.matcher(sdonnees);
		Boolean found = false;
 
		/*int count1=0;
		 System.out.println("4 ----- Ecarts constaté = ")
		 while(match.find()){
		 //println("match.start() : "+match.start())
		 //System.out.println("Match no "+count1);
		 System.out.println("4 ----- "+sdonnees.substring(match.start(),match.end()));
		 //transformees.add(sdonnees.substring(match.start(),match.end()));
		 count1++;
		 }*/
 
		//println("------------------------------------------------------------------ DEB DERNIER TRAITEMENT (écriture dans le fichier de sortie) ------------------------------------------------------------------");
		int n
		//List al1 = new ArrayList()
		try{
			FileWriter writer = new FileWriter(path+filec)
			writer.append(result)
			writer.append('\n')
			writer.append("2 ----- NB ligne 1er fichier: ("+filea+") "+numLigneA)
			writer.append('\n')
			writer.append("3 ----- NB ligne 2eme fichier: ("+fileb+") "+numLigneB)
			writer.append('\n')
			writer.append("4 ----- Ecarts constatés : ")
			writer.append('\n')
			System.out.println("4 ----- Ecarts constaté : ")
			//for(m = 0 ; m < al1.size(); m++){
			int count=0;
			while(match.find()){
				//System.out.println("Match no "+count);
				writer.append(sdonnees.substring(match.start(),match.end()))
				//writer.append(""+al1.get(m))
				/*if (al1.contains("L1")){
				 println("L1")
				 }*/
				println(sdonnees.substring(match.start(),match.end()))
				writer.append('\n')
				//transformees.add(sdonnees.substring(match.start(),match.end()));
				count++;
				found = true;
			}
			if(!found){
				writer.append("Aucune correspondance trouvée.")
				writer.append('\n')
				System.out.println("Aucune correspondance trouvée.")
			}
			writer.flush()
			writer.close()
			//println("------------------------------------------------------------------ FIN DERNIER TRAITEMENT ------------------------------------------------------------------");
 
		}catch(IOException e){
			e.printStackTrace()
		}

Help me ! trop duuuur.

C'est sur, c'est un truc facile a faire pour un Expert Regex mais j'y arrive pas de toute la journée.

Regex : prendre en compte les "_OK" ou "_KO" en fin de chaine

Java

Mode arborescent

Discussions similaires

Partager

Partager