Community

Hi!

I'm trying to find the combination "-x

where x is any kind of letter.
how to i write this in the search field?

Thanks,
A.

Thanks a lot!

//A.

Hi!

I have over a million rows where some of the rows start with a letter instead of a "

How can i find these rows?

Thansk in advance!

//A.

No but it starts with ";"

So thanks alot! This worked like charm! You are a lifesaver!

Thank you!

Ok. I'll try to explain it in another way, thanks for being patient by the way.

I have a set of data that contains say 20 fields (columns) on every row. Every row is separated with an "enter"

But, some of the rows are splitted after only the 10th field having the other 10 fields (on that supposed ...

This is how it is now

"field1";"field2";"field3";"field4";"field5"[enter]
;"field6"[enter]

This is how i want it;

"field1";"field2";"field3";"field4";"field5";"field6"[enter]

//A.

Sorry about that. The problem was, since i had rows where there were not suppose to be an [enter] i thought that maybe if i remove all the [enters] including the onces at the end of every row where they're suppose to be and then separate that long one line every number of symbols that i desired ...

Thanks!

But i might have done this the wrong way... see i have some rows that are separated with [enter] when they're not suppose to.

So can i do a search and replace looking for n number of symbols and then replace the [enter] with nothing?

Thanks again!

Hi,

I want to split a line after a certain number of ["].

How to i do this?

Thanks in advance!

//A.