Blank spaces

[amitendra_amit]

Hi,

I have fixed length files where data is something like

Code: Select all

00001000390 | 002 |
test        |     |
            | sut |

I want to capture records where values are blank as errors. I have tried trim function but its not working.

Any help in this matter is highly appreciated.

[DSguru2B]

Use trim and length function in conjunction and check for zero length.

[chulett]

Or compare against a string of all spaces.

[amitendra_amit]

Thanks a lot, it worked like a charm.