Shorting CSV lines using a column.

[sakis_s]

Hi!
I have some .csv files including different columns.
e.g.


The question is how can i short lines of .csv using a column?
In the above example i would like to short the lines by using "00010101". All lines with column "00010101" have to go on top. Exactly like we're shorting in Excel.

Any help would much appreciated!

[Clark]

There isn't a single macro to do this but you could do this in multiple steps.

I'm using non-GUI commands but there are GUI commands for this.

First delete all lines EXCEPT the lines that need to go to the top. You might need a fancier search string here.

keep-search /;00010101;/

Do a "Save As" to save these lines to a temporary file.

No open your original file again and delete the lines you want at the top.

delete-search /;00010101;/

Now you can use "File>Insert a File..." to insert the temp file at the top.

Hope this makes sense

[sakis_s]

keep-search /;00010101;/

delete-search /;00010101;/

Thank you so much for your response! I get your point and seems to work for me however, i'm new to slickedit & don't know how i use "keep-search" & "delete-search". Is there any tutorial how to use these?

[Dan]

keep-search /;00010101;/

delete-search /;00010101;/

Thank you so much for your response! I get your point and seems to work for me however, i'm new to slickedit & don't know how i use "keep-search" & "delete-search". Is there any tutorial how to use these?

There is a video about it: https://www.youtube.com/watch?v=P6WDBg4C2bY

[sakis_s]

keep-search /;00010101;/

delete-search /;00010101;/

Thank you so much for your response! I get your point and seems to work for me however, i'm new to slickedit & don't know how i use "keep-search" & "delete-search". Is there any tutorial how to use these?

There is a video about it: https://www.youtube.com/watch?v=P6WDBg4C2bY

Thanks Dan! Just tried it & it returns "Unknown Command". Any ideas why?

[Dan]

Can you copy exactly what you ran on the command line?

[sakis_s]

Can you copy exactly what you ran on the command line?

keep-search /;00010101;/

[Dan]

Can you copy exactly what you ran on the command line?

keep-search /;00010101;/

What version of SlickEdit are you running (Help>About SlickEdit)?

[sakis_s]

What version of SlickEdit are you running (Help>About SlickEdit)?

SlickEdit Pro 2015 (v20.0.3.0 64-bit)

[Dan]

This feature was added for 2016 or 2017.  To do it this way you would have to upgrade.

[sakis_s]

This feature was added for 2016 or 2017.  To do it this way you would have to upgrade.

Oh ok, i'll do! Thank you so much for the info Dan. Your help is really appreciated!

[Dan]

You're welcome.

[LBCEi]

@sakis_s

If you could post an excerpt of your text file instead of a screenshot, we might be able to find a simple way to do this in your current version. 

I definitely would encourage you to upgrade, as SE has continued to add a lot of useful features recently.

I created what I think is a representative example of your input data and found that this procedure seems to do what you want to do:

• Block select the column containing the '00010101' data that you want sorted to the top (right-click and drag the mouse or press Ctrl-B and use the arrow keys to select only the column containing the '00010101' values).
  
• Replace ' ' (space) with '9' (Ctrl-H)
  
• Tools>Sort...
• Click the Sort on Selection, Ascending, and Numeric Sort options.  This should put the '00010101' rows at the top
• Replace (Ctrl-H) '9999999' with '       ' (seven spaces).[\li]
  

This should work unless your data actually has seven nines '9999999'  in the real data.

I hope this helps.

[Graeme]

Hi!
I have some .csv files including different columns.

The question is how can i short lines of .csv using a column?
In the above example i would like to short the lines by using "00010101". All lines with column "00010101" have to go on top. Exactly like we're shorting in Excel.

Any help would much appreciated!

Slickedit allows you to sort on a column.  If all the data has fixed width columns like it appears to, you can sort on the column by creating a column selection then use the sort command in the tools menu.  To create a column selection, right click with the mouse then drag  - see "block selections" in the help for other ways.

Once you have a column selection, click "sort" in the tools menu.  Make sure that "numeric sort" is unticked then click ok.

[sakis_s]

Thank you so much for your answers! I really appreciate your help!

Slickedit allows you to sort on a column.  If all the data has fixed width columns like it appears to, you can sort on the column by creating a column selection then use the sort command in the tools menu.  To create a column selection, right click with the mouse then drag  - see "block selections" in the help for other ways.

Once you have a column selection, click "sort" in the tools menu.  Make sure that "numeric sort" is unticked then click ok.

This is exactly what i was looking for! Thank you so much Graeme!