Split a string by bytes value

Help Studio
, ,
1

Hi Guys,
Is it possible to split strings by its byte value?
The problem is to split a string by its byte value and store the data into respective columns in data table.

2

Hi @Chendoran_M

Can you be more specific on what is needed . Will substring and combination of indexOf not sufficient for you to achieve this?

cheers

3

String value= “21日本語能力ABC 203403” → “21” “日本語能力” “20” “34” “03”
After splitting the string the data must be stored in a data table;
column-1 column-2 column-3 column-4 column-5
“21” “日本語能力” “20” “34” “03”

*Here each Japanese characters are 2 bytes and English characters are 1 byte.

4

Hi @Chendoran_M

Use Substring as below …change the values accordingly to get other numbers as well

image
image1737×516 27.1 KB

I saw a space after the Chinese word so got the index of that space and subtracted with 3 because there are 3 characters before the Chinese string . SO to get length I used it that way

cheers

5

Hi,

Where does ABC goes? Do you need to split as 2bytes 10bytrs, 2bytes,2bytes,2butes?

Regards,

6

ABC goes along with Japanese character. 2bytes,14bytes,2bytes,2bytes,2bytes.

7

@Chendoran_M

Did you try substring activities?

Are you facing any issue with that?

Cheers

8

Hi,

Hope the following sample helps you.

image
image831×1347 39.7 KB 

arrBytes = System.Text.Encoding.GetEncoding("shift_jis").GetBytes(yourString)

s = System.Text.Encoding.GetEncoding("shift_jis").GetString((arrBytes.Take(currentItem).ToArray))

Sample20221206-1a.zip (3.0 KB)

Regards,

9

The data is in Excel and I have used “Read Range Workbook” activity and stored the data in a variable to read the data and using “For Each Row in Data Table” to loop the split activity as per your solution. But I’ve got the below as my output!
Capture

10

Hi,

Can you share your input and expected output?

Regards,

11

shiftData.xlsx (10.0 KB)

12

Hi,

Can you try this?

Main.zip (2.6 KB)

However it doesn’t seem very good logic to split by byte value.

Regards,

13

FYI, it might be better to use regex as the following

m = System.Text.RegularExpressions.Regex.Match(CurrentRow(0).ToString,"(\d{2})(\D+)(\d{2})(\d{2})(\d{2})?(\d{,2})?")

Sequence.zip (2.1 KB)

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.