Code trimming numbers in datatable columns

[mgartner]

Hi there, we have our code configured to grab an email body, perform string operations to separate into columns, and insert into a datatable. However, we are currently experiencing trouble with the code trimming numbers. I have attached examples below:

This first screenshot is from the email body:

The second screenshot is from the datatable:

In this case, if the quantity has a single digit number, it will erase all instances of that number in the first datatable column.

Any input as to a) what can be causing this and b) how we can fix this issue would be greatly appreciated.

[mgartner]

I found the solution to this issue. I needed to reconfigure the input statement from

{Regex.Replace(Line.Replace(Quantity,“”),“\t”,“”).Trim,Quantity}

to

{Regex.Replace(Regex.Split(Line,“\t”)(0),“\t”,“”).Trim,Quantity}