Hi Team,
So I was working on the string manipulation part, where I wanted to split the string(basically the input text file which has multiple instances of some character)
Eg:- INput text file contains to following:-
:20:AIM0013063240001
:25:088000001011
:28C:00170/00001
:60F:C140903CNY0,00
:61:1409030903CY12,40NTRFNONREF//NONREF
LP4140902YLP70000006
:86:/OR/LP4140903YLP70000006
/ORDP/付款方名称付款方名称付款方
名称付款方名称付款方名称付款方名
/REMI/付款明明细付款明明细付款明
明细付款明明细付款明明细付款明明
/VA/0000000001
:61:1409030903DY4,50NTRFCUSTREF0001//3764438307060001
140903YLP17026351
:86:/OR/140903YLP17026351
/AC/12345678901234567890
/BENM/收款方名称收款方名称收款方
名称收款方名称收款方名称收款方名
/REMI/付款明明细付款明明细付款明
明细付款明明细付款明明细付款明明
:61:1409030903DY5,50NCHGCUSTREF0001//3764438307060001
140903YLP17026351
:86:/OR/140903YLP17026351
/AC/12345678901234567890
PAYMENT CHARGES
/BENM/收款方名称收款方名称收款方
名称收款方名称收款方名称收款方名
:61:1409030903DY2,40NCHGCUSTREF0002//2625153196060001
140903PO130024653
:86:/OR/140903PO130024653
AUTOPAY OUT CHARGES
:62F:C140903CNY0,00
:64:C140903CNY0,00
:86:/OSDR/HSBCCNSH
Now I want to split the string with respect to “:61:”, such that I get the charArray such that:-
StringArray(0) =
:20:AIM0013063240001
:25:088000001011
:28C:00170/00001
:60F:C140903CNY0,00
StringArray(1)=
:61:1409030903CY12,40NTRFNONREF//NONREF
LP4140902YLP70000006
:86:/OR/LP4140903YLP70000006
/ORDP/付款方名称付款方名称付款方
名称付款方名称付款方名称付款方名
/REMI/付款明明细付款明明细付款明
明细付款明明细付款明明细付款明明
/VA/0000000001
StringArray(2)=
:61:1409030903DY4,50NTRFCUSTREF0001//3764438307060001
140903YLP17026351
:86:/OR/140903YLP17026351
/AC/12345678901234567890
/BENM/收款方名称收款方名称收款方
名称收款方名称收款方名称收款方名
/REMI/付款明明细付款明明细付款明
明细付款明明细付款明明细付款明明
StringArray(3)=
:61:1409030903DY5,50NCHGCUSTREF0001//3764438307060001
140903YLP17026351
:86:/OR/140903YLP17026351
/AC/12345678901234567890
PAYMENT CHARGES
/BENM/收款方名称收款方名称收款方
名称收款方名称收款方名称收款方名
StringArray(4)=
:61:1409030903DY2,40NCHGCUSTREF0002//2625153196060001
140903PO130024653
:86:/OR/140903PO130024653
AUTOPAY OUT CHARGES
:62F:C140903CNY0,00
:64:C140903CNY0,00
:86:/OSDR/HSBCCNSH
I hope you get my point.
WHAT I HAVE tried=
-
Read Text File activity (file path given) → String strInputText
-
String Array StraingArray = strInputText.Trim.Split(":61:".toCharArray)
-
For each item in (StringArray)
{
item (message box)
}
I expected it to work but it is showing BAD result.
Kindly look into it.
Thanks and Regards,
@hacky