Question

whether the A360 Database command support the Query which applies substring to any column(establishing excel as DB) Example SELECT SUBSTRING([COLUMN],1,5) FROM [Sheet1$$]

  • 21 March 2022
  • 2 replies
  • 15 views

whether the A360 Database command support the Query which applies substring to any column(establishing excel as DB) Example SELECT SUBSTRING([column],1,5) FROM [Sheet1$$]

2 replies

Userlevel 3
Badge +7

Hi @Karthikeyan Palani​ ,

 

Yes, Supported.

 

Example: SELECT SUBSTRING(CustomerName, 1, 5) AS ExtractString

FROM Customers;

 

 

i tried the same established excel as database and called the substring query it is taking indefinite time to execute the query

Reply