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

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

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