How Can I Fetch Only the 5th Line from a Query to Match the Company String?

Help
21

To return the result as a string, you can use JSON.stringify() to convert the object to a string. Here’s an example: export default defineComponent({ async run({ steps, $ }) { const input = `**first name**: Dylan **last name**: Pierce **company**: Pipedream`; const lines = input.split("\n"); const result = {}; lines.forEach((line) => { const [key, value] = line.split("**: ").map((item) => item.replace("**", "").trim()); result[key] = value; }); return JSON.stringify(result); }, }); This code will return the extracted information as a string: ```
on “{"first name":"Dylan","last name":"Pierce","company":"Pipedream"}”

22

i wat to remove the quotes and : and { and } from this string {“”:“testcompanyname”} by using JSON.stringify(result0).replace() function

23

To remove the quotes, colons, and curly braces from the string {"":"testcompanyname"}, you can use the replace() function with a regular expression. Here’s an example: export default defineComponent({ async run({ steps, $ }) { const input = '{"":"testcompanyname"}'; const cleanedString = input.replace(/[":{}]/g, ''); return cleanedString; }, }); This code will return the cleaned string: testcompanyname.

24

Posted thread to Discourse: How to fetch the 5th line from a query to match a company string?

25

write me a json code which return from this string “lightning/r/a151p00000fZA92AAG/view” only this string “a151p00000fZA92AAG”

26

Here’s a Pipedream component that extracts the desired string from the input: ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const regex = /([a-zA-Z0-9]{15,18})/; const match = this.input.match(regex); const extractedString = match ? match[0] : “No match found”; return extractedString; }, });

27

write me a json code which return from this string ‘{“”:“https://test.lightning.force.com/lightning/r/a151p00000fZA92AAG/view”}’ only this string ‘a151p00000fZA92AAG’

28

Here’s a Pipedream component that extracts the desired string from the input: ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const input = this.input; const regex = /([a-zA-Z0-9]{15,18})/; const match = input.match(regex); const extractedString = match ? match[0] : “No match found”; return extractedString; }, });

29

use return JSON.stringify with your code instead

30

Here’s a Pipedream component that extracts the desired string from the input and returns it using JSON.stringify(): ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const input = this.input; const regex = /([a-zA-Z0-9]{15,18})/; const match = input.match(regex); const extractedString = match ? match[0] : “No match found”; return JSON.stringify(extractedString); }, });

31

remove the quotes from the extractedString

32

Here’s a Pipedream component that extracts the desired string from the input and returns it without quotes using JSON.stringify(): ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const input = this.input; const regex = /([a-zA-Z0-9]{15,18})/; const match = input.match(regex); const extractedString = match ? match[0] : “No match found”; return JSON.stringify(extractedString).replace(/"/g, ‘’); }, });

33

Posted thread to Discourse: How Can I Extract the 5th Line from a Query to Match a Company String?

34

rebuild the node js code which grabs all text between two words, first word is “description:” and the second word is “POLICY:”

35

Here’s a Pipedream component that extracts the text between the words “description:” and “POLICY:” from the input: ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const firstWord = “description:”; const secondWord = “POLICY:”; const startIndex = this.input.indexOf(firstWord) + firstWord.length; const endIndex = this.input.indexOf(secondWord); const extractedText = this.input.slice(startIndex, endIndex).trim(); return extractedText; }, });

36

add to the above code additional code to replace the word “.com99” to “.com”

37

Here’s a Pipedream component that extracts the text between the words “description:” and “POLICY:”, and replaces the word “.com99” with “.com”: ```
export default defineComponent({ props: { input: { type: “string”, label: “Input Text”, }, }, async run({ steps, $ }) { const firstWord = “description:”; const secondWord = “POLICY:”; const startIndex = this.input.indexOf(firstWord) + firstWord.length; const endIndex = this.input.indexOf(secondWord); const extractedText = this.input.slice(startIndex, endIndex).trim(); const replacedText = extractedText.replace(“.com99”, “.com”); return replacedText; }, });

38

make a node js code to sleep for 15 min

39

Here’s a Pipedream component that sleeps for 15 minutes (900,000 milliseconds) using a Promise: ```
export default defineComponent({ async run({ steps, $ }) { await new Promise((resolve) => setTimeout(resolve, 900000)); return “Slept for 15 minutes”; }, });

40

it gave me timeout error