MATLAB: How to remove empty spaces in between text in a cell array

cell arraystext;

I wish to remove the empty spaces in between text in a cell array. Any help would be appreciated . Actual:

Data={'Symbol','Date','Expiry','Open','High','Low','Close','LTP','Settle Price','No. of contracts','Turnover in Lacs','Open Int','Change in OI','Underlying Value '};

Desired:

Data={'Symbol','Date','Expiry','Open','High','Low','Close','LTP','SettlePrice','No.ofcontracts','TurnoverinLacs','OpenInt','ChangeinOI','UnderlyingValue'};

Best Answer

Just use strrep:

>> Data={'Symbol','Date','Expiry','Open','High','Low','Close','LTP','Settle Price','No. of contracts','Turnover in Lacs',  'Open Int','Change in OI','Underlying Value '};
>> strrep(Data,' ','')
ans = 
  'Symbol'    'Date'    'Expiry'    'Open'    'High'    'Low'    'Close'    'LTP'    'SettlePrice'    'No.ofcontracts'    'TurnoverinLacs'    'OpenInt'    'ChangeinOI'    'UnderlyingValue'

If you are planning on using these as fieldnames, then you might like to consider using genvarname instead:

>> genvarname(Data)
ans = 
  'Symbol'    'Date'    'Expiry'    'Open'    'High'    'Low'    'Close'    'LTP'    'SettlePrice'    'No0x2EOfContracts'    'TurnoverInLacs'    'OpenInt'    'ChangeInOI'    'UnderlyingValue'

Related Solutions

MATLAB: How to retrieve the data for a field such as SETTLE_DT from Bloomberg using Datafeed Toolbox 3.1 (R2008a)

The default FETCH call (with no data request flag) returns a structure with the fields shown below. To explicitly get the SETTLE_DT field, you may use the following call to FETCH as an example:

%%%BEGIN CDE%%%

b = bloomberg

data = fetch(b,'USSO1Z Curncy','GETDATA','SETTLE_DT')

%%%END CDE%%%

The default field list when no data request flag is given is as follows:

    'AsOfDate'
    'AskCondition'
    'AskPrice'
    'AskSize'
    'BidCondition'
    'BidPrice'
    'BidSize'
    'Currency'
    'Format'
    'HighPrice'
    'LastMarketCondition'
    'LastPrice'
    'LastPriceTime'
    'LastPriceYesterday'
    'LastTradeCondition'
    'LastTradeExchange'
    'LimitDown'
    'LimitUp'
    'LowPrice'
    'Monitorable'
    'OpenInterest'
    'OpenPrice'
    'Scale'
    'SecurityKey'
    'SessionEndTime'
    'SessionStartTime'
    'SettlePrice'
    'Status'
    'TickDirection'
    'TodaysAsOfDate'
    'TodaysAskPrice'
    'TodaysAskSize'
    'TodaysBidPrice'
    'TodaysBidSize'
    'TodaysHighPrice'
    'TodaysLastPrice'
    'TodaysLowPrice'
    'TodaysOpenPrice'
    'TodaysTotalNumberofTicks'
    'TodaysTotalVolume'
    'TodaysYieldAsk'
    'TodaysYieldBid'
    'TotalNumberOfTicks'
    'TotalVolume'
    'YieldAsk'
    'YieldBid'

MATLAB: How to convert a cell array of datetime to an array of datetime

Try this

array = [cellArray{:}];

[] symbol are necessary to form an array.

Best Answer

Related Solutions

MATLAB: How to retrieve the data for a field such as SETTLE_DT from Bloomberg using Datafeed Toolbox 3.1 (R2008a)

MATLAB: How to convert a cell array of datetime to an array of datetime

Related Question