Any expert in SQL Server - Sajha Mobile
SAJHA MOBILE
Any expert in SQL Server
Posts 3 · Viewed 4310 · Go to Last Post
Mukurdhom
· Snapshot 0
Like · Likedby · 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
marulez
· Snapshot 12
Like · Liked by · 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
Mukurdhom
· Snapshot 32
Like · Liked by · 0

Thank you Marulez... 
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading Any expert in SQL Server
Visitor from US is reading Web Developers Please help!
Visitor is reading When you meet Gay/Lesbian People
Visitor from US is reading ANA sport teams
Visitor is reading DV lottery help needed
Visitor is reading Drunk Driving & shit...
Visitor is reading How to approach a girl?...
Visitor from US is reading |||| |||| चौतारी ७८ |||| ||||
Visitor from US is reading high speed internet in ktm?
You might like these other discussions...
IamDJ » Raj11
TPS Re-registration case still pending ..
· Posts 77 · Viewed 18418 · Likes 16
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 98
NepalNews Sajha
News Summary from Nepal for Saturday, May 18, 2024
· Posts 1 · Viewed 102
Lucky_Nepali
Exciting News for Nepali Students starting school in some NY Colleges and Universities
· Posts 1 · Viewed 261
haal haal pandit » haal haal pandit
Why Americans reverse park?
· Posts 16 · Viewed 3516 · Likes 3
urban khasi
Have any of you traveled to any other countries besides Nepal on TPS travel document ?
· Posts 1 · Viewed 216
Sql_server
YOUE F***KING NEPALI….PAJEET goes on RAGE 😡 mode
· Posts 1 · Viewed 335
haal haal pandit » haal haal pandit
whats wrong living with your parents ?
· Posts 6 · Viewed 921 · Likes 1
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 172
NepalNews Sajha
News Summary from Nepal for Friday, May 17, 2024
· Posts 1 · Viewed 183



Your Banner Here
Travel Partners
Travel House Nepal