[Show all top banners]

Mukurdhom
Replies to this thread:

More by Mukurdhom
What people are reading
Subscribers
Subscribers
[Total Subscribers 1]

malekhu2009
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 Any expert in SQL Server
[VIEWED 4267 TIMES]
SAVE! for ease of future access.
Posted on 12-01-10 1:53 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 


Hello Gurus

I am banging my head from this morning. Did some google search. Found some example, but not helping me a lot.
Here is the problem

Given string : '152527_OR100006_UHNJ3241159000_1_.pdf'
My task: Parse the string into different column. 
FileID: 152527
SalesOrderNum: OR10006
ItemNumber: UHNJ3241159000
EdiLine: 1
FileType: .pdf

If the size of string was fixed, then it was not a big deal. Size of string is dynamic and "_" underscore is suppose to act as a delimiter. 

Thank you

 
Posted on 12-01-10 2:17 PM     [Snapshot: 12]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

As long as you have delimeter you should be good to go.
My recommendation is to create a function or stored procedure which splits the string depending upon the delimeter and return the result in table.

Here is a solution which might help you: http://www.codeproject.com/KB/database/SQL_UDF_to_Parse_a_String.aspx

Also in stackoverflow:  http://stackoverflow.com/questions/2647/split-string-in-sql

 
Posted on 12-01-10 3:10 PM     [Snapshot: 32]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 


Thank you Marulez... 

 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 60 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
nrn citizenship
ढ्याउ गर्दा दसैँको खसी गनाउच
अमेरिकामा बस्ने प्राय जस्तो नेपालीहरु सबै मध्यम बर्गीय अथवा माथि (higher than middle class)
TPS Work Permit/How long your took?
Travelling to Nepal - TPS AP- PASSPORT
कल्लाई मुर्ख भन्या ?
Morning dharahara
महँगो अण्डाको पिकल्प : कुखुरा र खोर भाडामा लिने
Travelling on TPS advance travel document to different country...
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
मन भित्र को पत्रै पत्र!
Informatica consultancy share
Are you ready to know the truth?
चितवनको होस्टलमा १३ वर्षीया शालिन पोखरेल झुण्डिएको अवस्था - बलात्कार पछि हत्याको शंका - होस्टेलहरु असुरक्षित
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
Does the 180 day auto extension apply for TPS?
Another Song Playing In My Mind
lost $3500 on penny stocks !!!
Guess how many vaccines a one year old baby is given
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters