لخّصلي

Select the first digit to put in the DiscountRate Column.From the new first column (that contains the DiscountRate and DiscountDays information), take all numerical digits before the slash and put them in the DiscountRate column and, reading from right to left, take all digits until it comes to the forward slash and put them in the DiscountDays column.Select all data before the forward slash to put in the DiscountRate column.Split the data into columns based on the space.????

Select the first digit to put in the DiscountRate Column. Select the third and fourth digits
to put in the DiscountDays column, and then select the seventh and eighth digits for the
BalanceDueDays column.
●● Select all data before the forward slash to put in the DiscountRate column. Select the
data between the forward slash and first space and put it in the DiscountDays column.
Select all the data after the N to put into the BalanceDueDays column.
●● Split the data into columns based on the space. From the new first column (that contains
the DiscountRate and DiscountDays information), take all numerical digits before the
slash and put them in the DiscountRate column and, reading from right to left, take all
digits until it comes to the forward slash and put them in the DiscountDays column. With
the new second column from the original split (i.e., the “N30” information), remove all
alpha characters and place any numerical characters in the BalanceDueDays column.