formatting the text file

[Former Member]

hi folks,

I have an text file with records, each record has several field values and there is blank space between them, I need to remove the blank spaces, is there a way that i can do with all records at one stretch? Instead doing it for each record.

I know it is not related to SAP but I need some help in this regard as there are a lot of records and formatting each record manually is extremely painful. This is a corrected file manually on a spreadsheet and converted into the text file from thereon.

Any help is really appreicated.

Thanks,

SK

[Former Member]

hi folks,

I have an text file with records, each record has several field values and there is blank space between them, I need to remove the blank spaces, is there a way that i can do with all records at one stretch? Instead doing it for each record.

I know it is not related to SAP but I need some help in this regard as there are a lot of records and formatting each record manually is extremely painful. This is a corrected file manually on a spreadsheet and converted into the text file from thereon.

Any help is really appreicated.

Thanks,

SK

[Former Member]

Hi,

What you are trying to do with the text file after removing the spaces?

Are you going to use in SAp Upload? or just to remove the spaces in text fiel?

If you are using it for other purposes, you should not remove the spaces, because for that particular field no data will be entered.

(generally we remove the other chars's like " by Find and Replace method)

Generally we format the text files from the Excel to utilise it somewhere?

And we won't remove the spaces for surther uses.

Regards,

Anji