Get specific line of txt file

KarimBen — Thu, 07 Apr 2022 17:06:51 GMT

Hello,

I merged some txt files, now I need a certain line from a certain file. I hope you can help me.

From this file I need the #Statistics line with all values separated by '|'

Re: Get specific line of txt file

MarcoWedel — Sat, 09 Apr 2022 12:04:41 GMT

Hi,

maybe one solution to extract the Statistics values might be:

tabStatistics: Load File, SubField(SubField(TextLine,'#Statistics:',2),'|') as Values Inline [ File TextLine File1 -1#901,1,2,3,4,5|6,7,8,9|10,11,12,13 File1 -1#901,11,12,13,14,15|16,17,18,19|110,111,112,113 File1 -1#901,21,22,23,24,25|26,27,28,29|210,211,212,213 File1 #Statistics:12345|23456|34567|45678 File2 -1#901,1,2,3,4,5|6,7,8,9|10,11,12,13 File2 -1#901,11,12,13,14,15|16,17,18,19|110,111,112,113 File2 -1#901,21,22,23,24,25|26,27,28,29|210,211,212,213 File2 #Statistics:98765|87654|76543|65432 File3 -1#901,1,2,3,4,5|6,7,8,9|10,11,12,13 File3 -1#901,11,12,13,14,15|16,17,18,19|110,111,112,113 File3 -1#901,21,22,23,24,25|26,27,28,29|210,211,212,213 File3 #Statistics:11111|22222|33333|44444 ] (delimiter is spaces) Where TextLine like '#Statistics:*';

hope this helps

Marco

topic Get specific line of txt file in App Development

Get specific line of txt file

Re: Get specific line of txt file