Sublime Forum

CSV: Formatting lines to start with with a common character string

#1

I want to format a csv to start each row with a 5 digit control number. The 4 columns are: Record Number, Call Number, ID, Date time, created by, comment.

15700,picimlp,01/16/2018 07:38:56,Sometimes the text is very long and drops down to the next line I want it to be a continuous string as oopossed to starting a new line.
15701,picimlp,01/16/2018 07:39:02,Sometimes the text is very long and drops down to the next line I want it to be a continuous string as oopossed to starting a new line.
15702,picimlp,01/16/2018 07:39:09,Sometimes the text is very long and drops down to the next line I want it to be a continuous string as oopossed to starting a new line.
15682,picimlp,01/16/2018 07:35:37,Sometimes the text is very long and drops down to the next line I want it to be a continuous string as oopossed to starting a new line.
15703,picimlp,01/16/2018 07:39:16,Every line should start with a 5 digit control number like this
15704,picimlp,01/16/2018 07:39:25,Every line should start with a 5 digit control number like this

Any Ideas?

0 Likes
#2

The 4 columns are: Record Number, Call Number, ID, Date time, created by, comment

I’m not sure I understand your question because that’s six columns, not four (and four columns is what your example appears to showing).

Does it matter what the control number is?

Sometimes the text is very long and drops down to the next line I want it to be a continuous string as oopossed to starting a new line

This looks like you may be getting kicked in the butt by word wrapping; you uncheck View > Word Wrap to turn that off.

0 Likes
#3

My fault I had 6 columns selected in the program the data was exported from two them were mostly blank so I pulled a new set without them and dropped into Sublime for what ever reason it is still dropping text to a new line even with word wrap disabled. are there any quick ways to join lines. I have about 90,000 rows of data to clean. The last column is a free text field.

18592,"********",“3/22/2018 2:27:40 PM”,"Caller: John Doe
DOB: 1901/01/01
Number: 555-555-5555
Location: Clark or Skamania County
IRF#:

Notes: RP has an oral board scheduled for 4/5 and is requesting a ride along. RP has open availability and will be coming from the Portland area.

No previous violations in CODY
No disqualifying info in DISCIS
Clear and good to go!

Please call - also, I apologize if you have already received this request. RP states he called earlier in the week but I do not see a record that the request was sent out.
"
18573,“picimlp”,“3/22/2018 10:12:55 AM”,“W92 ON ST. RAINIER. C00000J”
18575,“picimlp”,“3/22/2018 10:23:39 AM”,"RECEIVED A CALL FROM JOHN DOE, REF PROBLEM
18593,“picimlp”,“3/22/2018 2:38:07 PM”,"RECEIVED A CALL FROM SMITH ASKING TO SPEAK TO "
18422,“drakrld”,“3/20/2018 12:57:06 PM”,"RECIEVED A CALL FROM A MALE REQUESTING TO

0 Likes