Hello Kishor V
Basically, this kind of operation can be easily achieved with a search/replacement, in extended or regular expression mode
For instance, starting with the list below :
Family Name : Adams First Name : Paul Age : 17 Secondary School : St Andrews CollegeYou would obtain, after the S/R :
Family Name : Adams First Name : Paul Age : 17 Secondary School : St Andrews CollegeDo you expect this behaviour ?
If so, after opening the Replace dialog ( CTRL +H ) :
A) If you check the Regular expression radio button :
Find what : :\R Replace with : :Notes :
In the Replace zone, the colon is followed with a single SPACE
The \R syntax, means ( among other things ! ) any End of Line character ( \r\n with a Windows format, \n with an Unix/OSX format or \r with an old MAC format )
B) If you check the Extended (\n, \r, \t, \0, \x…) radio button :
Find what : :\r\n ( WINDOWS file format ) Replace with : :Notes :
In the Replace zone, the colon is followed with a single SPACE
If you currently use other file format than Windows, just write the right End of Line character, in the Find what zone
Best Regards,
guy038