Removing blank spaces when space length is variable

[Chris_Bolin]

Hi

Again, remember I am an over-thinker. Tried a regex (\S) - simple - to remove all blank spaces for each line in this text (doesn’t work when put into an actual regex) I need to remove the blank spaces in order to split the columns by “,”. Also, as you can see on the end of some lines, there appears a “,” which represents no information for the associated column header. Ideas?

“Argentina ,DS,ARL03201 ,15943.6433,175354.41,4361,2021-01-01 00:00:00,”
“Argentina ,DS,MX202101AR ,5846.916,151978.69,11489.5,2021-01-14 00:00:00,2,163666.55,0.00433448,0.01873712”
“Canada ,DS,CAA15211 ,26280.3234,289066.94,3416.36,2021-01-22 00:00:00,”
“Canada ,DS,CAL30202 ,22416.2886,246546.95,3404.66,2021-01-08 00:00:00,2,267806.945,0.00968652,0.03065948”
“China ,DS,HCL20202 ,32.572256,358.3,75,2021-01-13 00:00:00,”
“China ,DS,HCL21201 ,2.187,24.06,65,2021-01-12 00:00:00,”
“China ,OTHER,CIA0621SJ1 ,102.485,1127.34,31.8,2021-01-07 00:00:00,3,503.23333333,0.0000273,0.00008642”
“Colombia ,DS,COA05211 ,9502.3315,104509.73,3883,2021-01-13 00:00:00,”
“Colombia ,DS,COA15212 ,495.981,5456.41,2487,2021-01-26 00:00:00,”
“Colombia ,DS,COA18211 ,2098.0164,23075.11,5339.3,2021-01-28 00:00:00,3,44347.08333333,0.00240615,0.00761552”
“Czech Republic ,DS,CZ202101 ,-162.085,-1783.04,-265.44,2021-01-13 00:00:00,”
“Czech Republic ,DS,CZA07211 ,16366.152,43643.17,3887,2021-01-13 00:00:00,”
“Czech Republic ,DS,CZA11211 ,7483.6077,20397.96,3617.9,2021-01-19 00:00:00,”
“Czech Republic ,DS,CZA11212 ,653.6,1742.94,733.6,2021-01-15 00:00:00,”

[Chris_Bolin]

Disregard…solution found