Ek ke neeche ek likhi hui list ko ek hi line me, comma ke saath
Sab kuch aapke browser mein hota hai. Koi file upload nahi hoti.Excel ya Sheets se column copy kiya aur form ek hi line maang raha hai comma ke saath? List yahan paste kijiye aur seedha ek line milegi. Khaali lines hata di jaati hain aur ginti bhi dikh jaati hai, taki pata rahe kitne item bache. Duplicate hatana ho ya har item par quote lagana ho to woh bhi ek switch hai.
Ek ke neeche ek likhi list baayen box me paste kijiye.
Separator chuniye - comma, semicolon, pipe, space, tab, ya apna likha hua.
Quote aur bracket chahiye to laga lijiye, phir taiyaar line copy kar lijiye.
Line ki list ko ek separated line me jodna text editor me do minute ka kaam hai aur yahan paanch second ka, lekin asli farak samay ka nahi hai. Farak un teen galtiyon ka hai jo haath se karne par reh jaati hain: sire par latka hua separator, woh khaali row jo spreadsheet se copy karte waqt hamesha saath aati hai, aur woh entry jo do baar aa gayi kyunki list do jagah se paste hui thi.
Yeh page teeno sudhaar deta hai aur aapko bata bhi deta hai. Natije ke neeche ek line likhi rehti hai ki kitne item gaye, kitne aaye aur kya kya hataya gaya: "40 me se 37 item, 2 khaali line hatai, 1 duplicate hataya." Kuch bhi chupke se nahi hataya jaata, kyunki bina kaaran bataye chhoti hokar laut i list us list se buri hai jo saaf ki hi na gayi ho.
Separator chun lijiye: comma, comma aur space, semicolon, pipe, space, tab, ya jo aap khud likhein. Phir chuniye ki har item par quote lage ya nahi - single, double ya backtick - aur poori line round, square ya curly bracket me lipte ya nahi. Yeh do milkar order number ke ek column ko ('ORD-1041','ORD-1042','ORD-1043') bana dete hain, jo SQL ke IN clause me ek paste hai, ya JavaScript array, ya shell ki argument list.
Yahi page ulta bhi chalta hai. Direction badal dijiye aur comma separated line ek line par ek item ban jaati hai, jo tab chahiye hota hai jab koi aapko lambi line bhej de aur aapko wapas column chahiye. Todte waqt line ke ant par bhi toda jaata hai, kyunki email me se paste ki gayi list aksar dono ka mila jula roop hoti hai.
Sort tab hai jab kram se farak na padta ho par aankhon ko padta ho: alphabet me upar ya neeche, ya number ke hisaab se, jisme 2 pehle aata hai aur 10 baad me, jabki alphabet wala sort 10 ko pehle rakh deta hai. Jo number nahi hai woh saare numbers ke baad aata hai, shuru me nahi. Sab kuch aapke browser me chalta hai, likhte likhte. Kuch kahin nahi jaata, aur yahan yeh aur bhi zaroori hai, kyunki log aise page par customer email, order number aur account ID paste karte hain.
List yahan paste kar dijiye. Comma separated line turant ban jaati hai, aur aap chun sakte hain ki comma chahiye, semicolon, pipe, space ya tab. Excel ka formula sochne ki zaroorat hi nahi padti, khaali lines apne aap hat jaati hain, sire par separator nahi latakta, aur ginti neeche likhi dikh jaati hai.
Baayen box me list paste kijiye aur dayen taraf judi hui line turant aa jayegi. Separator me comma, comma aur space, semicolon, pipe, space ya tab chun lijiye. Sire par koi separator nahi chhoda jaata, aur copy karte waqt jo khaali line saath aa jaati hai woh hata kar gin li jaati hai.
Quote ko single kar dijiye aur wrapper me round bracket chun lijiye. Phir har item apne quote me aata hai aur poori line lipat jaati hai, yaani ('A1','A2','A3') ek hi copy me. Duplicate hatana bhi on kar dijiye, kyunki IN clause me dohri value nuksaan nahi karti par aksar batati hai ki list do baar paste hui thi.
Khaali lines default me hata di jaati hain, aur duplicate tab hatte hain jab aap kahein. Dono natije ke neeche likhi line me gine jaate hain, jo batati hai kitne item gaye aur kitne aaye. Har row jaisi ki taisi chahiye, khaali wali samet, to "khaali lines hatao" band kar dijiye.
Haan. Direction badal dijiye aur har value apni alag line par chali jaati hai, jo spreadsheet ke column ya checklist ke liye chahiye hoti hai. Todna chune hue separator par bhi hota hai aur line ke ant par bhi, isliye email se paste ki gayi aadhi idhar aadhi udhar wali list bhi theek se khulti hai.
Numeric sort chuniye aur 2, 10 se pehle aayega - alphabet wala sort yeh galat karta hai kyunki woh ek ek akshar mila kar dekhta hai. Jo number nahi hai use saare numbers ke baad, apne alphabet ke kram me rakha jaata hai, kisi fail hui tulna ki wajah se aage nahi dhakela jaata.
Nahi. Poora kaam aapke browser me chalta hai, likhte likhte, aur kuch bhi upload nahi hota. Yahan yeh baaki pages se bhi zyada maayne rakhta hai, kyunki aise tool me log customer email, order number, invoice reference aur account ID paste karte hain.
Jawab nahi mila? List Ko Comma Me Badle ke baare mein poochein, jise pata hoga woh jawab dega. Account banane ki zaroorat nahi.
On the related tools: URL Extractor – Find every link in pasted text or HTML and get them as a clean, deduplicated list · Unicode to Kruti Dev Converter – Turn Unicode Hindi into Kruti Dev 010 keys for Word, PageMaker and typing practice · Dummy Text Generator – Fill a layout with neutral dummy text of the length you need.