文字列の分割について

[CaptNob (Nobuhiro Kakisako)]

PDFから読み取ったデータで、不特定のスペースでつながった数字があります。
これを、それぞれの数字に分けたいのですが、不特定数のスペースでの区切りかたがわかりません。

データ見本 ( _ は半角スペース)

_____123_______12,345_____123.45

これを、Split などで 123と12,345と123.45の３つのデータに分けたく、お知恵をいただけないでしょうか？

[Gokul001 (Gokul Balaji)]

HI @CaptNob

Welcome to UiPath community

Can you confirm do you need to split three string ?

Split("123 12,345 123.45"," ").ToArray

 Split("123 12,345 123.45"," ")(0)

Regards
Gokul

[Sudharsan_Ka]

Hi @CaptNob

Welcome To the Community!!

Check out these expressions

Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(1)

Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(2)

Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(3)

If you needed in the array of string use this in your for each and loop through the items

Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")

Note: You will receive the first item as empty because your string is starting with “_”

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

You can also try with Regex expression @CaptNob

Value 1 = System.Text.RegularExpressions.Regex.Matches("_____123_______12,345_____123.45","[\d.,]+")(0)

Value 2 = System.Text.RegularExpressions.Regex.Matches("_____123_______12,345_____123.45","[\d.,]+")(1)

Value 3 = System.Text.RegularExpressions.Regex.Matches("_____123_______12,345_____123.45","[\d.,]+")(2)

Regards
Gokul

[Yoichi]

こんにちは

以下のいずれかいかがでしょうか？

StringSplitOptions.RemoveEmptyEntriesを使う方法

yourString.Split(" "c,StringSplitOptions.RemoveEmptyEntries)

Regex.Splitを使う方法

System.Text.RegularExpressions.Regex.Split(yourString.Trim," +")

Sample20220924-1.zip (3.6 KB)

[CaptNob (Nobuhiro Kakisako)]

@Yoichi

Regex.Split

ありがとうございました。
SPLITでの正規表現もRemoveEmptyEntriesオプションもどちらもうまくいきました。