How do I keep the extra whitespace when using substring when looping through an array?

I have a sample file above that is downloaded and parsed in xano. I will get “RECORDS” and save it as “Row1”, the client data as “Row2”, and “END” as “Row3”.
Now I'll loop through Row2 per client. I did this by slicing the client data as “Row2” so I can loop through each client data. The client data is separated by a new line. The whitespace between the details are fixed.

When looping through each client, I'll be getting each info: name, date, amount, status.
I have tried using substring to get each info however I have a problem in the substring since xano removes the fixed whitespace in between.
John Doe 01012023 500.00 000000000000000 PAID
becomes:
John Doe 01012023 500.00 000000000000000 PAID
whenever I use substring.

I tried using lambda but it keeps giving me this error:
$auth must be an object

$var must be an object

$env must be an object

$input must be an object

$global must be an object

code must be a string

Is there any way to avoid getting the extra whitespace removed?