Community

I have a text file that contains all the text like below. My question is how can I break them into column? I want a column with the tablename where contains "abcdefg011" and than all the other text will go to other column.
All the new row begin with# and end with#. and all the "tablename" with ...

bbadmin wrote:In that case, try searching for:

^(.{X}).+

(where X is the width of the column)

and replacing it with:

$1

*****************************************
This is will work!! Thank you so much!

the first column and second column are seperate by a fix spacing. I know I can use \t to seperate them, but I only one the first column only. I need the reg expr to remove all after the first column ending with space.

Column1 Column2 Column3 Column4
12Akd something I dont want Other than first string
dfl6AB something I dont want Other than first string
U9AO something I dont want Other than first string


I only want column1

I have a text file that contrains the data that I need, but I only the first sentense that i will need. I know i can do it using excel but, when the data like 56E6 excel will change it to exponent that is why I need to use reg expression.

Data look like:
12Akd something I dont want Other than first ...

Is there a way to have this expression?

The data are horizontal. For example

SomeData A 1 2 3 5 6 8
AlittleData B 2 41 6 8 9 0
MoreData C 7 8 7 8 0 9
FewData D 4 5 7 98 0

Currently, I can do one line at a time to make them vertical like:

SomeData A
1
2
3
5
6
8

Is there an expression to do all ...

I might left out other two items on the description part, but not confuse as you thought.

Never mind. I figure it out.

Thanks!

I need the entire line.

Capacity: 2090
IP address: 90:400:00
ID: 1234
Status: Good

I am trying to have a regular expression to find and delete those I don't need it. For example.

Summary of this topic.
Capacity: 2090
IP address: 90:400:00
Subnet mask: 255.0.555
Status: Good
ID: 1233

I only want to the whole line for capacity, IP address and I don't need the rest. But, after the ...