Current location: Hot Scripts Forums » Programming Languages » ASP.NET » split cell values with special character or enter while importing

split cell values with special character or enter while importing

Reply

#1 (permalink)

Old

08-11-08, 01:18 AM

vedrajan

vedrajan is offline

Newbie Coder

Join Date: Jun 2008

Posts: 20

Thanks: 0

Thanked 0 Times in 0 Posts

split cell values with special character or enter while importing

Hi!
I want to import excel data into sql, but while importing the data i have to specify the character which i can split it out.So i can use as column in sql database.Can you suggest me how to do this.

Thanks.

Reply With Quote

#2 (permalink)

Old

08-11-08, 01:43 AM

digioz

digioz is offline

Community VIP

Join Date: Oct 2003

Location: Chicago, IL

Posts: 2,171

Thanks: 3

Thanked 9 Times in 9 Posts

Save the data in the excel spreadsheet as "CSV (Comma Delimited) (*.csv)". That way you can specify the comma (",") as the split character.

Pete

__________________

DigiOz Multimedia | My Blog | My Twitter

Reply With Quote

#3 (permalink)

Old

08-11-08, 02:12 AM

vedrajan

vedrajan is offline

Newbie Coder

Join Date: Jun 2008

Posts: 20

Thanks: 0

Thanked 0 Times in 0 Posts

split cell values by special character like new line

HI!
I don't want to split the data into the cell by comma.I want to split the cell data by new line character like (enter).

Thanks

Reply With Quote

Reply

Bookmarks

« Validator ctrl in table cell : Strange behaviour | Append XML document »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with Auto Dealer Script	nuzzle	PHP	17	04-14-10 08:34 PM
How to split out every character in a string?	superman2004	PHP	8	02-21-10 12:04 PM
[SOLVED] Friend to Friend Shortest Path	sandeep.kumar	Database	51	01-15-09 03:12 AM
Wanted to replace special characters in MS Access using VB, but more than 1 character	cebuy	Visual Basic	3	12-04-05 05:30 PM