User Profile

Collapse

Profile Sidebar

Collapse
sbothobotho
sbothobotho
Last Activity: Apr 13 '07, 06:19 AM
Joined: Apr 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sbothobotho
    replied to Split a string into multiple fields
    in SQL Server
    Hello

    Thanks for the response, I'm new to databases and i've been going trhough to your reply but couldn't understand what to do. I'll try to simplify what i want to do.
    The data,its an export from another system, and thats the only format i can get it.

    The whole idea here is that I'm trying to spatial refference that information but before i could do that, I need to import it into a database.

    ...
    See more | Go to post

      Leave a comment:

    • sbothobotho
      started a topic Split a string into multiple fields
      in SQL Server

      Split a string into multiple fields

      Hello

      Can someone help me out here, please...
      I want to split a string from a notepad txt file into multiple fields and Import it to a table in SQL Server 2000.

      example
      these are the strings: 001258745659 12457 556987
      Field1: 001
      Field2: 25
      Filed3: 874
      Filed4: 5659

      Field5: 124
      Field6 57
      .
      .
      .
      See more | Go to post
      No activity results to display
      Show More
      Working...