Replace function is confusing

[Vincent Tyson]

Hi guys,

Quick one for you, I have a .csv file imported into a table in SQLite3 with 5 columns
User_Name,Email, x ,x, x

I would love to know how to edit the 19,000 email addresses in col b, to omit '@Domain.com'

lets say my example is 19000 users of gmail.com, so the string reads [email protected] , how in this instance can I select '@gmail.com' and replace it with a blank space?

for clarity I want 'col b' to read 'first.last' without the email extension.

I've been digging around a little but I can't find a clear set of instructions for my example.

any help?

[Campbell Ritchie]

Are you using BigTable or have you found an inappropriate forum? Is it possible for the at sign @ to appear twice in a valid email address? Are you using ordinary Java®?
If you are using ordinary Java®:-
Since @ isn't a metacharacter, you might try myEmailAddress.split("@")[0] or myEmailAddress.substring(0, myEmailAddress.indexOf("@")) or similar. Adding spaces should be easy.

[Vincent Tyson]

I am in the wrong forum mate,

I was looking for an SQLite3 forum !

Apologise

[Campbell Ritchie]

Apology accepted. Let's try the general SQL/JDBC forum. And my suggestions earlier aren't much use to you, are they?

[Dave Tolls]

How are you importing the CSV?
Is it the SQLite import, or via some other code (eg Java's JDBC)?