How Can I Extract the 5th Line from a Query to Match a 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, ‘’); }, });