Remove commas at start of line

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
alexgrainger
Posts: 5
Joined: Wed Dec 15, 2004 10:13 pm

Remove commas at start of line

Post by alexgrainger »

Hello,

How do I remove commas at the start of a line (and if there isn't one ignore it)?

Sample data is:

,56583,5,01027F32D7,16:42:36,24/06/20
,56582,5,0102EF1202,16:42:43,24/06/20
56580,5,0102EEF7D9,16:42:59,24/06/20
,56580,5,01027F21A2,16:43:03,24/06/20
56579,5,01027F21A2,16:43:07,24/06/20
,56578,5,2A35363537,16:43:15,24/06/20
,56577,5,01027F13C6,16:43:20,24/06/20
,56576,5,2A35363537,16:43:31,24/06/20
,56575,5,0102E22FF3,16:43:35,24/06/20
56575,5,2A35363537,16:43:46,24/06/20
,56574,5,2A35363537,16:43:57,24/06/20
,56574,5,01027F23EC,16:44:06,24/06/20
,56573,5,01027F23EC,16:44:09,24/06/20
,56572,5,0102EF168F,16:44:21,24/06/20

Thank you
new

Post by new »

optional puncuation or optional comma
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Yes, the EasyPattern search.replace

[ lineStart, ',' ]

will do it.
Post Reply