Hi Not to worry, I sorted it! ... View more

Hi Tom There seems to be a space or 2 after the last character. How can I remove it or ensure that the 173 length ends at the last character. ... View more

Tx Tom my export is sorted, now I just need to test on the system. Tx so much for your help! ... View more

TEST1030001010101010 00000162             00000071707MRSJJUMPING       00000001111111111470010205-03-13 TEST1030020202020202 00000162             00000120825MRRFUFUFUFUF    00000000222222222055555105-03-13 TEST1030030303030303 00000162             00000053657MISSLDUDUDUDUD              0000000121212121622105205-03-13 This is an example of the distortion. ... View more

Tx Tom it's seems to be working but still have a few questions. I  hnow have 4 columns and the 3rd column is surnames. Because the length of these vary it distorts the last column by pushing the next column out. How can I maintain this. When I run thye first part of code the min and max characters =174 When I run the second part of code the count of the line varies from 80 -88. Not sure what I am doing wrong. ... View more

How do I maintain the spaces when exporting to text? ... View more

Michael the last line explaining the @ is  a bit confusing. Is it the starting point of the first character in that column or the start of the ‘blank between the columns. Is this where you want to position them? ... View more

Hi Tom/Michael I have the completed date set comprising of three columns, the total characters when exported to text comprises of 81 characters per row. The export will be uploaded into aother system that requires the row/field to have a total of 173 characters including spaces. I need to fill the balance of characters in my dataset with spaces when exported in order for the job to run. The exported 81 characters are fixed so that no will not change. A simple excercise of just including  5 blanks columns after the first and second column increased the characters to 169 and some to 177. ... View more

Hi Tom I already have a dataset that I am using, I only need to include the spaces and export. Can you help? JJ ... View more

Tx Amelie But I need to identify the specific day like a Friday is the 6 day so it should read: 1= Sunday 2= Monday 3=Tuesday, etc. Any chance you could help with this? Jbug ... View more