Split 으로 문자열을 자르고 Substring 으로 자른 문자열의 일부를 추출하고싶습니다

[leejiyeon051999 (지연 이)]

Split 으로 문자열을 자르고 Substring 으로 자른 문자열의 일부를 추출하고싶습니다. 어떻게 합쳐야할까요?

[Yoichi]

Hi,

Can you share specific input data and expected output?

Regards,

[leejiyeon051999 (지연 이)]

BillingRTF.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries)(8)
BillingRTF.SubString(0,12)

[Rahul_Unnikrishnan]

Hello @leejiyeon051999

It would be better if you can share the input data and the expected output.
based on that we can provide a solution.

Thanks

[Sudharsan_Ka]

Hello @leejiyeon051999

As asked can you provide us the input text you are using and you expected output

If the input is non-sharable share the sample of by changing the sensitive things in the input

Regards
Sudharsan

[leejiyeon051999 (지연 이)]

268094663036 PAYMENT 000
466092468148 PAYMENT 000
668079302272 PAYMENT 000

→
268094663036
466092468148
668079302272

[Gokul001 (Gokul Balaji)]

Hi @leejiyeon051999

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"^\d+").Tostring

Regards
Gokul

[Sudharsan_Ka]

Okay So you can try out this

Split(“268094663036 PAYMENT 000”," ")(0)

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Try with Split expression

Split(YourString," ")(0)

Try with Substring

YourString.Substring(0,12)

Regards
Gokul

[Sudharsan_Ka]

You can Also try this pattern

.*(?=\s[A-Z]+)

regex101: build, test, and debug regex

System.Text.RegularExpressions.Regex.Match(“268094663036 PAYMENT 000”,“.*(?=\s[A-Z]+)”)Tostring

Regards
Sudharsan

[Yoichi]

Hi,

How about the following?

@leejiyeon051999

BillingRTF.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries)(8)
BillingRTF.SubString(0,12)

strData = BillingRTF.Split(vbcrlf.ToCharArray,StringSplitOptions.RemoveEmptyEntries)(8)

then

strData.SubString(0,12)

Regards,