In a file, if you want to find "," "globally/entire scope" and replace it with the regular expresion "\n", PSPAD does it only for the first row. The rest is not replaced. My PSPAD version is 4.5.3 (2298)
Some example text: 1,302466,/leased_product,1,1226110643,1226110644,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,54 607,/product,23,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1, 0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,301122,/leased_product,1,1226110644,1226110644,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,81 955,/product,11,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1, 0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,302146,/leased_product,1,1226110645,1226110645,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,97 165,/product,7,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1,0 ,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,301634,/leased_product,1,1226110645,1226110645,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,82 275,/product,7,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1,0 ,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,302658,/leased_product,1,1226110645,1226110646,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,62 566,/product,10,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1, 0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,301378,/leased_product,1,1226110646,1226110646,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,58 773,/product,13,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1, 0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,302402,/leased_product,1,1226110646,1226110646,L,L,1,300802,/account,0,1226110 641,0,0,0,0,1226109600,1,241944,/deal,6,(null),(null),7,3,0,1,81555,/plan,8,1,53 455,/product,9,0,0,0,0,1226109600,1,1,299394,/pack/telco/gsm/,0,0,0,(null),0,1,0 ,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,331240,/leased_product,1,1226130067,1226130068,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 98221,/product,16,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0, 1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,329752,/leased_product,1,1226130068,1226130068,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 97357,/product,4,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0,1 ,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,330776,/leased_product,1,1226130068,1226130069,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 85699,/product,11,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0, 1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,330264,/leased_product,1,1226130069,1226130069,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 81939,/product,8,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0,1 ,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,331288,/leased_product,1,1226130069,1226130069,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 62566,/product,10,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0, 1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,330008,/leased_product,1,1226130070,1226130070,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 58773,/product,13,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0, 1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,331032,/leased_product,1,1226130070,1226130070,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,167443,/deal,2,(null),(null),10,3,0,1,309421,/plan,4,1, 53455,/product,9,0,0,0,0,1226109600,1,1,328168,/pack/telco/gsm/,0,0,0,(null),0,1 ,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,329880,/leased_product,1,1226130072,1226130072,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,299839,/deal,0,(null),(null),10,3,0,1,309421,/plan,4,1, 302399,/product,0,0,0,0,0,1226109600,1,1,327832,/pack/telco/gsm/sms,0,0,0,(null) ,0,1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 1,330392,/leased_product,1,1226130073,1226130073,L,L,1,329576,/account,0,1226130 064,0,0,0,0,1226109600,1,303324,/deal,0,(null),(null),10,3,0,1,309421,/plan,4,1, 303102,/product,1,0,0,0,0,1226109600,1,1,328344,/pack/telco/gsm/mms,0,0,0,(null) ,0,1,0,0,0,1226109600,1,0,1226109600,1,1,1,2,2,2,0,0,(null),0 -- <http://forum.pspad.com/read.php?4,48359,48359> PSPad freeware editor http://www.pspad.com
