02-17-2010 12:01 AM
Solved! Go to Solution.
02-17-2010 12:47 AM
02-17-2010 01:06 AM
Alana
Can you post the sample string that you wish to convert in to arrays? There are lots of metods available to do it..If they are commas seperated or tab delimeted (or anything similar) then use the "Spreadsheet String To Array" function found in the strings pallete
Guru
02-17-2010 01:07 AM
02-17-2010 01:16 AM
Hello Alana,
Can you please specify the format of the string that you have to strip?
I mean will it have the same pattern of strings preceeding the numbers?
Eg :- if your string is like "KRU 23", "NAL 24", "KRU 25", then you can use scan from string function directly to get the string as well as numeric output.
02-17-2010 01:41 AM
02-17-2010 02:53 AM
here you go alana
02-17-2010 11:35 AM
02-17-2010 12:12 PM