Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Help using textscan or sscanf
Replies: 21   Last Post: Jan 23, 2013 4:02 PM

 Messages: [ Previous | Next ]
 dpb Posts: 9,850 Registered: 6/7/07
Re: Help using textscan or sscanf
Posted: Jan 19, 2013 4:10 PM

On 1/16/2013 11:30 AM, Kevin Ellis wrote:
...

> Subset001.AccountNumber(1:6,:)
>
> ans =
> '154045001'
> '926665001'
> '615017'
> '1976936151'
> '801700'
> '4506702001'
>
> I am trying to create a new account number in the form of a string. I
> need to append '4412' to the the last 9 digits of the above account
> numbers. So for the results is:
>
> '4412154045001'
> '4412926665001' - Account Numbers have 9 digits so this is easy
> '4412615017' - Only has 6 digits so take the whole account number
> '4412976936151' - Has 10 digits so drop first and append to '4412'
> etc.

...

I only got access to Statistics Toolbox within last couple of weeks so
have virtually no proficiency w/ the DATASET object but...you can do
essentially my previous solution (which was correct except I forgot and
used (end:-9:end) instead of (end-8:end) for the length subscript to get
9 characters to append) from a dataset as--

>> a={'154045001' '926665001' '615017' '1976936151' '801700'
'4506702001'}';
>> D=dataset({a,'acct'});
>> c=char(D.acct);
>> D.newaccdt=cellstr([repmat('4412',6,1) c(:,end-8:end)])

D =
acct newaccdt
'154045001' '441254045001'
'926665001' '441226665001'
'615017' '441215017'
'1976936151' '4412976936151'
'801700' '441201700'
'4506702001' '4412506702001'
>>

I'm pretty sure if you worked at it and w/ more proficiency in the
dataset methods you could probably do it w/o the temporary explicit
array c above.

But clearly you don't need two subsets and sscanf() and all the
rigamarole you're presently going thru...

--

Date Subject Author
1/16/13 Kevin Ellis
1/16/13 dpb
1/16/13 Kevin Ellis
1/16/13 dpb
1/16/13 Kevin Ellis
1/16/13 dpb
1/17/13 dpb
1/17/13 dpb
1/19/13 dpb
1/19/13 dpb
1/19/13 dpb
1/20/13 Kevin Ellis
1/20/13 dpb
1/20/13 james bejon
1/20/13 Kevin Ellis
1/20/13 james bejon
1/21/13 james bejon
1/22/13 Kevin Ellis
1/22/13 james bejon
1/23/13 Doug Schwarz
1/23/13 james bejon