No announcements
Found 2037039 threads
-
1 Votessplit one field to 8 fields
first I suppose the number of delimited values are static.Answered | 9 Replies | 5053 Views | Created by K.Kalyan - Thursday, July 7, 2011 8:52 PM | Last reply by K.Kalyan - Monday, July 11, 2011 7:57 PM
-
0 Votes
XSLT split an incoming delimited value
Hi, Please see the link http://seroter.wordpress.com/2008/10/07/splitting-delimited-values-in-biztalk-maps/, not exactly matching to your issue but quite ...Answered | 2 Replies | 7423 Views | Created by joacim37 - Wednesday, January 27, 2010 9:09 PM | Last reply by Tariq Majeed - Wednesday, January 27, 2010 9:49 PM -
0 Votes
Split two numbers with delimiter
Most language's built-in string functions can do such a split.Answered | 3 Replies | 4043 Views | Created by Savvas Sopiadis - Thursday, August 27, 2009 6:49 PM | Last reply by Savvas Sopiadis - Sunday, August 30, 2009 6:44 PM -
10 Votes
How to split comma delimited string?
At any point of time ID1 will be an int value(only one id in that parameter) and ID2 can have multiple ids delimited by comma.Answered | 22 Replies | 238011 Views | Created by deeptideshpande - Wednesday, October 8, 2008 5:11 AM | Last reply by DotNet_Lead - Wednesday, October 7, 2015 12:23 PM -
2 Votes
Split a field in many occurences
You can also use XPath inside your orchestration to split the record into multiple messages, if you are using orchestrations.Answered | 6 Replies | 5187 Views | Created by Okilele - Thursday, October 21, 2010 10:58 AM | Last reply by callvishnu - Saturday, October 23, 2010 10:30 AM -
0 Votes
Splitting returned sql field.
Yes, there are many splitter functions available online.Answered | 2 Replies | 904 Views | Created by cab806 - Thursday, August 27, 2015 11:59 AM | Last reply by Tomas Ludvik - Thursday, August 27, 2015 12:22 PM -
3 Votes
Separating comma delimited fields
Hi all, I did some more research about this problem and found this link, which describes a process to create a bridge table which I should be ...Answered | 5 Replies | 1870 Views | Created by Gerrard.Hickson - Wednesday, November 12, 2014 11:41 PM | Last reply by greggyb - Monday, November 17, 2014 10:47 PM -
2 Votes
Splitting multiple delimited columns
Split them in your dataset, using a TSQL splitter function: SELECT * FROM table CROSS APPLY dbo.splitter(field_to_split,'&') ...Answered | 6 Replies | 739 Views | Created by RYAN4509 - Thursday, March 24, 2016 3:09 PM | Last reply by Patrick Hurst - Thursday, March 24, 2016 4:40 PM -
5 Votes
writing specific fields of delimited files
Like Joe said, one thing at a time.Answered | 7 Replies | 1746 Views | Created by NINE IRON 08 - Wednesday, August 3, 2011 2:57 PM | Last reply by Frank L. Smith - Wednesday, August 3, 2011 11:46 PM -
1 Votes
Column split value by delimiters (automatic)
Today I have a database that contains many identical tables (same column name and data type).Answered | 18 Replies | 1736 Views | Created by CalloudB - Wednesday, March 11, 2020 8:36 AM | Last reply by CalloudB - Wednesday, March 18, 2020 9:35 AM -
0 Votes
Select - split delimited value
,'varchar(5)') as [TG] from cte CROSS APPLY [x].nodes('i') AS x(i) See this ...Answered | 6 Replies | 2601 Views | Created by Nadim2522 - Sunday, April 15, 2012 11:01 AM | Last reply by Erland Sommarskog - Sunday, April 15, 2012 5:13 PM -
1 Votes
split string with white space as delimiter.
Check this link: http://stackoverflow.com/questions/236129/how-to-split-a-string-in-c and choose whatever method you like the best.Answered | 3 Replies | 31034 Views | Created by infant_coder - Monday, January 30, 2012 12:42 PM | Last reply by Jesse Jiang - Wednesday, February 1, 2012 2:27 AM -
0 Votes
Splitting the Filename field
Basically, you define a delimiter character (in your case, the "["), and the method splits the string using that character (or characters, if you define ...Answered | 1 Replies | 3756 Views | Created by Garry42 - Wednesday, November 16, 2011 1:16 AM | Last reply by Kemp Brown - Wednesday, November 16, 2011 2:22 AM -
0 Votes
comma delimited string field
One or the other, SQL server would unlikely have a chance to use any indexes for this job (except maybe there are some fulltext indexes) and the query would be slow.Answered | 2 Replies | 1251 Views | Created by SashaStacyL - Thursday, July 30, 2015 2:52 AM | Last reply by CetinBasoz_Dont Trust Microsoft - Friday, July 31, 2015 2:09 PM -
0 Votes
Split delimited string into separate columns based on space
I think the easiest thing to do would be to split by space, into columns.Answered | 11 Replies | 5758 Views | Created by ryguy72 - Thursday, January 22, 2015 9:34 PM | Last reply by ryguy72 - Friday, January 23, 2015 2:34 PM -
0 Votes
fn to split concatenated and delimited string into seperate columns
To add an yet one other string-splitting option onto the pile, here is a revised version of a fn_Split function.Answered | 6 Replies | 11147 Views | Created by techytechy - Tuesday, January 12, 2010 2:38 PM | Last reply by RakingTheLeaves - Thursday, July 22, 2010 3:06 PM -
1 Votes
Split delimited string which contains email
try using split function based on delimiter value.Answered | 2 Replies | 1309 Views | Created by Rac19 - Monday, June 3, 2013 5:52 PM | Last reply by Sarat (SS) - Monday, June 3, 2013 6:07 PM -
2 Votes
Splitting field
That's one last question, please :) Thank you.Answered | 24 Replies | 892 Views | Created by roxannaappleby - Thursday, August 17, 2017 2:56 PM | Last reply by Peter N Roth, Author of Ten Commandments of VBA - Thursday, August 24, 2017 6:27 PM -
1 Votes
Can I Split One Field Into Two Seperate Fields?
If all you want to do is split the ExchangeType field into two separate columns, why not just use an IIF statement?Answered | 4 Replies | 658 Views | Created by ryguy72 - Wednesday, June 10, 2015 11:28 PM | Last reply by ryguy72 - Thursday, June 11, 2015 1:42 AM -
1 Votes
Would like to split up a delimited field into columns (like Excel text to columns)
For your particular case with 4 delimiters I will probably just go with the splitting and then pivoting the results.Answered | 7 Replies | 8245 Views | Created by JubileeAnalyst - Tuesday, February 8, 2011 2:24 PM | Last reply by JubileeAnalyst - Tuesday, February 8, 2011 4:28 PM - Items 1 to 20 of 2037039 Next ›
No announcements
