If you come accross issue with Angular ng build in prod mode for out of memory issue, like below
Command: ng build --prod
Include command with "node --max_old_space_size=5120 ./node_modules/@angular/cli/bin/", you can increase the size however wanted. This will solve the issue, we can also update this size in environment variables of system.
Command: node --max_old_space_size=5120 ./node_modules/@angular/cli/bin/ng build --prod
How to use JSON Path to query any JSON object.
For example, consider below simple JSON, if you want to query JSON we can use simply query as this.obj.name or this.obj.id to access to the JSON
this.obj ={
id: 1,
"name": "balaji"
}
For array object we can use index, for ex: this.objData[0].id. For more JSON path to find we can refer https://jsonpathfinder.com/
this.objData = {
data: [
{
"id": 1,
"name": "Balajiprasad",
"age": 18,
"address": {
"state": "TN",
"country": "India"
}
},
{
"id": 2,
"name": "prasad",
"age": 28,
"address": {
"state": "Tx",
"country": "US"
}
}
]}
In angular project, if we need to use JSON path dynamically then we can refer the jsonpath library Ref: https://www.npmjs.com/package/jsonpath
Steps to use,
1. Add "json-path" in package.json file under dependencies
"dependencies": {
"jsonpath": "1.1.1"
}
2. Add reference of "json-path" directly in component. No need to specify in App.module
import * as jp from 'jsonpath'
3. Use the JSON path in code , need to use $.. (double dots)
let state = jp.query(this.objData, '$..data[0].address.state')
In excel, use below formula to get sum of all digits into single digit (For ex: 3268 -> Total 1). This is useful to findout vehicle number's total.
Formula: =IF(MOD(A1,9)=0,"9",MOD(A1,9))
In real world, we will have many PDF files to read the content and prefill the forms in web application. To automatically read this PDF and predict the values, Microsoft offering cognitive service called Form Recognizer. Using this service, we can pass our PDF file and get the extracted OCR values as JSON back with bounding box coordinates.
Ref: https://azure.microsoft.com/en-in/services/form-recognizer/#features
We can use some custom libraries to highlight the bounding box coordinates in UI over the image. For this we can convert PDF into images and display it in UI as well.
For ex:
https://www.w3schools.com/tags/tag_map.asp
Sample JSON extracted: Highlighted sample bounding box coordinates.
{"status":"succeeded","createdDateTime":"2021-02-23T05:09:00Z","lastUpdatedDateTime":"2021-02-23T05:09:11Z","analyzeResult":{"version":"2.1.0","readResults":[{"page":1,"angle":0,"width":1700,"height":2200,"unit":"pixel","lines":[{"text":"CONTOSO LTD.","boundingBox":[114,134,466,134,466,175,115,175],"words":[{"text":"CONTOSO","boundingBox":[115,135,333,134,333,176,115,176],"confidence":0.994},{"text":"LTD.","boundingBox":[357,134,465,134,465,176,358,176],"confidence":0.994}],"appearance":{"style":{"name":"other","confidence":0.878}}},{"text":"INVOICE","boundingBox":[1410,114,1601,115,1601,155,1410,155],"words":[{"text":"INVOICE","boundingBox":[1411,115,1593,115,1592,156,1411,155],"confidence":0.995}],"appearance":{"style":{"name":"other","confidence":0.878}}},.......}
In order to test different Geo Location in browser, we have option to change location in browser. Follow below steps,
Browsers used: Chrome, IE Edge
How to copy one array of JSON object into another array of JSON in SQL. Take this below sample copy array of empIds from one JSON into another JSON
DECLARE @pArrayOfIntEmps nvarchar(max)='{ "empIds": [' + '1,2'+'] }'
--JSON_Query will return array value from json whereas JSON_VALUE return object value from json
--select
JSON_QUERY(@pArrayOfIntEmps,'$.empIds')
DECLARE @info NVARCHAR(max)='{"id":1,"abc":false,"empIds":[3,4]
}'
SET @info= JSON_MODIFY(ISNULL(@info,'{}'),'$.empIds,JSON_QUERY(@pArrayOfIntEmps,'$.empIds'))
select @info
--Output {"id":1,"abc":false,"empIds":[1,2]
}, this empIds will be replaced by array of int
