DataMystic

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 ...

Hi,

Just seen your message!

I think we will almost certainly be purchasing Textpipe PRO - this package seems to be able to everything we could ever want! As we are in the UK, will we need to pay any tax on the prices you quote on your site? How soon after we purchase the software could we have a ...

Using the following code, it is nearly working:

[ capture(csvfield), ',',
capture(csvfield), ',',
capture(csvfield), ',',
capture(csvfield), ',',
capture('CODE', 1+ digits), ',',
capture(1+ lineChar),cr, lf,
capture(csvfield), ',',
capture(csvfield), ',',
capture(csvfield), ',',
capture ...

Thank you for getting back to me - this work just as we needed!

We now have data in the following format:

1,0,09.07.04,18:20:12,CODE39,Len:6,002509
1,0,09.07.04,18:20:13,TAG,4002,0000000102E2803A,
1,0,09.07.04,18:20:16,CODE39,Len:6,002508
1,0,09.07.04,18:20:16,TAG,XX,XX,
1,0,09.07.04,18:20:47 ...

Hi,

I am wondering if Textpipe is able to perform the following task. My data looks like the sample below. Every line has either "CODExxx" or "TAG" in the 5th Column. The data should always follow the pattern "CODExxx", "TAG","CODExxx", "TAG",....etc.

Where there are 2 "CODExxx" lines in a row, is ...