Answered

FIND THE LINE IN TEXT FILE

(0) Share

Report

Posted on by PRABA7385

Dear Experts,

I have a text file uploaded in sharepoint which have hundreds of multiple line.

I would like to find only the line that have "{DOWNLINK_INIT {{} dn" and patch it to one of the column named "Choosen". Am I able to do so?

2022-11-28 16:27:47 AAA BBBBBBB {ERT_INIT {{} dn PLD61789 99 9 * last M A}}

2022-11-29 19:27:47 CNA RYRUBBB {DOWNLINK_INIT {{} dn PLD61788 88 4 * last M}}

2022-11-29 19:27:47 CNA RYRUBBB {ERT_INIT {{} dn PLD61789 88 4 * last M 88 A}}

2022-11-29 19:27:47 CNA RYRUBBB {DOWNLINK_INIT {{} dn PLD61789 88 4 * last M }}

Thanks

Categories:

General topics

I have the same question (0)

All responses (21)

Answers (2)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can probably do a get file contents, then a split on line break then filter the resulting array. so:

1. Get file contents

2. a compose action with a return/line break

3. a compose action with with expression split({filecontents},{output from step 2})

4. filter array where the body is the output of step 3 and the filter value is current item contains {DOWNLINK_INIT {{} dn

Was this reply helpful? Yes No
PRABA7385 on at

Like (0)

Report
Copy link

Link copied!

Dear @srduval ,

Thanks. would you please guide me on this? quite unsure on the step 2 & 3

Thanks

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

After your initialize variable add a compose action. for the value just hit "enter/return" This will create the line break. Then add another compose action below that. this time the value is the expression:

split(variables('A'),outputs('Compose'))

By doing the split on the file contents, you are turning your blob of text into a "Table" or an array that can then be analyzed line by line.

Was this reply helpful? Yes No
PRABA7385 on at

Like (0)

Report
Copy link

Link copied!

Dear @srduval ,

Appreciate if you could guide , having error for array:

this is my coding

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Variable A needs to be string/text not array

Was this reply helpful? Yes No
PRABA7385 on at

Like (0)

Report
Copy link

Link copied!

Dear @srduval ,

I managed to make flow success, but the result not as expected: In filter array, I just need to have the whole line that have " {DOWNLINK_INIT {{} "

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

What criteria do you have in the filter array?

Was this reply helpful? Yes No
PRABA7385 on at

Like (0)

Report
Copy link

Link copied!

Dear @srduval ,

Please find attached. Much appreciate your help. Thanks

Thanks

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Before contains place item() instead of output.

Was this reply helpful? Yes No
PRABA7385 on at

Like (0)

Report
Copy link

Link copied!

Dear @srduval ,

Would you please help how to capture below word only? used trim but not working. Thanks

Was this reply helpful? Yes No