Community

you both rock.

Ben that was much easier than what I actually did. I did use textpad but used my spacebar till I got the required number of spaces. I did edit the formula that bob gave me in textpad, but mostly because unlike wordpad or notepad it has that very useful counter for the flat files ...

SUCCESS (I think at least it looks good to me so far)

I kept adding spaces in the rplace field until my positions lined up again :) (I think I ended up adding like 5 or 6)


S= ^(.{178})(.{427})(.{225})(.{147})
R= \1 with 427 spaces after and \3 with 147 spaces
Thank you so much!!!

Hi Bob,

Thanks for the reply. I tried it and it didn't work. I changed the numbers to correspond with my full flat file length (I think that is what your example showed) then in the replace portion I put in empty spaces corresponding with those sections but I got an error message that it could not ...

Hi guys, I have searched for a few hours on here, and either I am not sure what to call what I am trying to do or it is not here. I apologize in advance if it exists somewhere. I should say that my file is a fixed width file, which is why I am trying to work with position numbers.

I have 21 text ...