Sperate Columns From Single String
Jack Patil last edited by Jack Patil
Cust_Id,Cust_Name,Cust_Address,Cust_Salary 1,Name1,Address,12,Road,40,10000 2,Name2,Address,3,20,20000
Cust_Id|Cust_Name|Cust_Address|Cust_Salary 1|Name1|Address,12,Road,40|10000 2|Name2|Address,3,20|20000
I want to Separate Data Column Wise and Instead of Comma I want Pipe Delimiter, How to do that in Notepad++
dinkumoil last edited by dinkumoil
Provided that the
Cust_Namecolumn contains no (comma-separated) multi-part content:
Jack Patil last edited by
@dinkumoil Thanx a Lot it’s Working Perfectly.
Alan Kilborn last edited by
@dinkumoil 's solution works great.
Just a note to say that
|is not a “special character” when used in the Replace with part of a regular expression. Thus it does not need to be “escaped” with
In other words, this would have worked just as well for the Replace with:
guy038 last edited by
guy038 last edited by guy038
Just thought of this text, in a literally way.
Not only do we have to solve problems (if we choose to reply), we also have to “play detective” to know what a poster is and isn’t saying with their descriptions, even when they put their data in a nice code block.
dinkumoil last edited by
Hmm, you are right. Don’t know how, but in some way I had in mind that it is required. Anyway, good to know that it is not.
It really IS hard to keep all this regular expression syntax straight. :-(
I wasn’t pointing it out to pick apart your regular expression, though.
People learn new things from what they see here, even if it isn’t their question.
\|works…but if people can know they can write replacement expressions in Notepad++ involving
|without a bunch of leaning toothpicks, then so much the better.