Search Results

Hi Scott,

Input file

01,10,000020,*,*,******,999999,00,,WERK 28 - BUS
01,10,000030,*,*,******,999999,00,,WERK 30 - UNIMOG
01,10,000060,*,*,******,999999,20,,LASTWAGEN...

Hi Scott,

I'm afraid your solution only works if there there are no spaces within the text ......... each space found within the text is also padded out to 18 spaces

Dave

Hi Scott,
You mention 'change the 10th column' , I need to change the 10th field in the .csv file (the actual start column of field 10 will vary) .... does your solution still apply ?
Dave

Hi,
Can anyone help with a effective solution ?

I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the...

Hi,
If input record is

123456789EXAMPLE DESCRIPTION 1234

I want
12EXAMPLE DESCRIPTION (with 3 spaces betwee EXAMPLE & DESCRIPTION & 4 spaces at end)

but I get
12EXAMPLE...

Hi,
I am cutting data from a fixed length test file and then writing out a new record using the echo command, the problem I have is how to stop multiple spaces from being written to the output file...