>>Hi All, I need to parse a text file which contains fixed length lines of six columns like the one shown below, however, one or more of the columns could be blank - the only constant being the first which always there and is of the format with BX00000000 - I've cobbled a program together which uses substrings, but think a Regex would be a cleaner way ?
>>
>>

>>
>>  
>>BX00027025  AD               ME                CW                   NO'S ALLOCATED TO KEW TRUNKS   29/03/1994 
>>
>>

>
>Pete,
>
>If the lines are fixed length (and hence the columns), then I would keep the substr. I do not see any need for a Regex in this case

I agree. IIRC RegEx is somewhat of an expensive operation when compared to regular string manipulation.