Sub config_change_input_substitute()
'----------------------
row_start = 3
row_end = 130
col_inputstart = 3
col_output = 10
'----------------------
Dim arr2_conf As Variant
Dim arr2_conf_sub As Variant
For i = row_start To row_end
str2 = Cells(i, 2).Value
arr2_conf = Split(str2, " ")
len_arr2_conf = UBound(arr2_conf)
arr2_conf_sub = Split(str2, " ")
len_arr2_conf_sub = UBound(arr2_conf_sub)
countperline = 0
For j = 0 To len_arr2_conf
If arr2_conf_sub(j) Like "*★*" Then
arr2_conf_sub(j) = Cells(i, col_inputstart + countperline).Value
countperline = countperline + 1
End If
If maxcount < countperline Then
maxcount = countperline
End If
Next j
For k = 0 To len_arr2_conf_sub
str_sub = str_sub & " " & arr2_conf_sub(k) & " "
Next k
Cells(i, col_output).Value = str_sub
str_sub = ""
Next i
End Sub
Sub config_change_input_format()
'----------------------
row_start = 3
row_end = 130
col_inputstart = 3
col_output = 10
'----------------------
Dim arr_conf As Variant
Dim str1 As String
Count = 1
For i = row_start To row_end
str1 = Cells(i, 1).Value
arr_conf = Split(str1, " ")
len_arr_conf = UBound(arr_conf)
countperline = 0
For j = 0 To len_arr_conf
If arr_conf(j) Like "*★*" Then
arr_conf(j) = "★" & Count & "★"
Cells(i, col_inputstart + countperline).Interior.ColorIndex = 4
countperline = countperline + 1
Count = Count + 1
End If
If maxcount < countperline Then
maxcount = countperline
End If
Next j
For k = 0 To len_arr_conf
str2 = str2 & " " & arr_conf(k) & " "
Next k
Cells(i, 2).Value = str2
str2 = ""
Next i
End Sub