Hello, @sean, @alan-kilborn, @steven-haymes, and All,
I’m afraid that, in order to use the column mode, in a reliable way, we should align the comma symbols, padding preceding positions with spaces chars !
So, this time, the regex solution seems to be more secure ;-))
For instance, with that sample text, below :
#,6100795442608787,1
#,205300099864,1
#,65433455333,5
#,20530002200815618844,1
#,3360,20
#,718103267854,2
#,67764334775,8
Here is a regex S/R which deletes any non-null range of digits, after the 11th, till the second comma of each line :
SEARCH ^#,\d{11}\K\d+(?=,)
REPLACE Leave EMPTY
Tick the Wrap around
Select the Regular expression search mode
Click, exclusively, on the Replace All button
And, we would obtain the expected result :
#,61007954426,1
#,20530009986,1
#,65433455333,5
#,20530002200,1
#,3360,20
#,71810326785,2
#,67764334775,8
Best Regards,
guy038