String Format VB.NET

 String->  str_otlQuery = select employee_number  from HR.PER_ALL_PEOPLE_F where NATIONAL_IDENTIFIER='{0}'

String.Format(str_otlQuery,"111-11-1111")

Output -> select employee_number  from HR.PER_ALL_PEOPLE_F where NATIONAL_IDENTIFIER='111-11-1111'

Format Large JSON on VSCode;

Cognos download report option in URL; Updating the URL would change the report output

format=xlsxData => Use this format for Excel Data download option.

format=spreadsheetML => Use this format for Excel download option.

list of format options :

CSV,HTML,HTMLFragment,layoutDataXML,MHT,PDF,rawXML,spreadsheetML(Excel 2007 format),XHTML,xlsxData(Excel 2007 Data format), XLWA(Excel 2002 format),XML,singleXLS(deprecated), XLS(deprecated)